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