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:/>cd mysql
c:/mysql>cd bin
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 server:

c:/>mysql
create database general;
Database general created.
use general;
source c:/general.sql

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 from mysql.

More MySQL