我不想放在默认的路径下,想放在指定的路径,不知道如何设置
谢谢
MySQL创建数据库的时候如何指定数据文件所在的位置?
-
- 帖子: 58
- 注册时间: 2007-03-08 17:02
-
- 帖子: 356
- 注册时间: 2007-02-15 6:26
-
- 帖子: 58
- 注册时间: 2007-03-08 17:02
-
- 帖子: 1
- 注册时间: 2010-08-26 9:50
Re: MySQL创建数据库的时候如何指定数据文件所在的位置?
你需要将 mysql、test两个数据库目录弄到你修改的新目录下面!我在windows下也遇到过这个问题,就是这样解决的
- 木泥黑
- 帖子: 1339
- 注册时间: 2008-10-18 12:41
Re: MySQL创建数据库的时候如何指定数据文件所在的位置?
代码: 全选
[ubuntu]change mysql data directory
一
1、 /etc/init.d/mysql stop
2、 chown mysql:mysql newdir
vim my.cnf:datadir=/var/lib/mysql ------- > datadir=/newdir
3、cp -a /var/lib/mysql/* /newdir/*
4、vim /etc/apparmor.d/usr.sbin.mysqld
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/newdir/mysql/ r,
/newdir/mysql/** rwk,
5、 /etc/init.d/mysql start
二
* Open the terminal
* Stop MySQL with the command
/etc/init.d/mysql stop
* Copy the existing data directory (which is located in /var/lib/mysql) using the command
cp -R -p /var/lib/mysql /usr/new_datadir
* All you need are the data files. Delete the others with the command
rm /usr/new_datadir
(You will get a message about not being able to delete some directories, but do not care about them)
* Edit the MySQL configuration file with the command
vim /etc/mysql/my.cnf
* Find the entry for datadir, change the path to the new data directory.
* But there is a trick involved here. Ubuntu uses some security software called AppArmor that specifies the areas of your filesystem applications are allowed to access. Unless you modify the AppArmor profile for MySQL, you'll never be able to restart MySQL with the new datadir location.
* In the terminal, enter the command
vim /etc/apparmor.d/usr.sbin.mysqld
* Copy the lines beginning with /var/lib/mysql
* Comment out the originals with hash marks (#), and paste the lines below the originals.
* Now change /var/lib/mysql in the two new lines with /usr/new_datadir. Save and close the file.
* Restart the AppArmor profiles with the command
/etc/init.d/apparmor restart
* Restart MySQL with the command
/etc/init.d/mysql restart
* MySQL should now start without any errors and your data will be stored in the new location. See also article Linux Ubuntu move mysql database to other path in 5 minutes