Invision Free Help

[rex_b]

I have my .sql file that I'm trying to import via phpmyadmin but when I import nothing ever happens. The file is quite large so maybe timing out? What are my options? and could you point me on how to exercise these options.

[SNN]

Can you tell me exactly how big the SQL file is?

[rex_b]

Almost 27,000 KB

[rex_b]

Ok I think I narrowed it down. It's looking to insert the files in tables that IPB creates like ibf_forums and what not. But I don't have a db with that info I just have a blank db.

How do I create all of the tables it wants easily?

[rex_b]

I found this list for 2.0 http://forums.invisionpower.com/lofi...p/t153927.html but not sure if that works with 1.3

[Steve Machol]

If the backup was made correctly, then it should create the necessary table.

Note: The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/docs/html/m...ce_ssh_restore

[rex_b]

If the backup was made correctly, then it should create the necessary table.

Note: The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/docs/html/m...ce_ssh_restore

Well all I got was a SQL file

[Steve Machol]

That's correct. And if this file was created correctly it has all the commands neccessary to create those tables, otherwise it's not a real backup.

[rex_b]

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

[Steve Machol]

Just follow the restore instructions I posted previously.

[rex_b]

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

[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]

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]

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

[rex_b]

Ugh