Question
Error 1050 (42S01) restore database
Hello
I am migrating my site from interserver shared hosting to your digital ocean server.
I have created the droplet and installed wordpress (by using your 1 click wordpress install feature).
Wordpress was working fine on my localhost.
After that i started the migration process.
By using filezilla i have copied my wp-content folder to my server.
After that i just have to restore my database.
As i have no technical knowledge. I can’t install phpmyadmin on server. I have followed your post on “How to migrate wordpress site to our server.” And i found this command.
mysql -h localhost -u databaseuser -p databasename < backup_db.sql.gz
{I have replaced database user, database name and the file name}
After entering that command i am getting this error.
Error 1050 (42S01) at line 28: Table ‘wp-commentmeta’ already exists
Please help me to restore my database and in resolving this issue.
Thank You
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×