MySQL Forums
Forum List  »  Perl

Re: Copy mysql database on same machine.
Posted by: Rick James
Date: November 30, 2013 02:30PM

Plan A: Multiple instances of mysqld, on different ports, with separate copies of the data. Your connections need to alter the port.

Plan B: (single instance) Copies of the tables in separate databases. You need to have a different USE statement (or equivalent).

Is you are talking about Plan B, then use mysqldump with the appropriate parameter to avoid including "CREATE DATABASE" in the output. Then use mysql with the database argument to do the load.

Options: ReplyQuote

Written By
Re: Copy mysql database on same machine.
November 30, 2013 02:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.