* Liivar Paas > I brought new server and I'd like to copy old database to new > server. MySQL 3.23.41 RH7.2 both machines. > > I copyed /var/lib/mysql to new machine /var/lib/mysql and seems that MySQL > is working I can use databases and insert values into tables. But is just > copying right thing to do?
If there is no update activity on the source, copying is safe, but if updates are being done while you copy, you could get trouble. > Is there any easyest way to do it? I think copying the way you did is the easiest way. It is also easy to use the mysqldump utility: oldbox$ mysqldump olddb > olddb.sql oldbox$ scp olddb.sql newbox:/somewhere/. newbox$ mysql newdb < /somewhere/olddb.sql -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
