There are a few ways to backup your database. We will explain the most common methods in this topic.
Squirrelcart includes a backup utility that utilizes the mysldump command on your server. DB backups are created inside the sc_data/sc_backup folder. By default, the sc_data folder is located inside your squirrelcart folder. We recommend that you move the sc_data folder so it is above your web root folder. This will ensure that your backup files are not web accessible.
- Click the Backup menu link
- Click the
button. You will see the following section appear:
- Change the name of the backup file if you wish. If you would like this backup to be able to replace your existing database records when imported, check the Add drop table field.
- Click Create Backup. You should see something like this:
- If you would like to keep a copy of your backup on your computer, click the
button. You will be prompted to save the file.
phpMyAdmin is an Open Source database management utility. It is available for download for free at http://www.phpmyadmin.net. Many webhosts include a working copy of phpMyAdmin inside your hosting control panel.
Because many different versions of phpMyAdmin have been released, this should only be considered a guide. The exact steps may vary depending on your version.
- Open phpMyAdmin
- Select your database in the left navigation frame if it is not already selected.
- Click the Export tab
- Check the Save as File field, and click the Go button to start the backup.
- You will be prompted to save the backup file. Save it in a secure location.
- Open the backup file using a text viewer (Notepad, Wordpad, etc..) and confirm that you see information that looks complete.
This section explains how to perform a backup from either a Unix/Linux or Windows command prompt. The steps involved to access a command prompt vary depending on your OS, and will not be discussed here.
- Open your command shell application
- Navigate to folder that contains the "mysqldump" command.
- Enter the command to mysqdump as follows:
mysqldump -ufred -pwilma my_database > mybackup.sql
In the above example:
- fred is the username with access to the database
- wilma is the password for that account
- my_database is the name of the database
- mybackup.sql is the name of the file you wish to use for the backup.
The first 3 parameters match the information you entered in Squirrelcart's config.php file.
© 2001-2017 Lighthouse Development. All Rights Reserved.