Log in please:
Login:
Password:
Login
 
Remind Password

X-Cart Mods Categories:
X-Cart Administration Mods
X-Cart Appearance Mods
X-Cart Conversion Mods
X-Cart Customers Mods
X-Cart Integration Mods
X-Cart Marketing Mods
X-Cart Navigation Mods
X-Cart Packages Mods
X-Cart Search Mods
X-Cart SEO Mods
X-Cart Shopping Feeds Mods
X-Cart Upselling Mods



X-Cart Templates Themes:
Auto Templates
Books Templates
Clothes/Footwear Templates
General Templates
Health/Drugs Templates
Kids Templates
Mobile Templates
Music/MP3 Templates
Software Templates
Sport Templates
Tech Templates


X-Cart Tutorial: Moving X-Cart Database


 

This tutorial will take you step by step how to transfer your x-cart database from it's current server to a new server.

Legend:
SERVER1 - The server that your x-cart is currently on.
SERVER2 - The server that x-cart is being moved to.


Step 1 - Back Up The Current Database

  1. Telnet/SSH into SERVER1.

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

    In this line, you should change the following:
    USERNAME – this is the username you use to access MySQL. It is specified in your config.php file.
    DATABASENAME – the name of the database which your X-Cart is installed into. It is specified in your config.php file.
    /PATH/TO/DUMP.SQL – this is the path to the file that will be output to.

  2. 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.

  3. 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 in.

Step 2 - Transfer To The New Server
  1. While still telnet/SSH'd into SERVER1.

    Type:
    ftp SERVER2
    Replace SERVER2 with 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.
  2. Type:
    bin
    cd /PATH/TO/NEW/DIRECTORY
    put /PATH/TO/DUMP.SQL

    Here you should change the following:
    /PATH/TO/NEW/DIRECTORY – this is the path to the directory in which you want to place the database backup. If you are unsure what to specify here, you can usually omit the entire cd /PATH/TO/NEWDIRECTORY/ command.
    /PATH/TO/DUMP.SQL – this is the same path that you specified in step 1.

    Once these commands have finished, type:
    close
    quit

Step 3 - Restore On The New Server
  1. 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).
  2. Telnet/SSH into SERVER2.

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

    In this line, you should change the following:
    USERNAME – this is 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 – this is the path to the backup file that you transferred to this server in step 2.

Step 4 - Edit your X-Cart config.php
  1. 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.
Add Comment