• WEBSITECM IS NOW
    Smack Digital Inc.

How To Move X-Cart Database

Posted by and last updated Jan 6, 2014 11:23 PM

This tutorial will take you step by step how to transfer your X-Cart database from its current server to a new server.


SERVER1: The server on which your X-Cart currently resides.
SERVER2: The server to which your X-Cart is being moved.

Step 1 - Back Up The Current Database

Telnet/SSH into SERVER1.

Type:

mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

In this command, change the following:

USERNAME: The username you use to access MySQL. It is specified in your config.php file.
DATABASENAME: The database which your X-Cart is installed into. It is specified in your config.php file.
/PATH/TO/DUMP.SQL: The server path to the file that will be created.

Once you press enter, you will be prompted for the password you use to access MySQL. This is also specified in your config.php file. Once it has returned to the prompt, verify that DUMP.SQL exists in the directory you specified. If you did not specify a full directory, the file will be in the directory you are currently logged into.


Step 2 - Transfer To The New Server

While logged into SERVER1.

Type:

ftp SERVER2

In this command, change the following:

SERVER2: the host name (www.example.com) or IP address of the new server.

You should be prompted for a username and password. This is the username and password that you use to login via FTP to your new server.

Type:

bin
cd /PATH/TO/NEW/DIRECTORY
put /PATH/TO/DUMP.SQL

In this command, change the following:

/PATH/TO/NEW/DIRECTORY: The path to the directory in which you want to place the database backup. If you are unsure what to specify here, you can often omit this command.
/PATH/TO/DUMP.SQL: The same path that you specified in step 1.

Once these commands have finished, type:

close
quit


Step 3 - Restore On The New Server

If necessary, create the database which your X-Cart will be installed in. Refer to your host for specific information on how this is done. (Can usually be done through a control panel such as Plesk or CPanel). Telnet/SSH into SERVER2.

Type:

mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL

In this line, you should change the following:

USERNAME: The new username which you will use to access MySQL. If you do not know this value, you should contact your host.
NEWDBNAME: The name of the new database that you created in the first part of this step.
/PATH/TO/NEW/DUMP.SQL: The path to the backup file that you transferred to this server in step 2.

Step 4 - Edit your X-Cart config.php

If your mysql host, username, or password has changed on your new server, will need to open the config.php of SERVER2 and change the values of the database information.


About the Author

Jonathan Peters Jonathan's founder of Smack Digital, a digital strategy agency that creates and executes online business success for executives who are highly motivated to quickly increase their market share. With more than two decades of experience on the web for clients ranging from non-profits to billion dollar enterprises, Jonathan's an expert in web development, eCommerce, software programming, search engine optimization and social media marketing.

Browse By Category

RSS Feeds

Don't miss out! Subscribe to our RSS Feeds to receive instant notification when new entries are added.

RSS Feed for All Categories
RSS Feed for X-Cart How-Tos
We choose our clients selectively.
Let's talk success. Apply to work with us.
Apply toWork With Us
Apply toWork With Us