Jump to content


Photo

Error on doing a DatabaseRestore through phpMyAdmn


  • Please log in to reply
3 replies to this topic

#1 Jeane Paul

Jeane Paul

    Junior Member

  • Member
  • Pip
  • 12 posts

Posted 10 April 2005 - 10:46 PM

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

#2 elyk

elyk

    Beta Team Veteran

  • Member
  • PipPip
  • 85 posts
  • Location:Planet Earth
  • SourceForge IDelyk
  • Wiki ID: elyk
  • IRC Nickname: elyk

Posted 10 April 2005 - 10:54 PM

make sure there's no empty lines in your sql; sometimes that messes it up for me.

#3 AlleyKat

AlleyKat

    Project Helper

  • Super Moderator
  • PipPip
  • 84 posts
  • Location:Odense, Denmark
  • SourceForge IDdk_alleykat
  • IRC Nickname: (@)AlleyKat :P

Posted 12 April 2005 - 11:22 PM

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.

#4 Jeane Paul

Jeane Paul

    Junior Member

  • Member
  • Pip
  • 12 posts

Posted 14 April 2005 - 08:30 AM

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..




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users