Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
victhour
Forum Commoner
Posts: 38 Joined: Fri Feb 17, 2006 12:59 am
Contact:
Post
by victhour » Wed Feb 22, 2006 2:01 am
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 » Thu Feb 23, 2006 7:29 pm
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 » Fri Feb 24, 2006 4:32 am
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?
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Fri Feb 24, 2006 10:54 am
does it for me on MySQL 5.0.18