Date: Wed, 13 Jul 2005 09:43:37 -0300 From: wendelmaques <wendel@dotpix.com.br> To: freebsd-isp@freebsd.org Subject: Re: fastest way to duplicate production server? Message-ID: <ACE54F0BA44E6F08A0CBB2BE@[10.0.0.4]> In-Reply-To: <018801c58731$0929f8a0$0aae5218@garrincha> References: <20050712214555.42683.qmail@web53902.mail.yahoo.com> <018801c58731$0929f8a0$0aae5218@garrincha>
next in thread | previous in thread | raw e-mail | index | archive | help
> - to copy over mysql data, you must do a " FLUSH TABLES WITH READ LOCK" > then rsync the data directory over to the test server (/var/db/mysql is If mysql version differ, you can use on the database host: mysqldump -A --all --opt -Q -uroot -p | mysql -uroot -p -hdestination.host.net # you database host | you remote host # you must type mysql password twice # then use mysql_fix_privileges_table We use it to dump databases from old mysql 3 to 4. To dump or redump users files, you can use the fast perl rsync script: drsync -- wendelmaques http://www.dotpix.com.br/~wendel/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?ACE54F0BA44E6F08A0CBB2BE>