List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 10 1999 8:49pm
Subject:Re: Copy complete table
View as plain text  
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
>Hello 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
Copy complete tableJeff Schwartz26 Jul
  • Copy complete tableJani Tolonen26 Jul
    • Re: Copy complete tablePaul DuBois10 Aug
  • Copy complete tablesinisa26 Jul
  • Re: Copy complete tableelble26 Jul