A while ago I had some help from here to make a batch file that would dump my db. Everything was working just fine until 2 days ago and I just found out.
I checked my backup folder and found that starting on 4/25/2006 instead of creating a normal dump as it had been doing just fine for the last few weeks. The dump files are empty and only shows this now
-- MySQL dump 10.9
-- Host: localhost Database: test
-- Server version 4.1.14-nt
/!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 /;
/!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 /;
I don't know what all of a sudden caused the mysql dumps to stop working. I have not made any changes to the mysql server other then adding a new db and user. I am getting this problem when I try dumping any of the dbs I have. All I know is that just by looking at the file date created, the last backup it was able to create succesfully was on 4/24/2006 1:58pm
Please help.
