Thursday, February 28, 2008

MysqlDump in Different Way

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

No comments:

Post a Comment