MySQL 5 Database Management

1. Data Files
1) MyISAM Table: There are three related files, data file. MYD, index file. myi, target file (definition file). FRM
2) bdb table: contains two files, one. DB data file and one. frm target file.
3) InnoDB table: it has its own target file. frm, but the actual data is stored in the upper-level Directory, which belongs to the same level as the database.

2. Log Files
Error Log: Under the directory c:/program files/MySQL Server 5.0/data/, the. Err File

3. database backup and recovery
Simplest and intuitive method: use the official MySQL administrator GUI tool

1) backup/Restor
Backup table sales to 'C: // temp ';
Restor table sales from 'C: // temp ';

2) For MyISAM tables, three related files can be directly copied (MyISAM tables are independent of the platform and can be directly transferred to other machines)

3) mysqldump backup
Back up mysqldump test sales> C:/temp/backupsales2006_05_05. SQL
Restore test <C:/temp/backupsales2006_05_05. SQL

4) Select into backup
Backup table select * from sales into OUTFILE 'C: // temp // sales. dat'
Restore table load data infile 'C: // temp // sales. dat 'into Table sales

5) mysqlhotcopy backup
Mysqlhotcopy databasename backup_directory_path

6) Database Replication Technology