Posted by J.O. Aho on 11/22/07 20:13

Flemming wrote:

> I thought this would be a relatively easy task, but this does not appear
> to be the case. Or maybe I am blind. I can see in phpMyAdmin the SQL
> statements needed to create a new empty table and copy the content from
> the original table. I could of course copy this code into PHP, but what
> then if I change a table? Then I need to change this code as well.

You can try with the following SQL statement:

CREATE TABLE backuptable SELECT * FROM table_to_backup

You can use it easilly both from phpMyAdmin and from your custom made php script.

--

//Aho

• Next in forum: Re: How do I copy a table for backup and restore purposes
• Prev in forum: How do I copy a table for backup and restore purposes
• Thread view: Re: How do I copy a table for backup and restore purposes

[Reply to this message]