WordPress.org

Ready to get started?Download WordPress

Forums

WP-DBManager
No data in dump (4 posts)

  1. belg4mit
    Member
    Posted 2 years ago #

    I just discovered that my updates have had no data in them since June. I'm using the current version of the plug-in, and tried reinstalling to no avail.

    The backup is not empty, but it only contains server settings. It looks like my ISP upgraded MySQl around this time, but that ought not have caused this sort of failure.

    Head of full backup:

    -- MySQL dump 10.13  Distrib 5.1.52, for pc-linux-gnu (i686)
    --
    -- Host: localhost    Databas
     e: scisci_www
    -- ------------------------------------------------------
    -- Server version 5.1
     .52
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHAR
     ACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLAT
     ION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*
     !40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHE
     CKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OL
     D_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

    Full content of incomplete backup:

    -- MySQL dump 10.13  Distrib 5.1.56, for pc-linux-gnu (i686)
    --
    -- Host: localhost    Databas
     e: scisci_www
    -- ------------------------------------------------------
    -- Server version 5.1
     .56
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHAR
     ACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLAT
     ION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*
     !40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHE
     CKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OL
     D_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

    http://wordpress.org/extend/plugins/wp-dbmanager/

  2. Lester Chan
    Member
    Plugin Author

    Posted 2 years ago #

  3. belg4mit
    Member
    Posted 2 years ago #

    The error I get is:

    mysqldump: Couldn't execute 'show create table Mods': SHOW VIEW command denied to user 'wwwuser'@'localhost' for table 'Mods' (1142)

    That's a view created by another user, so it's a permission problem, but perhaps you should include --force so that as much data as possible is exported. As a work-around, user's can set "Path to mysqldump" to "/usr/bin/mysqldump --force". This will cause the plugin's test of the binary to fail, since it does not strip the switch, but the command will execute fine.

    I would also look into doing piped IPC so that you can capture and report error messages like this. Rhat way people are not caught off guard by bad backups, and so that you can also give the password to mysqldump interactively rather than on the command line (a major no-no, that's viewable in the process table).

  4. Lester Chan
    Member
    Plugin Author

    Posted 2 years ago #

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic