[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Moving a MySQL database



At 2003-08-22T15:03:33Z, Roberto Sanchez <rcsanchez97@yahoo.es> 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: pgpljGGuUkW2I.pgp
Description: PGP signature


Reply to: