Having problems transferring MySql

[schoolboy]

It's relatively straightforward, but great care needs to be taken in phpMyAdmin... mistakes are not forgiven...

First step is to create a new MySQL database in your C-Panel admin area.

I trust you know how to do this? Most C-Panel interfaces have a video tutorial for this.

Even so, you can create a NEW database - call it " zentwo " if you like... it does not matter what you call it.

Then ASSIGN the current USER to that new database, and give the user all privileges.

...

Now you have a NEW, (but empty) database, called zentwo . It will have a USER with all privileges.

--------------------------------

Now, go back to C-Panel MAIN SCREEN, scroll down to database management icons and click phpMyAdmin.

When you get to phpMyAdmin main screen it will load a LEFT MENU and a RIGHT FRAME.

In the LEFT MENU you will see all current databases, of which the following should be there:

youraccount_zc1
youraccount_zentwo

(where "youraccount" is your host account prefix)

Click on the original database --- zc1 database to open it. The screen will refresh and show the tables down the left column and the structure in the right frame.

At the TOP of the right frame is a menu. Click the OPERATIONS link.

You will see this:


When you have filled in as shown, click GO.

A new (identical) database will be create inside "zentwo ".

NOW, you copy your FILES to a sub folder.

You then edit the CONFIGURE.PHP FILES to point the copied system to the NEW database !!! (This is very important).