#7 NOT ABLE TO BACKUP THE TABLES

closed
nobody
None
5
2011-09-15
2007-08-05
Michelle Day
No

NOT ABLE TO BACKUP THE TABLES Private: (?)
No
Hi All,

I am new to Linx and MYSQL I have managed to get the Auto backup working
but when I unzip it I get the below dump and when I restore I get the
Database but no Tables what am I doing wrong

-- MySQL dump 10.11
--
-- Host: localhost Database: World
-- ------------------------------------------------------
-- Server version 5.0.32-Debian_7etch1-log

/*!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 */;

Can you also tell me how I get it to keep a log file it has the option to
email it but I don't have email on the test server and wanted to get a log
file in my directory to look at.

Regards,
Michelle Day

Discussion

  • PittaGurneyi
    PittaGurneyi
    2011-08-30

    Well the stuff that you pasted doesn't tell me anything. If you want to keep a log file, just use stdout option and redirect stdout to a file, i.e.

    automysqlbackup /configfile.conf > /folder/somewhere/logfile

    Are you sure the user has appropriate permissions to dump the data?

     
  • PittaGurneyi
    PittaGurneyi
    2011-09-15

    • status: open --> closed
     
  • PittaGurneyi
    PittaGurneyi
    2011-09-15

    Okay ... this is old enough and the submitter doesn't respond, so I guess it's either resolved or not an issue anymore. Closed.