At 1:41 PM +0300 7/26/99, Jani Tolonen wrote:
>Jeff Schwartz writes:
> > Is there an easy way to copy a complete table, structure, data, etc.
> > within a script? I can copy the data if the table already exists but I
> > can't create the table.
> > Thanks,
> > Jeff
>Use mysqldump. By default it dumps the table definition
>(the CREATE -command) and the data (the INSERT -commands).
>mysqldump has a lot of useful options, see mysqldump --help.
How about if the question involved copying the privileges
on the table as well?
Anybody got a favorite method?
Paul DuBois, paul@stripped