Invision Free Help

[rex_b]

Nevermind forgot the < at the end.

[rex_b]

Unless it has changed, Invisioin free gives you the insterts and not the table creation SQL, this is why I created this :

http://www.vbulletin.com/forum/showp...70&postcount=4

Ok I did all of that and it just spit this type of stuff at me:

[Jerry]

Well your approach of the removing the SQL that isn't needed is a fair approch then, only other option is setting up the database on a server where you do have ssh then restoring the database and moving that to the new host.

[rex_b]

Well I don't have SSH access

[Jerry]

I do it on the command line and use -f to force the SQL to carry on with errors.

[rex_b]

Ok I removed all of the Inserts to tables I don't need. We shall see if this works.

[rex_b]

Ok but if I'm using MySQLDumper since I don't have SSH how do I restore the database with ignoring those tables that I don't need?

[Jerry]

Unless it has changed, Invisioin free gives you the insterts and not the table creation SQL, this is why I created this :

http://www.vbulletin.com/forum/showp...70&postcount=4

[rex_b]

Ugh

[Steve Machol]

It looks like this is a bad backup file. I'd ask them to provide a new one.

[rex_b]

Ok I did the mysqldumper thing and got this when I tried to restore.:

Array
(
    [num_table_fields] => Array
        (
        )

    [max_zeit] => 22
    [startzeit] => 1159813252
    [xtime] => 1159813252
    [fileEOF] => 
    [actual_table] => ibf_badwords
    [offset] => 0
    [aufruf] => 1
    [table_ready] => 0
    [part] => 0
    [do_it] => 
    [errors] => 0
    [notices] => 0
    [anzahl_eintraege] => -1
    [anzahl_tabellen] => -1
    [filename] => 1159775083.sql
    [actual_fieldcount] => 0
    [eintraege_ready] => 0
    [anzahl_zeilen] => 110
    [summe_eintraege] => 0
    [erweiterte_inserts] => 0
    [flag] => -1
    [EOB] => 
    [insert_syntax] => 
    [kind] => 0
    [compressed] => 0
    [filehandle] => Resource id #12
)
Couldn't read rowcount for table ibf_badwords!
Restore:ibf_badwords

[Steve Machol]

Some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

[rex_b]

Easier said than done, I don't think I'm allowed SSH access.

[Steve Machol]

Just follow the restore instructions I posted previously.

[rex_b]

Anyway for me to verify that and check as I'm not a real technical person.