On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <[EMAIL PROTECTED]> 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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
