Mysqldump issue

I have 3servers where mysql 5.6.15-log MySQL Community Server (GPL) is installed. I am trying to take a dump using mysqldump it doesn't return any error the only output is the following:

-- MySQL dump 10.13 Distrib 5.6.15, for Linux (x86_64)
--
-- Host: localhost Database: db_name
-- ------------------------------------------------------
-- Server version 5.6.15-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 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-04-07 18:52:31

I tried the same mysqldump command on another servers that is set the same way, and it's working just fine.

why is that??

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 85

Dave BaldwinFixer of ProblemsCommented: 2016-04-07

What is the complete command you are using?

CCVOIPAuthor Commented: 2016-04-07

/usr/bin/mysqldump -uuser_name -ppwd --socket=/var/lib/mysql/mysql.sock --port=3306 --skip-lock-tables --single-transaction --flush-logs --hex-blobata=2 --databases db_name

I never use all those parameters. Try something simpler.

/usr/bin/mysqldump -uuser_name -ppwd --databases db_name

Open in new window

More info: http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

it gives the same result!!!!!!!! :(

The only thing I can think of is that the db_name doesn't exist. Or maybe the user_name doesn't have any privileges on that database.

CCVOIPAuthor Commented: 2016-04-08

it doesn't throw any error. the db name is correct and the user is root that has all the privileges.

Dave BaldwinFixer of ProblemsCommented: 2016-04-08

'root' does not necessarily have all privileges. I've seen table / database where 'root' was not one of the privileged users. I think someone has to remove it for that to happen. Long shot but I don't know what else to check at this point.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

CCVOIPAuthor Commented: 2016-04-13

that didn't help. still having the same issue. I will uninstall mysql and install it again and see what happens!!

Dave BaldwinFixer of ProblemsCommented: 2016-04-13

Duh... I just realized that that command doesn't send it to a file... without adding the filename at the end. Like this:

/usr/bin/mysqldump -uuser_name -ppwd --databases db_name > mybackup.sql

Mysqldump issue

Who is Participating?