还是关于mysql备份恢复的问题
时间:2011-07-04
来源:互联网
我用mysqldump -uroot -p --all-databases > bak.sql;将所有库都做了备份.在恢复时库能被恢复,但用户却没有被恢复.其实生产环境是这样的:mysql和另一个应用软件相结合.在mysql中创建了一个库,又创建一用户,完全拥有这个库的所有权,现在这个库能恢复,但用户却没有被恢复,请问这是怎么回事呢?
作者: yuipr 发布时间: 2011-07-04
mysql> select * from accounts;
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
| registered_on | full_name | preferred_email | contact_filed_on | maximum_page_size | show_site_header | use_flash_clipboard | download_url | download_command | copy_self_on_email | date_format | time_format | display_patch_sets_in_reverse_order | display_person_name_in_review_category | inactive | account_id |
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
| 2011-07-28 07:21:14 | test | NULL | NULL | 25 | Y | Y | NULL | NULL | N | NULL | NULL | N | N | N | 1 |
| 2011-07-28 07:24:30 | gerrit | NULL | NULL | 25 | Y | Y | NULL | NULL | N | NULL | NULL | N | N | N | 2 |
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
2 rows in set (0.00 sec)
查表是有这个用户的啊,需要重置密码,还是重新授权啊.
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
| registered_on | full_name | preferred_email | contact_filed_on | maximum_page_size | show_site_header | use_flash_clipboard | download_url | download_command | copy_self_on_email | date_format | time_format | display_patch_sets_in_reverse_order | display_person_name_in_review_category | inactive | account_id |
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
| 2011-07-28 07:21:14 | test | NULL | NULL | 25 | Y | Y | NULL | NULL | N | NULL | NULL | N | N | N | 1 |
| 2011-07-28 07:24:30 | gerrit | NULL | NULL | 25 | Y | Y | NULL | NULL | N | NULL | NULL | N | N | N | 2 |
+---------------------+-----------+-----------------+------------------+-------------------+------------------+---------------------+--------------+------------------+--------------------+-------------+-------------+-------------------------------------+----------------------------------------+----------+------------+
2 rows in set (0.00 sec)
查表是有这个用户的啊,需要重置密码,还是重新授权啊.
作者: yuipr 发布时间: 2011-07-04
现在可以了,看来是犯了个小错误,恢复了mysql没有重启,周末公司停电,所有服务都重启了,今天早上来就可以了.
在备份和恢复时都需要停掉mysql么
在备份和恢复时都需要停掉mysql么
作者: yuipr 发布时间: 2011-07-04
备份和恢复的时候,不需要停mysql服务
作者: 909413335 发布时间: 2011-07-04
flush privileges.
作者: andrefun 发布时间: 2011-07-04
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28