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

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

Please submit your request via support ticket and we will use a backup to recreate your account.

How do I move my sites from my old host to IN2HOSTING?

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 provide us with your old login details ex: domain name, cpanel username and password. If you want to move the content of your website to our server, please keep your old account active so we can do so.

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.Open a support ticket and let us know. 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 IN2HOSTING 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 myhosting.
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_myhosting.) 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_myhosting');
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.

IN2HOSTING will always help you solve a database connection error, so please contact us if you still have problems.

Was this answer helpful?

 Print this Article

Also Read

How to view website statistics in cPanel using AWStats

When you have a website online, you may want to check on how many people are coming to your...

How to connect to the MySQL database

Configuration Settings: Host = localhost (Keep this as localhost)Database name =...

CGI center

The CGI Scripts icon is NO LONGER available to use. We apologize for the inconvenience, as cPanel...

403 Forbidden or No Permission to Access

The top reasons for this error are permissions or .htaccess error. PermissionsThe 403 Forbidden...

Image Manager

The Image Manager allows you to view and modify images in your account. You can change the size...