[Resolved] backing up/copying tables

[jacksonpt]

I need to do some wide scale updating on a table via various MySQL queries. However, before I do it, I'd like to backup the table just in case there's a problem with the updating. Basically I just want to create and exact copy of the table and keep it in the same DB as the original, but obviously with a different table name.

How do I do that?

[mrhappiness]

CREATE TABLE backup_xyz AS
SELECT * FROM xyz

[thorpe]

if youir using phpmyadmin just do an export. this will generate all the sql needed to create your table and fill it with the current data.

you can then either just keep this sql asside and run it when your done. or run it against your db to create a new 'backup' table.

[jacksonpt]

Originally posted by mrhappiness
CREATE TABLE backup_xyz AS
SELECT * FROM xyz

Great, thanks. Worked perfectly.