Previous

TOC

Next

 
ADMINISTRATION

CAUTION

Some commands used on this page are supported only by Mysql server Version 3.23 and up. For detailed information see Mysql online manual.

FLUSH

Using pull down menu select the FLUSH statement parameter: HOST, LOGS, PRIVILEGES, TABLES or STATUS and click FLUSH button.

SHOW

There are five SHOW statements available:

 SHOW STATUS [LIKE pattern]
 SHOW VARIABLES [LIKE pattern]
 SHOW PROCESSLIST
 SHOW GRANTS FOR USER user@host
 TABLE STATUS [FROM database]

Such parameters as LIKE ..., FOR USER, FROM database are used when applicable

ANALYZE, CHECK, REPAIR, OPTIMIZE

These statements are supported by following versions of Mysql server:
ANALYZE TABLES tablelist - 3.23.22
CHECK TABLES tablelist - 3.23.13
REPAIR TABLES tablelist - 3.23.14
OPTIMIZE TABLES tablelist - 3.22.7

First, select database from pull down menu on the right and select tables to apply one of these statements.

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 pull down menu on the right side of the page.
Each user is given his/her dedicated directory where the backup files are stored. The content of this directory is shown on "Restore" page (see below).

In order  to create database backup the following must be selected:

- Database
- Table names or check "Select all tables" checkbox,
- Backup file destination,
- Backup file type,
- Backup file name.

Database - selected from pull down menu on the right
Table names - menu on the right allows multiple selection. Alternatively "Select all tables" checkbox can be selected. Before select tables to be included in backup file you must take in account the following: if  you are connected to a database remotely - on the host other than localhost, the restore procedure may take too long if the file is big enough and data rate of dial up connection is not high.
- 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.
Files of .zip type can be disabled if you don't have Zip utility on your system or have difficulties to set it up to work properly.
- Backup file name can be selected by default (recommended) or it can be the name of your choice. In order to select default name just click "Suggest" button before proceeding to backup. Default file name is organized as following:
username.hostname.databasename.n
where n is running number. For example: root.localhost.mydb.3
NOTE:
1. Don't use extensions such as .gz or .zip even if you are going to create file of these types.  The extension will be added automatically if needed. 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 file username.hostname.databasename.3 already exists.


 

Previous

TOC

Next