如何将mysql数据库移动到另一个安装点 [英] how to move a mysql database to another mount point

问题描述

我有一个MySQL数据库，它越来越大，我想将整个数据库移到另一个具有足够存储空间的装载点.我希望传输当前数据，并将新数据保存到新位置.

I have a MySQL database, it is getting larger and larger and I want to move the whole database to another mount point, where I have enough storage. I want my current data to be transferred, and that new data get saved to the new position.

软件堆栈:在FreeBSD 6上运行的MySQL 5

software stack: MySQL 5 running on FreeBSD 6

推荐答案

当然其他答案也是有效的.但是，如果要保留默认配置，请执行以下操作:

Of course other answers are valid. But if you want to keep the default configuration, do following:

1. 停止mysqld
2. mv /var/lib/mysql /var/lib/mysql.backup
3. 在/var/lib/mysql
下安装新分区
4. cp -r /var/lib/mysql.backup /var/lib/mysql
5. 启动mysqld

1. stop mysqld
2. mv /var/lib/mysql /var/lib/mysql.backup
3. mount your new partition under /var/lib/mysql
4. cp -r /var/lib/mysql.backup /var/lib/mysql
5. start mysqld

这篇关于如何将mysql数据库移动到另一个安装点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！