Hi Denis,
both will happen:
-t, --no-create-info Don't write table creation info.
-d, --no-data No row information.
$ mysqldump -t -u <user> <database> > <outfile>
will create a file with your tables-create info. After a recreate
of the database (mysqladmin create <dbname>) you can
use this file for creating ONLY the tables with no content.
Sample:
$ mysqldump -t -u claudia musicbase > tab_create.sql
$ mysqldump -d -u <user> <database> > <outfile>
will create a file with your tables-data. After a recreate of the
database AND the tables you can use this file for loading your data
into the new-build database.
Sample:
$ mysqldump -d -u claudia musicbase > tab_data.sql
$ mysqldump -u <user> <database> > <outfile>
will create a file with both, the table-create infos AND the
tables data-content.
Sample:
$ mysqldump -u claudia musicbase > db_dump.sql
To reload use
$ mysqldump -u <user> <database> < <outfile>
Sample:
$ mysqldump -u claudia musicbase < tab_create.sql
bye
Klaus
Denis Voitenko schrieb:
> I am not familiar with the mysqldump tool and haven't found anything that
> explains it. I figured out how to use it but I am a bit confised. When I
> dump some database or table, does it dump the "historical" actions that I
> applied to the database or it creates an SQL script that will recreate
the
> table/db I have dumped?
>
> Denis Voitenko
> O3M Creative Director
> denis@stripped
> 215 386-3923
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread7967@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
--
######################################
# Die Musik: http://www.weltmusik.de
# Die Kunst: http://www.artistica.de
# Die Stadt: http://www.lohmar.org
######################################
