db problem ? help ?

[miz]

hey there, i have downloaded my old vb2 db backup inorder to to upgrade to main site to vb3

now when im tring to load my db backup on new server i get this error

ERROR 1064 at line 12292: You have an error in your SQL syntax. Check the manua
l that corresponds to your MySQL server version for the right syntax to use near
'<br />
<b>Fatal error</b>: Allowed memory size of 8388608 byte

any idea how to slove it ?

[Steve Machol]

You need to increase the allowed memory size in php.ini. Here is a post that explains this:

http://www.vbulletin.com/forum/showpost.php?p=501777&postcount=4

[miz]

You need to increase the allowed memory size in php.ini. Here is a post that explains this:

http://www.vbulletin.com/forum/showpost.php?p=501777&postcount=4


thanx for reply but still got the problem
this is what i got on php.ini (on windows dir)

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 16M ; Maximum amount of memory a script may consume (8MB)

and this is the error

ERROR 1064 at line 52631: You have an error in your SQL syntax. Check the manua
l that corresponds to your MySQL server version for the right syntax to use near
'<br />
<b>Fatal error</b>: Allowed memory size of 8388608 byte


anymore ideas ?

[Steve Machol]

You need to restart Apache after making the change to php.ini. The new settings won't take affect until you do.

[miz]

You need to restart Apache after making the change to php.ini. The new settings won't take affect until you do.

i know i read about it on the post so i did

net stop apache2
net start apache2

but still problem stays...

[miz]

ok i have found the problem :P

problem is on my crapy host its didnt allowed me to download all in 1 time :P

so im downloading all in few times

i opened the sql file (all apps were stuck even zend - used ultraedit - so if you need to edit big files use only this app)

and found at the end the error !!

any way, thanx for helping mate :P