ADMINISTRATIONCAUTION 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.
|