|
BACK UP
This function creates backup files similar with those created using mysqldump utility. Backup files are created for the table list selected from the pulldown menu on the right side of the page. These files are kept in user's dedicated directory. The files are not shared with other users
In order to create a backup the following must be selected:
- Database - A database selected from the pulldown menu on the right
- Table names - select one or more tables from the list (or check "Select all tables" checkbox to backup the entire database)
- Backup file destination - backup file can be downloaded and/or kept remotely
- Backup file type - three types are used to create backup file: plain text file, .gz file and .zip file
- Backup file name can be suggested by the program (recommended) or it can be the name of your choice. In order to select default name just hit "Suggest" button. The default file name is built as following:
username.hostname.databasename.n where n is a running number. For example: root.localhost.mydb.3
Then hit `CREATE BACKUP FILE’ button
NOTE: 1. Don't use an extensions like gz or zip. The extension will be added automatically when needed. Thus any extension you use will be treated as a part of file name. 2. There can not be two files with the same name and different extensions. For example you can not create file username.hostname.databasename.3.gz if the file username.hostname.databasename.3 already exists.
|