Merge Database with Another Database WordPress
-
We are taking ownership of our WordPress site are now going to manage it in-house. The company who was previously managing it for us was hosting our site on SiteGround. They sent over a folder with a zip file and an SQL file. I have already imported the “wp-content” file to the site, I just need to import the data from the SQL file into our new database.
I have previously tried to import the SQL file and then change the table prefix in wp-config.php, but after I do this, I can no longer log into the admin portal. I also noticed that the SQL file does not have a user’s table. I also tried changing the prefixes of all of the default tables to match the one of the imported database. Can I merge the two databases so I can still have that users table, or should I let the company know, so they can resend the SQL file?
The blog I need help with is: (visible only to logged in users)
-
It sounds like you are trying to migrate a WordPress site from SiteGround to a new hosting provider. To do this, you need to import both the SQL file and the wp-content folder to the new server.
Regarding the issue with the SQL file, it is possible that the table prefix in the wp-config.php file is not set correctly. If the table prefix is different in the new hosting provider, you need to update it in the wp-config.php file to match the prefix used in the SQL file.
However, changing the table prefix after importing the SQL file can cause issues with the WordPress site, including the inability to log into the admin portal. This is because the user table and other database tables have a specific prefix, and changing it can cause conflicts.
Merging the two databases is possible, but it can be a complex process, and it is best left to experts. The easiest and most reliable solution is to request the company that previously managed the site to provide a new SQL file that includes the users table.
Once you have the correct SQL file, you can import it into the new hosting provider’s database using phpMyAdmin or another MySQL management tool. Then, update the wp-config.php file with the correct database credentials, including the database name, username, and password.
After the migration is complete, you should test the site thoroughly to ensure that everything is working correctly. You should also update any necessary settings, including the site URL, to ensure that the site is fully functional on the new hosting provider.
- The topic ‘Merge Database with Another Database WordPress’ is closed to new replies.
WordPress.com Forums 