Thread: transfering server from one PC to another
View Single Post
  #2  
Old 08-30-2004, 04:52 AM
sotonin
Demi-God
  
Join Date: May 2004
Posts: 1,177
Default
mysqldump -u user -p database > database.sql

backs up an entire database.

then on new machine

CREATE database newdb;

use newdb;

source database.sql
Reply With Quote