Results 1 to 2 of 2

Thread: Unable to Schedule Successfuly MySQL backup Jobs

  1. #1

    Default Unable to Schedule Successfuly MySQL backup Jobs

    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?

  2. #2
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,448

    Default Re: Unable to Schedule Successfuly MySQL backup Jobs

    One possibility is that you are using incompatible versions of the programs. The default MySQL character set was changed from Swedish to utf-8 with, I think, 5.1 - it is certainly different now. That may be what the message is about.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •