中财网对中国文明古迹的描述:MySQL数据库备份和恢复
来源：百度文库 编辑：中财网 时间：2024/04/29 04:19:40
18. 如果您没有修改MySQL的root用户的密码，可在本机登录CactiEZ中文版V10或以SSH方式登录CactiEZ中文版V10。
18.1 未修改密码备份MySQL数据库方法：
# mysqldump cacti > cacti.20110330.sql
# ls
cacti.20110330.sql
说明：mysqldump是MySQL数据库导出命令，cacti是数据库名，cacti.20110330.sql是导出后的文件名。
18.2 已修改密码备份MySQL数据库方法：
# mysqldump -u root -p cacti > cacti.20110330.sql
Enter password:
# ls cacti.20110330.sql
cacti.20110330.sql
说明：-u表示指定用户名，-p表示该用户需要使用密码。输入回车后，在Enter password:后输入root用户的密码，输入时不显示密码或星号。
18.3 未修改密码恢复MySQL数据库方法：
# mysql cacti < cacti.20110330.sql
如果有任何报错，请按以下步骤登录MySQL，删除原有库，新建库，再导入：
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 83
Server version: 5.1.47 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database cacti;
Query OK, 66 rows affected (0.12 sec)
mysql> create database cacti;
Query OK, 1 row affected (0.00 sec)
mysql> exit
Bye
# mysql cacti < cacti.20110330.sql
18.4 已修改密码恢复MySQL数据库方法：
# mysql -u root -p cacti < cacti.20110330.sql
Enter password:
如果有任何报错，请按以下步骤登录MySQL，删除原有库，新建库，再导入：
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 83
Server version: 5.1.47 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database cacti;
Query OK, 66 rows affected (0.12 sec)
mysql> create database cacti;
Query OK, 1 row affected (0.00 sec)
mysql> exit
Bye
# mysql cacti < cacti.20110330.sql