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.
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?
5 messages in com.mysql.lists.mysqlRe: Copy complete table
