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 datab
t;
To: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 9:39 AM
Subject: Backup / Import Questions
> Hi,
>
> I have built a database with 7 tables in it, the time has come when I need
to
> create a suitable backup system so off I went to my manuals. I read
through
> the mysqldu
Hi,
I have built a database with 7 tables in it, the time has come when I need to
create a suitable backup system so off I went to my manuals. I read through
the mysqldump command and everything seemed straight forward. I ran the
following...
mysqldump -uroot -ppassword --opt Database > fil
