On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
