Jump to content

Mysql Database Copy


Dark Angel
 Share

Recommended Posts

Hi.

 

I want to do a twin version of my forums. And for, I have to make a perfect copy of the database. But I don't know a lot about databases and I'm only a bit familiar to phpmyadmin...

 

Could anyone help me on that? Just to be sure it's clear, I want to do an exact copy of a MySQL database on the same server. I guess the copy will have a different name than the original...

 

Thanks a lot!

Link to comment
Share on other sites

Hi.

 

You can use phpMyAdmin to make a backup copy of the database, create a new one (with a different name, as you said) and load the backup into the new one.

 

In phpMyAdmin, click the database name and select the "export" tab on the top. Then select all the tables you want to backup (all of them, if you want an exact copy) and export them to a file. Then create the new database, go to the SQL tab and upload the backup file.

 

At the end, you should have a perfect copy of the original database.

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...