search

Home >Database >Mysql Tutorial >深入解析Linux下MySQL数据库的备份与还原_MySQL

深入解析Linux下MySQL数据库的备份与还原_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:25:271074browse

bitsCN.com

深入解析Linux下MySQL数据库的备份与还原
1. 备份
[root@localhost ~]# cd /var/lib/mysql (进入到MySQL库目录，根据自己的MySQL的安装情况调整目录)
[root@localhost mysql]# mysqldump -u root -p voice>voice.sql，输入密码即可。

2. 还原
法一：
[root@localhost ~]# mysql -u root -p 回车，输入密码，进入MySQL的控制台"mysql>"，同1.2还原。

法二：
[root@localhost ~]# cd /var/lib/mysql (进入到MySQL库目录，根据自己的MySQL的安装情况调整目录)
[root@localhost mysql]# mysql -u root -p voice

mysqldump: Got error: 1016 when using LOCK TABLES
hitidea是一个有很多数据表的数据库（Wordpress MU），搜索了一下，发现只要在mysqldump的时候加上

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL中触发器入门简单实例与介绍_MySQLNext article：sql语句中like的用法详细解析_MySQL

Related articles

See more