Page 1 of 1

mysqldump option question

Posted: Wed Feb 22, 2006 2:01 am
by victhour
hi guyz!
i try this option of 'mysqldump' just to disabled some lines on my dumped file.

Code: Select all

--skip-opt --tz-utc=FALSE  --add-drop-table
but, what i want is how should i disable the following lines below:

Code: Select all

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

Posted: Thu Feb 23, 2006 7:29 pm
by ryos
Try --compact.

(And read man mysqldump for information about that program's options.)

Posted: Fri Feb 24, 2006 4:32 am
by victhour
no not that one... i want something like something below code:

Code: Select all

CREATE TABLE `user_mas` (
  `id_mas` int(8) unsigned NOT NULL auto_increment,
  `auth` char(1) NOT NULL default '',
  `usr` varchar(15) NOT NULL default '',
  `psw` varchar(30) NOT NULL,
  PRIMARY KEY  (`id_mas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `user_mas`
-- 

INSERT INTO `user_mas` VALUES (1, 'A', 'Victor', '1232f297a57a5a743894a0e4a801fc');
INSERT INTO `user_mas` VALUES (2, 'E', 'User', '27ccb0eea8a706c4c34a16891f84e7');
INSERT INTO `user_mas` VALUES (3, 'A', 'Admin', '27ccb0eea8a706c4c34a16891f84e7');
INSERT INTO `user_mas` VALUES (4, 'E', 'Demo', '368b9938746fa090d6afd362835513');
any idea? :)

Posted: Fri Feb 24, 2006 10:54 am
by feyd

Code: Select all

--skip-opt --compact -i
does it for me on MySQL 5.0.18