Glossary Item Box
The database files used by Squirrelcart are plain text format, and have the file extension ".sql". A SQL file contains query statements that can be used to alter your database. You can also use database backup files to restore your database to a previous state. There are a few ways to import database files. We will discuss the most common methods below. Please take caution when overwriting an existing database with new data.
Squirrelcart's control panel backup utility is designed to import database files on top of your existing database, and is usually used to upgrade to a newer version. You can also restore a complete database backup on top of your existing backup if the backup was created with the add drop table option. This causes MySQL to delete your existing tables before attempting to replace them with the versions from the backup file. You cannot restore a database backup to an empty table using the control panel.
This section explains how to import a database file 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.
mysql -ufred -pwilma my_database < mybackup.sql
© 2001-2017 Lighthouse Development. All Rights Reserved.