The MU forums have moved to WordPress.org

mysqldump erroring out (3 posts)

  1. dancameron
    Member
    Posted 18 years ago #

    I have a pretty large DB, nothing special though. I converted it to INNODB on some recommendations and phpMyAdmin will still not load the table but that's not the problem.

    I can't do a mysqldump.

    The file that it creates has this in it.

    I'm a t a real loss since I can't do any real backups right now.

    Thanks.

    mysqldump: Got error: 1016: Can't open file: './myvbs/wp_1056_categories.frm' (errno: 24) when using LOCK TABLES
    -- MySQL dump 10.10
    --
    -- Host: localhost Database: myvbs
    -- ------------------------------------------------------
    -- Server version 5.0.27

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_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_CHECKS=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 @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

  2. quenting
    Member
    Posted 18 years ago #

  3. drmike
    Member
    Posted 18 years ago #

    Either that or find that shutdown plugin that we've discussed here a few times and take your site down for long enough to do the dump.

About this Topic

  • Started 18 years ago by dancameron
  • Latest reply from drmike