Announcement

Collapse
No announcement yet.

Total noob in action, help needed

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

  • Total noob in action, help needed

    Hi, nice to see such a lively community
    Hope some of you can help me out here.

    I recently moved from IPv2 to VB3.8.2 and want to import the backup
    I got from the staff from IP into VB through Impex.

    Only thing is I really don't know how, and when I read all these things
    that need to be done, it just confuses me.

    I have zero knowledge of PHP or MySQL.

    The files I have gotten appear to be raw database files, that's the only thing I know (MYI, MYD, frm).

    Importing them like I got them (gzip file) wouldn't work either. It would
    just give me an error. (Tried importing it in directadmin directly into the database that I especially made for this one)

    Any help please?

  • #2
    Restoring the raw db files requires root access to the server and a pretty good understanding on hot MySQL databases are configured on the server. I suggest you contact your host and ask them to do this.
    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


    • #3
      okay thanks for replying, i got the whole thing working through a friend of mine, but while importing it, the posts, threads and now users don't seem to import properly. (Posts & Threads don't go in at all)

      Comment


      • #4
        Anyone know if there is a way of fixing this issue?

        Comment


        • #5
          Originally posted by StitchRFC View Post
          Anyone know if there is a way of fixing this issue?
          I suggest starting your own thread with all the relevant details.

          The 'issue' here, is having raw database tables, opposed to a mysqldump.

          Getting the mysqldump from the source database is the way to go.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            alright, I got the mysqldump (the .sql file i guess) but still having the same problems.

            No threads, no users (anything related neither) + users don't import properly I think.

            Anybody know a solution or do you suggest me taking a ticket?

            Comment


            • #7
              Originally posted by Jerry View Post
              I suggest starting your own thread with all the relevant details.

              The 'issue' here, is having raw database tables, opposed to a mysqldump.

              Getting the mysqldump from the source database is the way to go.
              I'm helping him sort the problemwas just bumping the thread up for him.

              Comment


              • #8
                ImpEx will give some kind of errors if it's failing on data.

                Or "0 of 0" items if it doesn't import any.

                Are either of those things happening ?

                Followed all these ? http://www.vbulletin.com/docs/html/impex_cleanup
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  If all you have is raw database files (.frm .MYD .MYI files) and you don't have a good understanding of how mysql works, or don't have root access, then as Steve said, you need to get your host to handle this for you.

                  However, giving you the benefit of the doubt as to your technical knowledge and access to the server, here's the procedure:

                  1)su to root
                  2)create or pick a user to assign the database to, it doesn't really matter who the user is at this point
                  3)create a directory under your mysql storage directory (usually /var/lib/mysql) with user_dbname, and copy all of data and index files to that directory
                  4)chown the files to mysql:mysql
                  5)chmod the files to 660
                  6)restart mysqld so it will see the new files
                  7)run mysqldump -opt -Q user_dbname > somefilename.sql. You won't need to enter a user or password since you're logged in as root.
                  8)proceed with restoring the dump to your active space.
                  mysql
                  use user_dbname
                  \. somefilename.sql;
                  (watch the data fly by until it finishes)
                  exit

                  Now you're done.
                  Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.

                  Comment


                  • #10
                    While the above may work, I would highly advise against dealing with the data tables directly and if you have ssh access, use the mysqldump route.
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      This is what it says when I'm trying to import thread + post:

                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Invalid, skipping. Failed on : threadid
                      Besides that, I chose ipb2, is that even correct, if I'm importing from invisionplus?

                      Comment


                      • #12
                        InvisionPlus? Isn't that the same as IPB 1.3?
                        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
                          Originally posted by Steve Machol View Post
                          InvisionPlus? Isn't that the same as IPB 1.3?
                          There is no IPB 1.3 to select within Impex.

                          Comment


                          • #14
                            Yes there is:

                            http://www.vbulletin.com/docs/html/impex_ipb1.3
                            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
                              Yeah, but I can't select it form the drop down list when importing with Impex.

                              Comment

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