Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Tim McDaniel (tmcdpanix.com)
Date: Mon Mar 10 2008 - 15:40:27 CDT
On Mon, 10 Mar 2008, Daniel Brown <parasanegmail.com> wrote:
> On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <terrylambton.on.ca> wrote:
>> If I use the method below, will that transfer the mysql admin database
>> too with the user information?
>> 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
To expand on that:
mysqldump outputs plain SQL statements, which are readable text unless
you have character data or identifiers that are UNICODE or something.
(You can deduce that by noting that "mysql" is the normal CLI-type
interface, and the pipe just feeds the output of mysqlsump into mysql
as if you'd typed the CREATE TABLE, INSERT, etc. commands yourself.)
So if you have any questions about what mysqldump outputs, you can
feed its output into a pager program like "less" or "more", or into a
temporary file, and just look at it.
One way to reduce a mountain of output would be to just mysqldump
specific databases or tables.
Tim McDaniel, tmcdpanix.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql