copy db via phpmyadmin

ok i have a forum ipb and i want to make a duplicate database would i have to download from phpmyadmin and reupload it

or is there a way to copy it in phpmyadmin i want to copys of my db on 1 server so i can work on a seprate forum for testing etc

 

In phpMyAdmin select the database that you wish to copy from the left hand drop down menu.

Click the operation button at the top and under the "Copy Database To" section, fill in a new database name that is unique.

Make sure that "structure and data" is selected and that "CREATE DATABASE before copying" is ticked.

Then click the go button and you should have a copy of the database created under the new database name.

Hope this helps.

 

If that doesnt work you culd always just DUMP the database in an SQL file create a new database in the CP and import the dumped SQL file. But the above method is more efficiant you should only use this method if that fails.

 

CREATE DATABASE `_portal` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;



MySQL said:

#1044 - Access denied for user 'warezcr1'@'localhost' to database '_portal'

 

there is no tool good enoff to do this bigdump gives error after error

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

 

You need to add user warezcr1@localhost rights to use db _portal
basically on localhosts users are called root

 

i cant add username warezcr1 its 7 letters max :|