From: Daniel Brown (parasanegmail.com)
Date: Mon Mar 10 2008 - 15:13:19 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <terrylambton.on.ca> wrote:
> Thanks to all for the quick replies.
>
> Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now!
>
> If I use the method below, will that transfer the mysql admin database
> too with the user information?
>
> Thanks,
> Terry

> nohup mysqldump -h<host of Linux Machine> -u<username> -p<password>
> --all-databases --routines --triggers | mysql -h<host of Windows
> Machine> -A

    Yes, the --all-databases flag recursively copies all databases and
tables, including the 'mysql' database with user and time zone
information.

--
</Dan>

Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]