Jump to content

Backups with SELECT INTO


ameliabob
 Share

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...