WordPress.org

Ready to get started?Download WordPress

Forums

DBC Backup
MySQL client ran out of memory (1 post)

  1. Eduardo Santos
    Member
    Posted 3 years ago #

    Dear sirs,

    Just installed the plugin on a production site. We have lots of users and page views per day so I think database shall be a little big.
    After installation/configuration I run a immediate backup.
    The log shows success and the SQL file is created. The file is though, very small. And looking inside it shows that MySQL crashed.
    Any suggestions? I copied the begining of the file below.

    Thanks in advance,

    -- Database Cron Backup
    -- Version 1.0 for WordPress 2.5+
    -- Copyright Chris T aka Tefra http://www.t3-design.com
    -- Generated: Wednesday 22nd of December 2010 04:10 PM
    -- MySQL Server: Localhost via UNIX socket
    -- MySQL Server version: 5.1.47
    -- Database: xxx
    -- --------------------------------------------------------

    --
    -- Table structure of table wp_StatSurfer
    --

    DROP TABLE IF EXISTS wp_StatSurfer;
    CREATE TABLE IF NOT EXISTS wp_StatSurfer (
    id mediumint(9) NOT NULL AUTO_INCREMENT,
    date tinytext COLLATE utf8_unicode_ci,
    time tinytext COLLATE utf8_unicode_ci,
    ip tinytext COLLATE utf8_unicode_ci,
    urlrequested text COLLATE utf8_unicode_ci,
    agent text COLLATE utf8_unicode_ci,
    referrer text COLLATE utf8_unicode_ci,
    search text COLLATE utf8_unicode_ci,
    nation tinytext COLLATE utf8_unicode_ci,
    os tinytext COLLATE utf8_unicode_ci,
    browser tinytext COLLATE utf8_unicode_ci,
    searchengine tinytext COLLATE utf8_unicode_ci,
    spider tinytext COLLATE utf8_unicode_ci,
    feed tinytext COLLATE utf8_unicode_ci,
    user tinytext COLLATE utf8_unicode_ci,
    timestamp tinytext COLLATE utf8_unicode_ci,
    threat_score smallint(6) DEFAULT NULL,
    threat_type smallint(6) DEFAULT NULL,
    UNIQUE KEY id (id)
    ) TYPE=MyISAM AUTO_INCREMENT=821370 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    --
    -- Dumping data for table wp_StatSurfer
    --

    --
    -- Dumping data for table wp_StatSurfer
    --

    --MySQL client ran out of memory
    --
    -- Table structure of table wp_StatSurfer_countries
    --

    --Lost connection to MySQL server during query
    --
    -- Dumping data for table wp_StatSurfer_countries

    http://wordpress.org/extend/plugins/dbc-backup/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

  • RSS feed for this topic
  • Started 3 years ago by Eduardo Santos
  • This topic is not resolved
  • WordPress version: 3.0.1

Tags