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.
Subject
Written By
Posted
November 27, 2013 07:16AM
Re: Copy mysql database on same machine.
November 30, 2013 02:30PM
December 20, 2013 10:30AM
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.