Geek asks and answers

Adding an additional MySQL database to the server. Ubuntu

Here is the deal. Removed mysql 5.0.xx and neglect the dump of the data folder that is on the mounted drive.

MySql 5.6.5 is now installed and running, and the data folder works fine in the default directory. I tried to switch the data dir to the my.conf file, but this leads to the error "The server is shutting down without updating the PID file."

I would like my.conf to point to the default data directory and also add an external database to MySQL. So I installed it in mySql 5.0.xx. The only problem is that I created the database using the graphical user interface and indicated that the data would actually be saved on the mounted drive. I cannot figure out how to do this using the command line, and I have not found good sources of documentation or examples.

+3
source share
1 answer

You probably created a symbolic link to the directory on the mounted drive. This is done using the ln command:

cd /var/lib/mysql
ln -s /mounted_drive/data_directory/db_name db_name

Ubuntu MySQL /var/lib my.cnf http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_datadir, .

0

More articles:


All Articles