Jump to content

Backups with SELECT INTO


ameliabob

Recommended Posts

In the school there is an example of backing up using

SELECT * INTO backupfile FROM mainfile

Except when I try this in mysql from the phpMyAdmin I get an undeclared variable error for 'backupfile'I copied the structure of mainfile to backupfile manually and still got the error.Am I using something incorrectly??

Link to comment
Share on other sites

And when you run the query, it says that a table called "backupfile" doesn't exist? You originally said the "variable" backupfile, is it referring to it as a variable or table? You can also do this:INSERT INTO backuptable SELECT * FROM maintable

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...