Matthew Frederico wrote:
# /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.
No, you have a corrupt database. Remember, these are InnoDB tables. You
can't just do the copy like that unless you have ISAM or MyISAM tables.
--Dave
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
