Posted by himilecyclist on 07/26/06 19:40

Thanks for the suggestions!

The reference I am using, "Sams Teach Yourself SQL", indicates that
SELECT * INTO can be used to copy one table to another:

"To copy the contents of a table into a brand new table (one that is
created on-the-fly) you can use the SELECT INTO statement."

>From what I have read here, that is not an accurate description for
MySQL.

Our goal is some PHP code that will create a copy (for backup purposes)
of a MySQL table residing on a production Linux server. We would like
to create the copy on the user's local machine. Is there a better way
to accomplish that?

Thanks!

• Next in forum: Locate an image file on the server, extract data, resize and then output new image - can this be done?
• Prev in forum: Re: Using arrays to take records from a html table and update database
• Thread view: Re: Using SELECT INTO to Backup a Database

[Reply to this message]