Announcement

Collapse
No announcement yet.

Invision Free Help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • rex_b
    replied
    Nevermind forgot the < at the end.

    Leave a comment:


  • rex_b
    replied
    Originally posted by Jerry View Post
    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:
    Attached Files

    Leave a comment:


  • Jerry
    replied
    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.

    Leave a comment:


  • rex_b
    replied
    Well I don't have SSH access

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • rex_b
    replied
    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?

    Leave a comment:


  • Jerry
    replied
    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

    Leave a comment:


  • rex_b
    replied
    Ugh

    Leave a comment:


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

    Leave a comment:


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

    Code:
    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

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


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

    Leave a comment:


  • Steve Machol
    replied
    Just follow the restore instructions I posted previously.

    Leave a comment:


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

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X