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

April 30, 2015 1.9k views
Configuration Management MySQL WordPress
gilsoninacio
By:
gilsoninacio

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

http://postimg.org/image/9qhyj6ipr/

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

Log In to Comment
2 Answers
ryanpq MOD April 30, 2015

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.

Reply
gilsoninacio April 30, 2015

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 http://104.131.5.96 (blank) normal would be like this http://www.estranhos.info What to do to make this right? Very thanks.

Reply
Have another answer? Share your knowledge.

Related Questions