mysqldump -u(username) -p(password) (source database name) (table names...) (pipe) mysql -u(username) -p(password) (destination database name)
I used to dump tables to a file and then "source" the file into the new database. This new process goes a lot faster.
1 comment:
Nice one! This simple trick works great. ..and for any other users arriving here, note you can copy the DB to another server with the -h host flag.
.... (pipe) mysql -h(otherserver) -u(username) -p(password) (destination database name)
Post a Comment