Announcement

Collapse
No announcement yet.

A big problem with database backup

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

  • James T Brock
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • ashraf_gawdat
    replied
    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, 2:22pm.

    Leave a comment:


  • Steve Machol
    replied
    What's the question?

    Leave a comment:


  • ashraf_gawdat
    replied
    Any help please ?

    Leave a comment:


  • ashraf_gawdat
    replied
    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.

    Leave a comment:


  • ashraf_gawdat
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    Are you sure? It looks like it's used to make backups as well.

    Leave a comment:


  • ashraf_gawdat
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    Some people have reported success with Bigdump which you can find here:

    http://www.ozerov.de/bigdump.php

    Leave a comment:


  • ashraf_gawdat
    started a topic A big problem with database backup

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X