Jump to content

Copy Database


zethon
 Share

Recommended Posts

Hello,

 

I have a database that I would like to create a copy of on the same domain. I have a database named "forum1" that I would just like a copy of created with the name of "test".

 

I've tried backing up of "forum1" and restoring it to "test" but this doesn't seem to work. I download the backup and then upload the very same .gz file and it seems to lock up. The backup screen has been "Waiting for [domain name]" for a long time now.

 

Is there another/faster way to do this?

 

Thank you.

Edited by zethon
Link to comment
Share on other sites

I'm not sure if I have posted this before but here is the easy way to copy an existing database to a new database via cPanel.

 

*For this example the databases are cpaneluser_existingdb and cpaneluser_newdb

  • Log into cPanel
  • Create a new database named "newdb" via MySQL Databases or MySQL Database Wizard
  • Go to phpMyAdmin and select the database "cpaneluser_existingdb"
  • Select the Operations tab
  • Locate the section labeled "Copy database to"
  • In the text box enter the name of the new database you created, cpaneluser_newdb
  • Select the radio button labeled "Structure and data"
  • Uncheck the box labeled "CREATE DATABASE before copying"
  • Check the box labeled "Switch to copied database"
  • Click the Go button and let the magic happen

 

If you don't feel comfortable doing this, you can always do as Bruce suggested and open a ticket. We will gladly do this task for you.

Link to comment
Share on other sites

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...