Using mysqldump to backup SQL files on the mysql database server:
This is on a Windows 2000 server
From the root directory, backing up a database named "general"
c:/mysql/bin>mysqldump general > c:/general.sql
This creates a text file in the root directory that contains all the
tables and each item in the database.
Using the created text file backup to create the database on a different
create database general;
Database general created.
The operation is very simple. The only thing I can stress is be careful
about where you are. Some of this you run from the DOS prompt and some