[RESOLVED] mysqldump problem - getting commented initial lines, no actual data

[bunner_bob]

This has always worked on other servers, but on the particular server I'm working on it's generating just comment lines and no actual data.

The request:

/usr/bin/mysqldump --opt --host=localhost --user=username --password=password database_name | gzip > /home/account_dir/sub_dir/dbname_backup_11_04_15.sql.gz

The result:

[code=php]-- MySQL dump 10.11

-- Host: localhost Database: database_name

---

-- Server version 5.0.92-community

/!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 /;[/code]

And that's it - end of file.

Any idea what's wrong, or what I should try?

Thanks!

• Bob

[sneakyimp]

Are you sure you have a username/password combo that is authorized for this database and it's tables? I believe MySQL supports table-level permissions. A user may be authorized to access a db but not it's tables.

[bunner_bob]

Ah HA - yes, the mysql user I was connecting as only had read/write privileges. I created a new user with full privileges and it worked. Thanks for steering me in the right direction!