unplug <[EMAIL PROTECTED]> wrote: > > By default, data dir is located at /var/lib/mysql. I have run mysql > for serveral month with data in that path. Now, I want to move all > database data to another path, say /var2/lib/mysql. What is the > suitable purpose to do it? Is it only shutdown mysql and move all data > file from /var/lib/mysql to /var2/lib/mysql and startup again? Any > experience to share?
You must specify path to the new data dir in my.cnf or with --datadir option of mysqld and then start the server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
