ameliabob Posted March 31, 2011 Share Posted March 31, 2011 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 More sharing options...
justsomeguy Posted March 31, 2011 Share Posted March 31, 2011 What is "backupfile"? Is it a table or database? Link to comment Share on other sites More sharing options...
ameliabob Posted March 31, 2011 Author Share Posted March 31, 2011 What is "backupfile"? Is it a table or database?Both backupfile and mainfile are tables. Link to comment Share on other sites More sharing options...
justsomeguy Posted March 31, 2011 Share Posted March 31, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.