SauravG
02-09-2008, 10:36 AM
I am restoring a backup using MYSQL and I get this error half way through
Error
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 @ 350
STR: />
SQL:
INSERT INTO `guest` VALUES('55253c176dee0bb0cf38ac467f154167', '88.102.149.81', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12', 1202553435, '', 'showthread', 'a:7:{s:1:"t";s:4:"1383";s:8:"threadid";i:1383;s:1:"s";s:0:"";s:6:"postid";i:0;s:7:"forumid";s:3:"234";s:6:"pollid";i:0;s:1:"a";s:0:"";}')<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1032826 bytes) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php</b> on line <b>149</b><br />
SQL query:
INSERT INTO `guest` VALUES('55253c176dee0bb0cf38ac467f154167', '88.102.149.81', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12', 1202553435, '', 'showthread', 'a:7:{s:1:"t";s:4:"1383";s:8:"threadid";i:1383;s:1:"s";s:0:"";s:6:"postid";i:0;s:7:"forumid";s:3:"234";s:6:"pollid";i:0;s:1:"a";s:0:"";}')
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1032826 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php on line 149
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (trie' at line 1
Please help.
Error
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 @ 350
STR: />
SQL:
INSERT INTO `guest` VALUES('55253c176dee0bb0cf38ac467f154167', '88.102.149.81', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12', 1202553435, '', 'showthread', 'a:7:{s:1:"t";s:4:"1383";s:8:"threadid";i:1383;s:1:"s";s:0:"";s:6:"postid";i:0;s:7:"forumid";s:3:"234";s:6:"pollid";i:0;s:1:"a";s:0:"";}')<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1032826 bytes) in <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php</b> on line <b>149</b><br />
SQL query:
INSERT INTO `guest` VALUES('55253c176dee0bb0cf38ac467f154167', '88.102.149.81', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12', 1202553435, '', 'showthread', 'a:7:{s:1:"t";s:4:"1383";s:8:"threadid";i:1383;s:1:"s";s:0:"";s:6:"postid";i:0;s:7:"forumid";s:3:"234";s:6:"pollid";i:0;s:1:"a";s:0:"";}')
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1032826 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php on line 149
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (trie' at line 1
Please help.