List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 29 1999 1:11am
Subject:Re: Backup Question
View as plain text  
On Sat, 1999-08-28 17:12:22 +0300, Sinisa Milivojevic wrote:
> Max Zilberman writes:
>  > Is there a way to display sql for a given table in the DB ?
>  > I need to actual sql which will re-create an entire database.
>  > Thanks in advance for  comments.
[...]
> Your question is of an opaque nature, but please look at mysqladmin
> command, especially with --opt option.

What Sinisa most probably means is the "mysqldump" program.

See
   mysqldump --help
for all the possible options.

Max, I guess what you want is as simple as
   mysqldump --opt dbname tablename

Chapter "12.1 Overview of the different MySQL programs" of the MySQL
manual also has a paragraph on mysqldump.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Backup Question(Max Zilberman)28 Aug
  • Re: Backup Questionsinisa28 Aug
    • Re: Backup QuestionMartin Ramsch29 Aug