troubleshooting Question

Can i remove some of this verbose-ness with mysqldump

Avatar of paries
paries asked on
MySQL Server
1 Comment1 Solution379 ViewsLast Modified:
hello,
I am issuing the following command

/usr/bin/mysqldump mkevents --no-create-info --skip-comments  mke_users "--where= uid = 25 "   -u USER --password=PASSWD -h localhost >> /home/tmp/deleted/user_25.sql

This works, but i would like to remove these statements in the sql
(there are more , but this is a sample)
/*!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 */;

I thought --skip-comments was the ticket, but did not make a difference

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros