At 2003-08-22T15:03:33Z, Roberto Sanchez <[EMAIL PROTECTED]> writes:

> I have a MySQL database residing on a RH9 server.  I have started building
> a Debian server running woody to replace it.  Is there an easy way to grab
> the whole database and move it over as is?

1. Type: `mysqldump -u root -p -A --opt > file.sql'.

2. Load the new server with: `mysql < file.sql'

3. Connect to the new server and type: `flush privileges' to load the user
   tables that you imported in the previous step.

4. Sit back and smile.
-- 
Kirk Strauser

Attachment: pgp00000.pgp
Description: PGP signature

Reply via email to