Jump to content

Copying MySQL Database?


Recommended Posts

What's the easiest way to copy a MySQL database?
If you have a GUI tool such as phpMyAdmin then you can use the export tool to generate CREATE statements of your current database. Through code you can use SELECT INTO.
Does it matter if the database is being used when it's copied or should it be done when no one is using it?
Not really, unless you are using Access.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...