mysqldump option question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
victhour
Forum Commoner
Posts: 38
Joined: Fri Feb 17, 2006 12:59 am
Contact:

mysqldump option question

Post 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!
ryos
Forum Newbie
Posts: 16
Joined: Tue Feb 14, 2006 4:55 pm

Post by ryos »

Try --compact.

(And read man mysqldump for information about that program's options.)
victhour
Forum Commoner
Posts: 38
Joined: Fri Feb 17, 2006 12:59 am
Contact:

Post 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? :)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Code: Select all

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