Announcement

Collapse
No announcement yet.

A big problem with database backup

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

  • A big problem with database backup

    Because I have no shell access to my database, I back it up via phpmyadmin. But it is always corrupted and doesn't contain

    ### VBULLETIN DATABASE DUMP COMPLETED ###

    in the final line. Is there any way else to back the database up other than shell access or phpmyadmin or from the admin cp ? Is there any script or something like that that does that work ? Because if any thing happened to my database I'll have nothing to restore it.

  • #2
    Some people have reported success with Bigdump which you can find here:

    http://www.ozerov.de/bigdump.php
    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
      Well, that script is really great, but it is only for restoring an existing backup, not for making one. What I need is a way back up the database first, because I always get a bad and not working backup when using phpmyadmin.

      Comment


      • #4
        Are you sure? It looks like it's used to make backups as well.
        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
          Yes I'm sure, first because I've already tried it before, and second because its use is specified as:

          To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can't access the server shell and you can't import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web-server.

          in the page of the script.

          Comment


          • #6
            I found a script that makes backups, but I got the same corrupted backup. The backup always stops at Dumping data for table `post`. As an example this is the end of one backup when using that script:

            --
            -- Table structure for table `post`
            --

            CREATE TABLE post (
            postid int(10) unsigned NOT NULL auto_increment,
            threadid int(10) unsigned NOT NULL default '0',
            parentid int(10) unsigned NOT NULL default '0',
            username varchar(50) NOT NULL default '',
            userid int(10) unsigned NOT NULL default '0',
            title varchar(250) NOT NULL default '',
            dateline int(10) unsigned NOT NULL default '0',
            pagetext mediumtext NOT NULL,
            allowsmilie smallint(6) NOT NULL default '0',
            showsignature smallint(6) NOT NULL default '0',
            ipaddress varchar(15) NOT NULL default '',
            iconid smallint(5) unsigned NOT NULL default '0',
            visible smallint(6) NOT NULL default '0',
            attach smallint(5) unsigned NOT NULL default '0',
            editlevel tinyint(3) NOT NULL default '0',
            PRIMARY KEY (postid),
            KEY iconid (iconid),
            KEY userid (userid),
            KEY threadid (threadid,userid)
            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

            --
            -- Dumping data for table `post`
            --



            And this is the end of another one when using phpmyadmin:

            #
            # Table structure for table `post`
            #
            # Creation: Aug 29, 2005 at 03:39 PM
            #

            DROP TABLE IF EXISTS `post`;
            CREATE TABLE `post` (
            `postid` int(10) unsigned NOT NULL auto_increment,
            `threadid` int(10) unsigned NOT NULL default '0',
            `parentid` int(10) unsigned NOT NULL default '0',
            `username` varchar(50) NOT NULL default '',
            `userid` int(10) unsigned NOT NULL default '0',
            `title` varchar(250) NOT NULL default '',
            `dateline` int(10) unsigned NOT NULL default '0',
            `pagetext` mediumtext NOT NULL,
            `allowsmilie` smallint(6) NOT NULL default '0',
            `showsignature` smallint(6) NOT NULL default '0',
            `ipaddress` varchar(15) NOT NULL default '',
            `iconid` smallint(5) unsigned NOT NULL default '0',
            `visible` smallint(6) NOT NULL default '0',
            `attach` smallint(5) unsigned NOT NULL default '0',
            `editlevel` tinyint(3) NOT NULL default '0',
            PRIMARY KEY (`postid`),
            KEY `iconid` (`iconid`),
            KEY `userid` (`userid`),
            KEY `threadid` (`threadid`,`userid`)
            ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41299 ;

            #
            # Dumping data for table `post`
            #

            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
            "
            http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
            <html xmlns="
            http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
            <head>
            <title>phpMyAdmin</title>
            <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
            <base href="
            http://www.ournormandy.com/globat/phpMyAdmin/" />
            <link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?lang=en-iso-8859-1&amp;js_frame=right" />
            <script type="text/javascript" language="javascript">
            <!--
            // Updates the title of the frameset if possible (ns4 does not allow this)
            if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
            && typeof(parent.document.title) == 'string') {
            parent.document.title = 'forum vb.post running on localhost - phpMyAdmin 2.5.2-pl1';
            }

            //-->
            </script>

            <meta name="OBGZip" value="false" />
            </head>


            <body bgcolor="#F5F5F5">
            <h1>
            Database <i><a class="h1" href="db_details_structure.php?lang=en-iso-8859-1&amp;server=1&amp;db=forum+vb">forum vb</a></i>
            - Table <i><a class="h1" href="tbl_properties_structure.php?lang=en-iso-8859-1&amp;server=1&amp;db=forum+vb&amp;table=post">post</a></i>
            running on <i><a class="h1" href="main.php?lang=en-iso-8859-1&amp;server=1">localhost</a></i>
            </h1>

            <p><b>Error</b></p>
            <p>
            SQL-query&nbsp;:&nbsp;
            </p>
            <p>
            <span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span class="syntax_punct">*</span> <br /><span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote syntax_quote_backtick">`forum vb`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`post`</span> </span>
            </p>
            <p>
            MySQL said: <br />
            </p>
            <pre>
            MySQL client run out of memory
            </pre>
            <a href="db_details_export.php?lang=en-iso-8859-1&amp;server=1&amp;db=forum+vb">Back</a>
            <script type="text/javascript">
            <!--


            function reload_querywindow () {
            if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {

            // no submit, query was invalid
            }
            }

            function focus_querywindow(sql_query) {
            if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
            if (parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab != 'sql') {
            parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab.value = "sql";
            parent.frames.queryframe.querywindow.document.querywindow.query_history_latest.value = sql_query;
            parent.frames.queryframe.querywindow.document.querywindow.submit();
            parent.frames.queryframe.querywindow.focus();
            } else {
            parent.frames.queryframe.querywindow.focus();
            }

            return false;
            } else if (parent.frames.queryframe) {
            new_win_url = 'querywindow.php?sql_query=' + sql_query + '&lang=en-iso-8859-1&server=1&db=forum+vb&table=post';
            parent.frames.queryframe.querywindow=window.open(new_win_url, '','toolbar=0,location=1,directories=0,status=1,menubar=0,scrollbars=yes,resizable=yes,wid th=550,height=310');

            if (!parent.frames.queryframe.querywindow.opener) {
            parent.frames.queryframe.querywindow.opener = parent.frames.queryframe;
            }

            // reload_querywindow();
            return false;
            }
            }

            reload_querywindow();
            //-->
            </script>

            </body>
            </html>


            Is the problem from the database host? I think this the only factor which is common in all cases.

            Comment


            • #7
              Any help please ?

              Comment


              • #8
                What's the question?
                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
                  Every time it try to make a backup of the database (using phpmyadmin or mysqldump) I get an incomplete dump. It seems to stop every time at the same location as in the examples above. I don't know where the problem is and I need a solution for this problem.
                  Last edited by ashraf_gawdat; Wed 30 Nov '05, 1:22pm.

                  Comment


                  • #10
                    You can try this:

                    http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

                    If that doesn't work, then without shell access then the only other suggestion I have is to ask your host to make a backup for you.
                    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
                      I don't know if this will help or not, but you might be able to use this mod to input SSH commands on your server from vBulletins own admin panel. I've used it before and it works on some servers that don't allow SSH access(though not all).

                      http://www.vbulletin.org/forum/showthread.php?t=65926

                      SSH info help
                      http://www.vbulletin.com/docs/html/m...nce_ssh_backup

                      Comment

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