Richard Korts
asked on
Make copy of Database
If I want to make an exact copy of a MySQL database from one place to another, can I just export all the tables (in sql format), save to my local machine, create a new databae on a different place & just import all the content from the exported file (or files)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Log on to your MySQL shell from the command line and execute the following commands:
Open in new window
Substitute "db1" and "db2" with whatever names are appropriate.