Consolidating Hosting
macm said 1 year ago:
Somehow I have ended up with multiple hosting accounts with multiple properties on each. I would like to consolidate some of them onto one but have no idea how to go about it. Help?
Gary A said 1 year ago:
@macm
In order to move sites between hosting accounts, you would need to manually transfer the files. This can be done by downloading and uploading them via FTP. If your sites use any databases, you would need to transfer those as well. Moving databases consists of exporting the database, setting up a new database, and then importing the database content into the new database. Information on working with databases can be reviewed in these articles:
http://support.godaddy.com/help/1487/exporting-a-mysql-database-from-your-hosting-account
http://support.godaddy.com/help/6802/importing-sql-files-into-mysql-databases-using-phpmyadmin
Once the files and on the intended hosting plan, you would need to either remove the domain name from the old hosting plan or cancel the old hosting plan. Information on working with the domain names on a hosting plan can be found in this article:
http://support.godaddy.com/help/article/4688
-Gary
macm said 1 year ago:
Thanks. I am able to download the files via FTP and upload via FTP. I am able to export the database but when I try to import it I am getting the following error:
Error
SQL query:
–
– Database: xyz8
–
CREATE DATABASE xyz8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said:
#1044 – Access denied for user ‘abc’@'%’ to database ‘xyz8′
Am I setting up the database export or import incorrectly?
Gary A said 1 year ago:
@macm
When importing database content, you will want to remove any CREATE DATABASE commands from the file. As the database already exists, trying to create the database again will result in an error. Additionally, we do not allow users to create databases via scripting or programmatically.
-Gary
5 min expected wait time