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