Urgent: DataBase default WordPress Droplet and Import DB by PHPMyAdmin...

April 30, 2015 647 views
Configuration Management MySQL WordPress

Then, after several errors i got it import, but I'm with my doubts because DB had the name of my BLOG.SQL, the DROPLET installed Wrodpress create a DB default with WordPress.SQL name. When I imported it automatically** MERGE?** because it was all mixed up the database, see in the image below


How to rename the tables that indicated in RED, I want remove this: wp_696xx5w6nk I do not know how to godaddy created this ...

2 Answers

I see a couple things here.

1.) It does not appear that you emptied the table before importing your backup. Since the two databases used different table prefix settings you can safely delete the tables that just have the wp_ prefix (the ones not from your import).

2.) Next you will need to update the $table_prefix setting in your wp-config.php file to reflect the table names from your import.

Once you have updated the table prefix you should see the content imported shown in your Wordpress installation.

Hello, dear! Thanks for the answer I modify table_prefix which name? Something else concludes the migration with plugin Duplicator and see how that my blog (blank) normal would be like this http://www.estranhos.info What to do to make this right? Very thanks.

Have another answer? Share your knowledge.