Re: switch more datadir

[biagio rea]

thank you Peter Brawley for Answer

to duplicate the folder I used the cp command with the -a option

I will list the steps, it is possible that there is something wrong or something is missing

first stop the service
sudo service mysql stop

then duplicate the folder
sudo cp -a -R /var/lib/mysql/ /var/lib/mysql2/

rename the /var/lib/mysql/ so that it can not be damaged
sudo mv /var/lib/mysql/ /var/lib/mysql_orig/

set the new datadir
sudo gedit /etc/mysql/my.cnf
datadir = /var/lib/mysql2

restart
sudo service mysql start
start: Job failed to start !!!!!