I’m running:
OpenSuSE 11.1
MySQL 5.0.67
MySQL Administrator 1.2.12
I have one database for my web application. It’s using MyISAM tables. In MySQL admin, I went to Backup and created a scheduled backup project called backup1.
On the advanced tab, I selected “Lock All Tables” and checked the box for “Backup Selected Database Completely”.
On the Schedule Backup tab I have “Execute this Project Daily” selected and the time 1AM.
The target directory is set along with the connection name. The connection it’s using is the same MySQL user that my web application uses in order to utilize the database. It has full access to that database.
Now when the backup file is created, it backs up no data at all. Instead in creates files that are 580bytes in size. When I open the files they contain:
– MySQL Administrator dump 1.4
– Server version 5.0.67
/*!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’ */;
Any ideas?