Copy Database

[zethon]

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 January 23, 2010 by zethon

[TCH-Bruce]

Upload the backup you made and open a ticket with the help desk and ask them to import it into a new database for you.

[TCH-Dick]

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.