ERROR 1064 (42000) at line 287379: You have an error in your SQL syntax

[HaMi]

Hi Guys,

 

i am new to this site, if i made a mistake then i am sorry for this.

 

i am having this issue on my database

 

i run a vbulletin forum with 30 000+ registered members

 

one admin moved all threads to one section and i wanted to implement the backup i took on 12.06.2010 via Vbulletin AdminCP

 

now the issue i am having is normaly vbulletin have 177+ tables. when i tried to implent this via "Bigdump" it implemented only 87 tables.

 

i tried the same with SSH

 

it went to 110 tables but it ended aswell with this error:

 

ERROR 1064 (42000) at line 287379: 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>:  Maximum execution time of 30 seconds exceeded in <b>' at line 1

 

can someone help me on this? i will be really thankful

 

Regards,

HaMi

[HaMi]

now i tried even dumping it via MySql Dumper it gave this error:

 

Array

(

    [max_zeit] => 22

    [startzeit] => 1276515827

    [xtime] => 1276515461

    [fileEOF] =>

    [actual_table] => post

    [offset] => 170383526

    [aufruf] => 114

    [table_ready] => 87

    [part] => 0

    [do_it] =>

    [errors] => 0

    [notices] => 0

    [anzahl_eintraege] => -1

    [anzahl_tabellen] => -1

    [filename] => vbulletin.sql

    [actual_fieldcount] => 0

    [eintraege_ready] => 264349

    [anzahl_zeilen] => 17277

    [summe_eintraege] => 259003

    [erweiterte_inserts] => 0

    [flag] => -1

    [EOB] =>

    [dump_encoding] => utf8

    [compressed] => 0

    [tables_to_restore] =>

    [filehandle] => Resource id #13

    [tablelock] => 0

    [insert_syntax] => INSERT INTO post

)

 

 

Sql: <br />

Erweiterte Inserts: 0

unknown SQL-Command: Fatal error: Maximum execution time of 60 seconds exceeded in /home/mm/www/forums/includes/adminfunctions_backup.php on line 63

[fenway]

That's in your php config -- override it for admin functions.

[HaMi]

but i tried this with different database backups which i took from january till now.. all have this error on different lines..

[fenway]

but i tried this with different database backups which i took from january till now.. all have this error on different lines..

I don't understand what that means.