It is recommended to regularly back up your X-Cart store database. You do not need to have much knowledge in mysql database administration to make database backup copies or to restore the database. X-Cart shopping cart software provides you with a convenient tool making database backup/restoration as easy as a few clicks.
Click on DB Backup/Restore in the Administration Menu. The 'Database Backup/Restore' form will appear.
Picture 1: Database backup and restore form.
Refer to the 'Backup database' subsection. Do one of the following:
• Save the file on your local computer (Click on Generate SQL file, the save file window will appear. Choose the name for the SQL file and the location to which your backup file should be saved. Click on Save).
• Save the file on the server (Select the check box offering to save your backup file to xcart/log/xcartdump.sql, click on Generate SQL file). This may be convenient if your database is very large and you prefer to download it later using your FTP client.
The generated backup file can be used at any time later on to restore your database.
Click on DB Backup/Restore in the Administration Menu. The Database Backup/Restore form will appear.
Refer to the 'Restore database' subsection.
• If you have a backup file which is located on your local machine and which you want to use for database restoration, click on Browse, use the 'Select file' window to locate the SQL file, click on Open. Click on Restore from file.
Picture 2: 'Restore database' subsection of the 'Database Backup /Restore' form.
• If you have the file xcartdump.sql located inside xcart/log/ directory on the server, which you want to use for database restoration, the 'Restore database' subsection displays Restore button. Click on this button to restore your database.
Note. If the button is not displayed in the 'Restore database' subsection, make sure the file xcartdump.sql is inside xcart/log/ directory.
Picture 3: 'Restore database' subsection of the 'Database Backup /Restore' form.
Note. When you restore the database all existing tables are overwritten. Always make a backup copy before restoring the database.
Note. The database backups of different X-Cart versions are not compatible.
Related topics: