[plug] moving mysql database

[Nathan Alberti]

mysqldump [OPTIONS] database [tables]
mysqlimport [OPTIONS] database textfile

eg:

Current Database:
mysqldump -A -a -p mydatabase > mydatabase_backup.sql


New Database:
mysqlimport -p mynewdatabase mydatabase_backup.sql

Or something similar ;)

Nathan.

On Sun, 2 Mar 2003, Jon  Miller wrote:

> Does anyone know how to move a MySQL database from one server to another?  Any doco would be greatly appreciated.
> 
> 
> 
> Jon L. Miller, MCNE, CNS
> Director/Sr Systems Consultant
> MMT Networks Pty Ltd
> http://www.mmtnetworks.com.au
> 
> "I don't know the key to success, but the key to failure
>  is trying to please everybody." -Bill Cosby
> 
> 
> 
> 
>