Transferring MySQL Database From One Hosting Account To Another Issue!!
jkrysto said 1 year, 1 month ago:
I have one Godaddy account and linux hosting. On that I have a MySQL Database with Wordpress installed on it. I created a wordpress site and now I’m wanting to transfer that to an entirely new hosting account on a different GoDaddy account.
I’m following the instructions for exporting the Database and I save the sql file locally. Then I go into my new account where I’ve created a new Database. I’m attempting to upload that sql file using the import feature.
For some reason it just keeps timing out and never uploads. Is there any explanation for this? I’ve been following the how to’s on here but just not working.
Any suggestions? Thanks
steves said 1 year, 1 month ago:
@jkrysto
I would advise backing up and restoring the database through the Hosting Control Center instead of phpMyAdmin. You will want to create the backup, download it to your computer, upload it to the new hosting plan, and then restore through the Hosting Control Center. The following link has steps on how to backup and restore databases through the Hosting Control Center.
http://support.godaddy.com/help/article/5648
Hope this helps!
-Steve
jkrysto said 1 year, 1 month ago:
Hi Steve,
Thanks I went and did it that way and I’m able to get the previous database saved and restored on the new database under the new hosting account.
I also went on the wp-config file for wordpress and updated the entries for DB Name, User, Password and Host to the new created database.
So now when I go to the new domain I would think it should point to the new database and show the website on the new domain correct?
All I’m receiving is “Error Establishing Database Connection” on the homepage. I’ve re-checked all inputted DB_User, DB_Name, DB_Password and DB_Host info on the config file as correct.
Is there something else I would have to do to have Wordpress integrate with the new database?
Gary A said 1 year, 1 month ago:
@jkrysto
As long as those 4 settings have been updated, you should not have any issues accessing connecting to the database on the new hosting plan. One thing to keep in mind is that the database name and the database username will be the same. You might also want to try resetting the password for the database. Information on resetting the password can be reviewed in this article:
http://support.godaddy.com/help/3310/resetting-your-mysql-database-password
-Gary
0 min expected wait time