Copying a MySQL database FAST

Matthew Frederico mfrederico at gmail.com
Wed Aug 6 09:56:01 MDT 2008


I've had to do this before, since mysql stores it's databases in
directories:

(This is on a fedora or debian box)

# /etc/init.d/mysql stop
# cd /var/lib/mysql (or wherever your mysql data files are located)
# cp -a database_x database_y
# /etc/init.d/mysql start

And voila, you have an exact copy of your database and it's pretty fast.

-- 
-- 
-- Matthew Frederico



More information about the PLUG mailing list