PostPosted: Mon Aug 11, 2003 10:11 pm Post subject: Reply with quote
Sorry for the delay but my server was down for about a week Sad
It's easy as this:

1. Once you are logged in PHPMyAdmin select the database that you want to extract from the drop-down menu on the left side of the screen.
You'll get a table listing from that database.

2. In the upper menu on the right side of the screen should be "EXTRACT" tab. Click that.

2. On the final screen you will be presented with options for saving the file to your computer. Make sure that you select "Structure and data" option, select all tables and check the "Save as file" box. Here you can zip the file if you want.

That's it.

Now for restoring your database on a new server.

1. Create new database

2. Repeat step one from the previous tutorial.
Click on "SQL" tab in the menu.

3. Locate the backup file on your cumputer.

And now you can call yourself SQL master Smile
If you have any problems let me know.