Jeane Paul Posted April 11, 2005 Report Share Posted April 11, 2005 Greetings, Guys, can you pls help me here. i dont know if this is right to post it here, but somehow i am hoping that you can help me, since it is about phpMyAdmin.. i was doing a Database restore through phpMyAdmin. i am doing tihs because i am transferring my phpBB boards to a new host..i have splitted my database into 4 files(because sql file is really big). i have them 4 files and has 900kb each. however, when i was on the last part of the file, i have this kind of error on my phpMyAdmin.. There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 5 STR: /> SQL: <br /> <b>Warning</b>: mysql_free_result(): supplied argument is not a valid MySQL result resource in <b>/var/www/pma/libraries/export/sql.php</b> on line <b>169</b><br /> # -------------------------------------------------------- # # Table structure for table `phpbb_sessions` # DROP TABLE IF EXISTS `phpbb_sessions` SQL-query: Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/pma/libraries/export/sql.php on line 169 # -------------------------------------------------------- # # Table structure for table `phpbb_sessions` # DROP TABLE IF EXISTS `phpbb_sessions` can anyone pls help me?, i cant proceed on my project because i have this error. i am hoping that you guys can help me somehow.. thank you so much Quote Link to comment Share on other sites More sharing options...
elyk Posted April 11, 2005 Report Share Posted April 11, 2005 make sure there's no empty lines in your sql; sometimes that messes it up for me. Quote Link to comment Share on other sites More sharing options...
AlleyKat Posted April 13, 2005 Report Share Posted April 13, 2005 Jeane Paul, please also check the actual contents of that file - maybe those lines are *in* the file? It looks like an error report from a Unix to me (var/www/pma/...) - this could be a problem in the export itself I guess. Quote Link to comment Share on other sites More sharing options...
Jeane Paul Posted April 14, 2005 Author Report Share Posted April 14, 2005 Greetings Sorry to take long for replying..i was busy on modifying my phpBB boards this past few days.. yes i have fixed that problem,, i have edited some lines on the .sql files...then it worked well now..thanks guys for the support. i reall appreciate it.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.