mysql数据库备份及恢复命令mysqldump,source的用法（Mysql database backup and restore command, mysqldump, source usage）.doc

mysql数据库备份及恢复命令mysqldump,source的用法（Mysql database backup and restore command, mysqldump, source usage） Mysql database backup and restore command, mysqldump, source usage Restore a database: MySQL, -h, localhost, -u, root, -p123456, wwwc:\www.sql Backup a database: mysqldump, -h, localhost, -u, root, -p123456, www d:\www2008-2-26.sql The following / is tested in the program //$command = mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip $backupFile; $command= mysqldump, -h, localhost, -u, root, -p123456, guestbook guestbook2-29.sql; System ($command); Echo success; ************************************************ Backup MySQL database commands Mysqldump, -hhostname, -uusername, -ppassword, databasename backupfile.sql Back up the MySQL database as a format with a delete table Backing up the MySQL database as a form with a delete table enables the backup to overwrite an existing database without the need to manually delete the original database. Mysqldump - add-drop-table, -uusername, -ppassword, databasename backupfile.sql Compress and backup the MySQL database directly Mysqldump -hhostname -uusername -ppassword databasename | gzip backupfile.sql.gz Backup some or more tables of the MySQL database 就hhostname - uusername -文件数据库specific_table1 specific_table2 backupfile.sql 同时备份多个MySQL数据库 就hhostname - uusername -–数据库文件databasename1 databasename2 databasename3 multibackupfile.sql 仅仅备份数据库结构 就–没有数据–数据库databasename1 databasename2 databasename3 structurebackupfile.sql 备份服务器上所有数据库 就–所有数据库 allbackupfile.sql 还原MySQL数据库的命令 MySQL数据库hhostname - uusername -文件 backupfile.sql 还原压缩的MySQL数据库 gunzip backupfile.sql.gz | MySQL数据库文件uusername - 将数据库转移到新服务器 就uusername -文件数据库MySQL–|主机= *。*。*。* C语句 几个常用用例： 1。导出整个数据库 就你用户名P数据库名导出的文件名 你根本就dataname.sql P数据名称 这个时候会提示要你输入根用户名的密码，输入密码后数据名数据库就成功备份在MySQL /斌/目录中。 2。导出一个表 Mysqldump -u user name, -p database name export file name Mysqldump, -u, root, -p, dataname, users, dataname_users.sql 3. export a database structure Mysqldump,