Announcement

Collapse
No announcement yet.

Invision Free Help

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

  • Invision Free Help

    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.

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

    Comment


    • #3
      Almost 27,000 KB

      Comment


      • #4
        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?

        Comment


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

          Comment


          • #6
            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
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Originally posted by Steve Machol View Post
              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

              Comment


              • #8
                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.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


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

                  Comment


                  • #10
                    Just follow the restore instructions I posted previously.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


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

                      Comment


                      • #12
                        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
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          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

                          Comment


                          • #14
                            It looks like this is a bad backup file. I'd ask them to provide a new one.
                            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                            Change CKEditor Colors to Match Style (for 4.1.4 and above)

                            Steve Machol Photography


                            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                            Comment


                            • #15
                              Ugh

                              Comment

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