Home >Database >Mysql Tutorial >Mysql数据库备份和按条件导出表数据_MySQL
Mysql数据库备份和按条件导出表数据_MySQL
- WBOYOriginal
- 2016-06-01 13:47:59907browse
bitsCN.com
Mysql数据库备份和按条件导出表数据 一、备份数据库# mysqldump -u root -p dbcurr>/home/20090219.sql mysqldum为备份命令，-u用户，-p密码，dbcurr数据库名，>备份符，/home/20090219.sql存储数据文件的路径。 注：如果备份远程数据库，只需在-u前加上-h参数加具体IP地址即可。 二、还原数据库# mysql -u root -p dbcurr/20090219.sql mysql为还原命令，-u用户，-p密码，dbcurr数据库名，/home/tablename_less50.sql; dbname为数据库名，tablename为表明，--where=后的内容为导出条件。
bitsCN.com
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：关于MySQL编码的配置_MySQL