From: Dan Nelson
Date: March 5 2005 12:01am
Subject: Re: mysqldump vs. 'mysql [db] > file.sql'
List-Archive: http://lists.mysql.com/mysql/180907
Message-Id: <20050305000118.GB2272@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 04), Stembridge, Michael said:
> mysqldump vs. 'mysql [db] > file.sql'
> 
> I stumbled across the latter method early on but notice that most
> folks suggest using mysqldump instead; are there performance benefits
> with using mysqldump, or some other reason?

The latter can't generate a dump the way mysqldump can.  You can get
the definition with "show create table", but there's no way to
automatically generate INSERT statements with correctly-escaped output.
 
> The same question could be applied to using mysqlimport vs. 'mysql [db] <
> tablename.sql'.  

mysqlimport is basically a wrapper around "LOAD DATA INFILE".

-- 
	Dan Nelson
	dnelson@stripped