mysql数据库的备份和恢复:
1.以root用户来备份mysql数据库,备份到c:/mysql.sql文件中
mysqldump -uroot -p mysql > c:/mysql.sql
Enter password:
(提示输入root密码,因为是空密码所以就不用输入了)
2.然后以root登录mysql,
查看一下mysql数据库中常用的一张表user表
select user from mysql.user
+------+
| user |
+------+
| root |
+------+
3.对于这张表作一下修改,增加了两个用户:
grant all privileges on *.* to test@localhost identified by '123';
grant all privileges on *.* to test1@localhost identified by '123';
查看下表的变化:
select user from mysql.user
+-------+
| user |
+-------+
| root |
| test |
| test1 |
+-------+
4.恢复mysql数据库
输入exit退出mysql后:输入以下命令
mysql -u root mysql <c:/mysql.sql
5.查看恢复后的表
select user from mysql.user
+------+
| user |
+------+
| root |
+------+
1.以root用户来备份mysql数据库,备份到c:/mysql.sql文件中
mysqldump -uroot -p mysql > c:/mysql.sql
Enter password:
(提示输入root密码,因为是空密码所以就不用输入了)
2.然后以root登录mysql,
查看一下mysql数据库中常用的一张表user表
select user from mysql.user
+------+
| user |
+------+
| root |
+------+
3.对于这张表作一下修改,增加了两个用户:
grant all privileges on *.* to test@localhost identified by '123';
grant all privileges on *.* to test1@localhost identified by '123';
查看下表的变化:
select user from mysql.user
+-------+
| user |
+-------+
| root |
| test |
| test1 |
+-------+
4.恢复mysql数据库
输入exit退出mysql后:输入以下命令
mysql -u root mysql <c:/mysql.sql
5.查看恢复后的表
select user from mysql.user
+------+
| user |
+------+
| root |
+------+