How do I backup / restore / move from one cPanel host to another?

How can I restore my site with old/previous content?

Please submit the restore form and we will use a backup to recreate your account.

How do I move my sites from my old host to you guys?

If you just ordered a new hosting plan, you are in luck! We offer free content moves within the first 30 days of signup. Just follow these links to learn more:

Shared Web Hosting
Reseller Hosting
Dedicated Servers (Linux and Windows)

How can I do this myself? (not recommended)

If you are moving away from a host who does not give you cPanel, then the only way to move your site is by uploading and downloading the files manually with a tool such as FTP. You can also request a .CSV or .SQL backup of your databases. You need to contact your soon-to-be-ex hosting company for detailed instructions.

If you are moving from a host who uses cPanel to another cPanel account, please follow these instructions:

  1. Login to your cPanel and click the "Backup" icon.
  2. Click the "Download or Generate a Full Backup" button. This will backup all of your email accounts, files, and MySQL databases.
  3. Leave the drop down on Home Directory and be sure to have a valid email address in the second box. Leave the remaining boxes empty.
  4. Click the "Generate Backup" button and wait for an email confirmation to arrive.

Congratulations, you have backed up your entire site and it is now time to restore your site at your new HostGator account.

  1. Open the email which confirms your backup. Inside it tells you the name of your backup file.
  2. Head to hostgator.com/restore.php and submit the form. We need to know the name of your backup file, and please tell us the file is saved in your Home directory.
  3. Wait for a reply from our administrators that the task is complete.
  4. Once we reply, check our work by visiting your temporary URL. (Some sites will not be fully functional when using this temporary URL.) To make the site 100% functional, you must change the nameservers of your domain to the name servers HostGator provides in your welcome email.
  5. All done! You may repeat this process for any more sites you wish to move.


Getting your database to work after restoring it

After you have restored your database, you might get an error when trying to view your webpage. Examples:

Error establishing a database connection
or
Warning: mysql_connect(): Access denied for user: 'user1_name1@localhost' (Using password: YES) in /home/joe123/public_html/catalog/includes/functions/database.php on line 19
Unable to connect to database server!

What this means is that your database now exists in cPanel, but your website cannot communicate with it. Now is time to assign a database username and reconfigure your website's database settings.

  1. Login to your cPanel and click the "MySQL Databases" icon.
  2. Scroll down till you see MySQL Users > NewUser.
  3. The username can be anything you want. For this example, we will choose gatorboy.
  4. Pick any random password. You won't need to commit this to memory, so go nuts. For this example, nvGHdCC0dCMz can be our database password. Copy the password and keep it ready. Now enter the password twice and then press the "Create User" button.

The user has now been added, but it has not been assigned to a database.

  1. In the same area under MySQL Users you will see a second section called Add User To Database.
  2. Choose the username you just created from the drop down. (Notice that cPanel will automatically prepend your database name with your cPanel username. For this example, we get joe123_gatorboy.) Copy this username and keep it ready.
  3. Next, choose the name of your database and click the "Submit" button. If you don't know which database name to use, skip this step for now.

Now you need to locate your database configuration file.

  • If you have a general error message like the first example, then use our config files article to determine the location.
  • If you have a specific error message like the second example, then the error tells us the location. In our example the error says "in /home/joe123/public_html/catalog/includes/functions/database.php on line 19". That is where you need to go.

It is finally time to reconfigure your website's database settings.

  1. Go to the configuration file and choose to Edit.
  2. Look in the code for a place where your database name is defined. Here is the example of what we see:
    define('DB_NAME', 'user1_wrdp1');
    define('DB_USER', 'user1_name1');
    define('DB_PASSWORD', '5Jmfde%53L');
    define('DB_HOST', 'localhost');
  3. The database name is very important; it must have your new cPanel name in the first part. Update the part before the underscore, but change nothing after the underscore. Example:
    define('DB_NAME', 'joe123_wrdp1');
    If you skipped step 3 while assigning the user to the database, you must go back and complete that step. The value you have for your database name is the correct name to choose in the second drop down. (Don't forget to click Submit.)
  4. Next, get the database username and password you set aside and replace the ones in the file. Example:
    define('DB_USER', 'joe123_gatorboy');
    define('DB_PASSWORD', 'nvGHdCC0dCMz');
    This is the last time you will need this username and password, so you don't need to keep a copy anymore.
  5. The host name is always 'localhost', so make that change if needed.
  6. Save the file and you are done! Refresh your webpage to see if it works.

HostGator will always help you solve a database connection error, so please contact us via live chat or phone if you still have problems.


Article Comments

chris
Hello host gator!

i just want to ask guys,about of back up files.i back up the home directory and database but the forwarders and filter it won't restore after i upload the files then this words will appear on monitor after i upload it fatal "a fatal error or timeout occured while proccessing this directive"

what do i need to do?
hopefully of your reply guys

Thanks,
Chris




HostGator
Simply email support@hostgator.com with the details and tell us where the backup file is saved. We will confirm what you want to do and help you restore the data.


Your comments help us keep the knowledge base updated. This is not a medium for support. If you have questions or need help, please contact us via email, phone or live chat for fast assistance.

Post Comment