Re: Best way to duplicate a table in a running database?

2001-01-25 Thread Richard Ellerbrock
Woops! Sorry, but I somehow missed the version number. Yes. You could probably shutdown the server, copy the relevant files making sure the permissions are correct and then restart the server. I would rather upgrade to 3.23.x though! -- Richard Ellerbrock [EMAIL PROTECTED] >>> [EMAIL PROTECTE

Re: Best way to duplicate a table in a running database?

2001-01-25 Thread Jeremy D. Zawodny
On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote: > What is wrong with the > > CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name > [(create_definition,...)] > [table_options] [select_statement] > > syntax. Note that you can append a SELECT statement to a CREATE > statement to

Re: Best way to duplicate a table in a running database?

2001-01-25 Thread Richard Ellerbrock
What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections: http:/

Best way to duplicate a table in a running database?

2001-01-24 Thread Guy Waugh
Hi there, One of my users wants to copy a large table. He normally does this through PHPMyAdmin, but the table seems too large for the web browser to handle, and it times out. I'm using mysql version 3.22.32-log on a RedHat Linux 6.2 (Intel) box. The file system is on a hardware RAID array.