Database Error when importing WordPress site

  • I have been trying to move a wordpress site to a new host (the old host is now gone) I downloaded all of the files, and a backup of the database and I have followed these steps.. https://www.wpexplorer.com/migrating-wordpress-website/

    However, when I try to import the database to the new host I just get an error message as follows :

    Error
    SQL query:

    —
    — Table structure for table wp_commentmeta
    —
    DROP TABLE IF EXISTS wp_commentmeta ;

    MySQL said: Documentation

    #1046 – No database selected

    Is

    I am not expereinced with databases so I need very basic advice

Viewing 1 replies (of 1 total)

  • Did you first go to cPanel > MySQL and make a database, SQL user and password (ultimately matched in wp-config.php)? A set of tables is often called a “database”, but a set of tables first needs an actual database (shell or container or whatever you might call that) at the server before phpMyAdmin can be used to import tables. Or…

    If you already have a database at the server and it already contains tables with the same table_prefix you are trying to import, you will first have to drop its current tables so you can then import your replacement.

    note: Always, always make a full export backup of tables before changing anything in a database.

Viewing 1 replies (of 1 total)
  • The topic ‘Database Error when importing WordPress site’ is closed to new replies.

Tags