Announcement

Collapse
No announcement yet.

2nd import question

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

  • 2nd import question

    I have a vBulletin 3.6 forum that was already imported from phpBB. I've been using it for a few months, and thought it might be nice to merge in some old data from an InvisionFree forum I used to have. Before I acquire that data, I was wondering what I would have to do to merge that data in with my current forums, since this would be a second import. This might seem like a relatively simple question to some but I am not a vB pro by any means. I just want to know what to expect before I'd do something that might prove disastrous and make sure this wasn't over my head.

  • #2
    Yes, that can be done. Please view the multiple import instructions here:

    http://www.vbulletin.com/docs/html/impex_multi_import
    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
      I have removed the Import ID tags. I have just received a link to my InvisionFree forum data, an SQL file. As Jerry lined out here, I have made a new database to load those tables on. But I haven't the foggiest of how MySQL runs, let alone the proper strings to enter and where to enter my own information. I have the SQL from the old forums, I have my new forums all ready, I just need to get the old forums data ready to be imported... but I don't know how.

      Could someone please help walk me through this?

      Comment


      • #4
        So we are at the stage that you have the SQL file from invision free and need to restore it now to create the source database to import from ?

        Do you have either SSH access or phpMyAdmin to your server that will be doing the import ?

        How big is the invision free SQL file ?
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Originally posted by Jerry View Post
          So we are at the stage that you have the SQL file from invision free and need to restore it now to create the source database to import from ?
          Correct.

          Originally posted by Jerry View Post
          Do you have either SSH access or phpMyAdmin to your server that will be doing the import ?
          I have access to phpMyAdmin.

          Originally posted by Jerry View Post
          How big is the invision free SQL file ?
          The SQL file is 8.34 MB. Will I need some sort of program for big dumps - 1and1 (my host) does not allow for huge sql uploads, regrettably.

          Comment


          • #6
            phpMyAdmin should tell you it's maximum upload size, if you browse to the select the database then the "Import" tab it should show you a max file size ?
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Max: 8,192KB

              Comment


              • #8
                I suggest splitting the file into two and uploading it in two halves.

                Each line should be it's own INSERT line so it should be fine.
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  The entire file is a mish-mash of information, with no breaks for insert lines. It appears as such the whole way:

                  http://img.photobucket.com/albums/v3...freesqlpic.jpg

                  Comment


                  • #10
                    Hard to tell from that image, looks like you've opened it up in a text editor that can't handle the line breaks, try www.textpad.com
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      You're right, I used the wrong text editor by mistake.


                      I split the file in two, uploaded the tables provided by Jerry, then proceeded to upload the two files I had split from the InvisionFree SQL. The tables from Jerry naturally loaded fine. Pt. 1 of the split SQL seemed to be ok - I can only assume so because I didn't see error messages. I actually saw nothing, it just stopped after a while.

                      I uploaded Pt. II, and it yielded this error:

                      Code:
                      Error
                                                     There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
                      ----BEGIN CUT----
                      eNqNU9tu2kAQnWd/xUiN2kYyrg3hEucJIQuQHKCYJEpfkAMGrDrG8aVJ+vFNz86GkJJUrczuzpy5
                      7c4cvOl0PHW553Cvzr43ctlmhx27YxvBDIYnw+hdBi4fDZcuF3dJFuZFlFtJfGNlm8z8wXWr0eK6
                      bTe/2B38ILr1uus4nES3p+w9ZHxknD8GX32Xm5ZtNZ1asl0bF8GUx4HJ3b43mpl86aHUVZzy+fjb
                      0Pe7ytWYnHddpG9ZJ7UsaRiTwUT5mWPc5sRqWI5dQ1mrWGySKl1aDvtxWj0YfnfUdzlKa1W5qnUM
                      Kfz0a0gjCsijKc2IaUh96GNonmgjoGNIMd3QiuaU0ZYKKrGYPlMIPaOIUlrCFmGPYTNh28lzrJhu
                      oSs0g7wUKaQKlg2y5fB5H02h7yIrVIyAFfBdCxIj2xweS3w5bAU+XUPfcA48xBk9ey+Ap69q7fyU
                      fIf8kSxtK2HLJGbvv5JbVbjRHksRcS9v3Pn/+fbXL1B3KbEv8L45VixdfGsp6VF6+tayQkwCyzEs
                      l9Qlny4wpUAm8YlsLPPV6UBqU4da1MTSWAOIlmbSDdXVnbc+W4iwoJ0+n20gFtXx7fM6yOOIZxtn
                      5yX7zoNpgDtvDtbH8DY7ow+IbdAZfBi8GmBXbFOvMAVT2pUwj6mHN45wBjQBHxUX+9Bm8B7IOYV9
                      cpD3n1pSnoHKuVbW5d/Qa2GU6vMWPdcseYRcCTtymfV3mbTmpmJYKjzQzNKa2tdAtsJrBlc2MlM1
                      WQYzFKPUHPa5Q+GyJb24FiwXz1C4GomW4UahRN0LrrPl2NcvFQtELvDp/4XO15Naa/Es6ed/dYcP
                      ZquY4LzI7QPre/sx/QakKvXB
                       ----END CUT----
                      ----BEGIN RAW----
                      ERROR: C1 C2 LEN: 0 1 1080
                      STR: �
                      
                      CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
                      MySQL: 5.0.51-log
                      USR OS, AGENT, VER: Win MOZILLA 5.0
                      PMA: 2.6.4-pl3
                      PHP VER,OS: 4.3.10-200.schlund.1 Linux
                      LANG: en-utf-8
                      SQL: ��I�N�S�E�R�T� �I�G�N�O�R�E� �I�N�T�O� �i�b�f�_�p�o�s�t�s� �(�a�p�p�e�n�d�_�e�d�i�t�,� �e�d�i�t�_�t�i�m�e�,� �p�i�d�,� �a�u�t�h�o�r�_�i�d�,� �a�u�t�h�o�r�_�n�a�m�e�,� �u�s�e�_�s�i�g�,� �i�p�_�a�d�d�r�e�s�s�,� �p�o�s�t�_�d�a�t�e�,� �i�c�o�n�_�i�d�,� �p�o�s�t�,� �q�u�e�u�e�d�,� �t�o�p�i�c�_�i�d�,� �f�o�r�u�m�_�i�d�,� �n�e�w�_�t�o�p�i�c�,� �e�d�i�t�_�n�a�m�e�,� �a�t�t�a�c�h�_�h�i�t�s�,� �a�t�t�a�c�h�_�t�y�p�e�,� �a�t�t�a�c�h�_�f�i�l�e�)� �V�A�L�U�E�S� �(�'�0�'�,�'�0�'�,�'�1�0�7�8�6�5�6�'�,�'�3�7�'�,�'�T�o�n�u�s�'�,�'�1�'�,�'�6�8�.�1�9�8�.�1�7�6�.�2�2�0�'�,�'�1�1�3�1�6�8�7�1�8�6�'�,�'�0�'�,�'� �H�a�h�a�h�a�h�a�h�a�&#�3�3�;� � �O�H� �N�O�E�S�,� � �N�O�W� �I� �C�A�N� �S�P�R�I�N�G� �T�E�H� �T�R�A�P�&#�3�3�;�&#�3�3�;�&#�3�3�;�<�b�r�>�<�b�r�>�Y�e�s� �V�o�l�t�,� �y�o�u� �t�r�i�c�k�e�d� �u�s� �i�n�t�o� �p�o�i�n�t�i�n�g� �o�u�t� �w�h�a�t� �a� �m�o�r�o�n� �y�o�u� �a�r�e�.� � �Y�o�u�r� �m�a�s�t�e�r� �p�l�a�n� �w�a�s� �a� �r�a�g�i�n�g� �s�u�c�c�e�s�s�.� � �C�o�n�g�r�a�t�z�&#�3�3�;�<�b�r�>� �'�,�'�0�'�,�'�2�2�1�'�,�'�2�7�'�,�'�0�'�,�'�'�,�'�'�,�'�'�,�'�'�)� ----END RAW----
                           SQL query: 
                        ��I�N�S�E�R�T� �I�G�N�O�R�E� �I�N�T�O� �i�b�f�_�p�o�s�t�s� �(�a�p�p�e�n�d�_�e�d�i�t�,� �e�d�i�t�_�t�i�m�e�,� �p�i�d�,� �a�u�t�h�o�r�_�i�d�,� �a�u�t�h�o�r�_�n�a�m�e�,� �u�s�e�_�s�i�g�,� �i�p�_�a�d�d�r�e�s�s�,� �p�o�s�t�_�d�a�t�e�,� �i�c�o�n�_�i�d�,� �p�o�s�t�,� �q�u�e�u�e�d�,� �t�o�p�i�c�_�i�d�,� �f�o�r�u�m�_�i�d�,� �n�e�w�_�t�o�p�i�c�,� �e�d�i�t�_�n�a�m�e�,� �a�t�t�a�c�h�_�h�i�t�s�,� �a�t�t�a�c�h�_�t�y�p�e�,� �a�t�t�a�c�h�_�f�i�l�e�)� �V�A�L�U�E�S� �(�'�0�'�,�'�0�'�,�'�1�0�7�8�6�5�6�'�,�'�3�7�'�,�'�T�o�n�u�s�'�,�'�1�'�,�'�6�8�.�1�9�8�.�1�7�6�.�2�2�0�'�,�'�1�1�3�1�6�8�7�1�8�6�'�,�'�0�'�,�'� �H�a�h�a�h�a�h�a�h�a�&�#�3�3�;� � �O�H� �N�O�E�S�,� � �N�O�W� �I� �C�A�N� �S�P�R�I�N�G� �T�E�H� �T�R�A�P�&�#�3�3�;�&�#�3�3�;�&�#�3�3�;�<b�r�><b�r�>Y�e�s� �V�o�l�t�,� �y�o�u� �t�r�i�c�k�e�d� �u�s� �i�n�t�o� �p�o�i�n�t�i�n�g� �o�u�t� �w�h�a�t� �a� �m�o�r�o�n� �y�o�u� �a�r�e�.� � �Y�o�u�r� �m�a�s�t�e�r� �p�l�a�n� �w�a�s� �a� �r�a�g�i�n�g� �s�u�c�c�e�s�s�.� � �C�o�n�g�r�a�t�z�&�#�3�3�;�<b�r�> '�,�'�0�'�,�'�2�2�1�'�,�'�2�7�'�,�'�0�'�,�'�'�,�'�'�,�'�'�,�'�'�)� 
                      
                            MySQL said: 
                      Please advise what to do. I'm lost in manipulating SQL.

                      Comment


                      • #12
                        That isn't SQL, or it is a zip/gz/archive file of some kind.

                        What is the full file name or extension ?

                        If it is as I guess an archive, you'll have to extract it, then cut it into two.
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          It is an SQL file. Here is all the info IF gave me
                          You can download the data (8.3MB) at <protecting data>

                          Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
                          Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
                          ibf_badwords
                          ibf_posts
                          ibf_calendar_events
                          ibf_categories
                          ibf_contacts
                          ibf_emoticons
                          ibf_forums
                          ibf_groups
                          ibf_members
                          ibf_messages
                          ibf_moderators
                          ibf_polls
                          ibf_stats
                          ibf_titles
                          ibf_topics
                          ibf_tracker
                          ibf_voters
                          ibf_cache_store
                          ibf_forum_perms
                          ibf_topic_mmod
                          ibf_validating;

                          or you can use these queries:

                          CODE DELETE FROM ibf_badwords;
                          DELETE FROM ibf_posts;
                          DELETE FROM ibf_calendar_events;
                          DELETE FROM ibf_categories;
                          DELETE FROM ibf_contacts;
                          DELETE FROM ibf_emoticons;
                          DELETE FROM ibf_forums;
                          DELETE FROM ibf_groups;
                          DELETE FROM ibf_members;
                          DELETE FROM ibf_messages;
                          DELETE FROM ibf_moderators;
                          DELETE FROM ibf_polls;
                          DELETE FROM ibf_stats;
                          DELETE FROM ibf_titles;
                          DELETE FROM ibf_topics;
                          DELETE FROM ibf_tracker;
                          DELETE FROM ibf_voters;
                          DELETE FROM ibf_cache_store;
                          DELETE FROM ibf_forum_perms;
                          DELETE FROM ibf_topic_mmod;
                          DELETE FROM ibf_validating;


                          Then run the queries in the file you downloaded. See http://dev.mysql.com/doc/mysql/en/batch-commands.html
                          Last edited by Jerry; Wed 13 Feb '08, 12:23pm. Reason: URL removed

                          Comment


                          • #14
                            I have looked at the file.

                            Check your private messages.
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              So what's the process?

                              - You grab the invision free database.
                              - Create a new dB
                              - Run the sql included in this post: http://www.vbulletin.com/forum/showp...70&postcount=4
                              - Then you say you can 'restore the invision free SQL into it with ignoring the INSERT's for the tables that ImpEx doesn't use in a IPB1.3 import'?
                              - Finally use the ipb folder in the ImpEx upload as the system?

                              How do you ignore the INSERTs for the tables ImpEx doesn't use in a IPB1.3 import?

                              Hopefully I got this right - The tables in the sql you posted are the only tables that ImpEx uses from teh old Invision Free board? Therefore when you are importing the invision free database, it won't insert information for any other tables other than the one's already created by your sql. So we just take out all the "CREATE TABLE" statements from the invision free database backup?

                              Thanks for your time -
                              Columbus Blue Jackets Forums

                              Comment

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