Link to home
Create AccountLog in
Avatar of paries
paries

asked on

Can i remove some of this verbose-ness with mysqldump

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
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account