From: Tim McDaniel (tmcdpanix.com)
Date: Mon Mar 10 2008 - 15:40:27 CDT

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

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
> information.

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

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