mysql 命令 datadir_MySQL 初步安装后更改datadir目录几种方式-阿里云开发者社区

--  否则原新的database不会在新路径体现....

[root@lottery public3306]# /usr/bin/mysql_install_db --user=mysql --basedir=/usr/ --datadir=/data/public3306/db/

Installing MySQL system tables...OK

Filling help tables...OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr//bin/mysqladmin -u root password 'new-password'

/usr//bin/mysqladmin -u root -h lottery password 'new-password'

Alternatively you can run:

/usr//bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Found existing config file /usr//my.cnf on the system.

Because this file might be in use, it was not replaced,

but was used in bootstrap (unless you used --defaults-file)

and when you later start the server.

The new default config file was created as /usr//my-new.cnf,

please compare it with your file and take the changes you need.

WARNING: Default config file /etc/my.cnf exists on the system

This file will be read by default by the MySQL server

If you do not want to use this, either remove it, or use the

--defaults-file argument to mysqld_safe when starting the server

[root@lottery public3306]#  /etc/init.d/mysql start

Starting MySQL....SUCCESS!

[root@lottery public3306]# cd db

[root@lottery db]# ll

总用量 2097172

-rw-rw---- 1 mysql mysql         56 5月  19 15:47 auto.cnf

drwx------ 2 mysql mysql       4096 5月  19 15:46 mysql

drwx------ 2 mysql mysql       4096 5月  19 15:46 performance_schema

drwx------ 2 mysql mysql       4096 5月  19 15:46 test

[root@lottery db]#

②. 通过将原来db目录内内容拷贝到新地址，再更改my.cnf 文件的datadir

--  测试之前将原database，执行create database lottery ，利于迁移后是否正确.