文章标题 原创 翻译 转载 文章内容 # 备份恢复单个表 ## dump ``` mysqldump db_name table_name > table_name.sql ``` ## 远程dump ``` mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql ``` ## 恢复 ``` mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql ``` 或者,一行的写法 ``` mysql -u username -p db_name < /path/to/table_name.sql ``` # 备份恢复压缩表 ## dump ``` mysqldump db_name table_name | gzip > table_name.sql.gz ``` ## restore ``` gunzip < table_name.sql.gz | mysql -u username -p db_name ``` 文章类别 Python Mobile Android Java Shell Life Database Bug Windows IOS Tools Boost Node.js Mac Product Tips C/C++ Golang Javascript React Qt MQ MongoDB Design Web Linux LLM ChatGPT RAG AI 提交