copying existing table with the same structure and data?

rosy

Hi,
I tried using syntax,
CREATE TABLE new_table_name LIKE old_table_name;

ASA i press enter , it gives error,
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE old_table_name' at line 1
My MySQL version is

mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

How i can make this, bcoz i thought of alter the table in production, so prior to that one i would like to have a copy or backup of the table. How i can do this.
Please help.

MarkR

rosy wrote:
How i can make this, bcoz i thought of alter the table in production, so prior to that one i would like to have a copy or backup of the table. How i can do this.
Please help.

Personally, I'd just make a complete backup of the database in the same way you normally handle backups (talk to your sysadmin if you don't normally do them).

Do this after you take the site down for upgrade of course.

If you're unsure as to what syntax is supported in a particular version, consult the MySQL docs.

Mark