I am having a problem copying a table in PHPMyAdmin from one MySQL database to another. I followed this tutorial: http://www.codingforums.com/showthread.php?t=22880 However, when I try to import the .sql file into the second database, it takes a long time to process the request and then the page just says "No SQL query!". Does anyone know why that is? Is there any other way to copy a table to another database? I tried going to Operations and copying the table there but I can't access more than one database at a time for some reason. Also, the table I'm trying to copy is full of posts from my message board so I'm not sure if the huge size of the file has anything to do with this. Any help would be greatly appreciated, thank you!! -Sarah
The file size and server load are factors in the importing timeout. You could copy the text from the file and try importing it by pasting it into the query window. There is a copy database function in phpmyadmin under Operations. It has a section called copy database to. Then you just fill in a database name and then select what you want to copy which in your case is data and structure. Then just check if you want the database created, if it exists to drop data, etc.