mysqldump

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


[Our portfolio] [A history of Computers and Networks]
[Perl help] [ABAP help] [MySQL help]
[TCP/IP troubleshooting] [HTML help] [Feedback] [Humor]
Advertise on Golden Ink's Georgia Network


In Association with Amazon.com