Because the --opt option builds an output script of SQL commands that can
be run to CREATE TABLES and INSERT data. You're on the right track, but
using mysqlimport only makes sense based on the options that were used
with mysqldump...
Based on what you've done, you can re-create the entire database by
running the 'file.mysql' as a script (you don't need mysqlimport in this
case):
mysql -uroot -ppassword TestDatabase < file.mysql
On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote:
> mysqldump -uroot -ppassword --opt Database > file.mysql
>
> Why does mysqldump allow you to dump all the table create data with the
> actual data if the import function doesnt allow you to use it?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
