Announcement

Collapse
No announcement yet.

dont get it

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

  • dont get it

    well i backed up db for my forum running 3.0.8 then on new database for 3.5 (myphpadmin) i tried uploading database said no SQL query what am i doing wrong?

  • #2
    Chances are its just too big.

    Comment


    • #3
      Originally posted by Zachery
      Chances are its just too big.
      36mb then how can i move my whole database is only way to install? because i wanted to get everything setup 1st

      Comment


      • #4
        It could be a bad backup. The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

        Backup:
        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

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

        This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.
        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


        • #5
          what if i dont have either?

          Comment


          • #6
            Then you may be out of luck. How large was your database and how large is the backup file?
            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
              Then you may be out of luck. How large was your database and how large is the backup file?
              saved as 36mb Threads: 2,053, Posts: 12,243, Members: 559 is my stats does 36 mb sound right?

              Comment


              • #8
                The backup file is 36Mb? If so, that sounds about right.
                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
                  then why would it say no sql query? btw i uploaded installed then uploaded to database then i get this error on my 3.5 Fatal error: Please upgrade to vBulletin 3.5.0 or greater in /includes/init.php on line 169

                  Comment


                  • #10
                    The Fatal Error might be fixed by disabling TurkMMCache

                    As for the no sql query....same happened to me today. EXTREMELY annoying.

                    Comment


                    • #11
                      Originally posted by ATI4EVER
                      The Fatal Error might be fixed by disabling TurkMMCache

                      As for the no sql query....same happened to me today. EXTREMELY annoying.
                      how to prevent?

                      Comment


                      • #12
                        How to prevent the "no sql query"?

                        I dont think there is a way. As I type this I am attempting at doing it through SSH. It is either doing it effing slowly, or not doing it at all.....

                        Comment


                        • #13
                          Open your backup file and post the first 10 lines here.
                          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


                          • #14
                            Originally posted by Steve Machol
                            Open your backup file and post the first 10 lines here.
                            PHP Code:
                            DROP TABLE IF EXISTS access;
                            CREATE TABLE `access` (
                              `
                            useridint(10unsigned NOT NULL default '0',
                              `
                            forumidsmallint(5unsigned NOT NULL default '0',
                              `
                            accessmasksmallint(5unsigned NOT NULL default '0',
                              
                            UNIQUE KEY `userid` (`userid`,`forumid`)
                            TYPE=MyISAM;




                            DROP TABLE IF EXISTS adminhelp;
                            CREATE TABLE `adminhelp` (
                              `
                            adminhelpidint(10unsigned NOT NULL auto_increment,
                              `
                            scriptvarchar(50NOT NULL default '',
                              `
                            actionvarchar(25NOT NULL default '',
                              `
                            optionnamevarchar(25NOT NULL default ''
                            thats 1st 10

                            Comment


                            • #15
                              Strange. That's definitely a valid query. How are you trying to restore this exactly?
                              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

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