 |
 |
mysqldump help please
|
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
Hi, I'm trying to export a table to a file, but I can't figure out what option to use to remove this form the front of the file:
/*!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" */;
Anyone know how to get mysqldump to exclude this info from the beginning and end?
Thanks!
|
|
|
| |
|
|
|
|
|
|
|
Senior User
Join Date: Nov 2001
Location: State of Denial
Status:
Offline
|
|
I've never had that on my dumps, and the only option I use is --opt .
|
|
[Wevah setPostCount:[Wevah postCount] + 1];
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
Yah, it's strange. I'm using 4.1.7 standard.
|
|
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Oct 2000
Location: Seattle
Status:
Offline
|
|
the newer versions add new features. they use this syntax to hide new stuff from previous versions. unfortunately the older versions can have trouble importing them.
there is a way to force it to use a target version.
I'd try something like this:
--compatible=no_key_options,no_table_options
( from mysqldump --help )
--compatible=name
Change the dump to be compatible with a given mode. By
default tables are dumped in a format optimized for
MySQL. Legal modes are: ansi, mysql323, mysql40,
postgresql, oracle, mssql, db2, maxdb, no_key_options,
no_table_options, no_field_options. One can use several
modes separated by commas. Note: Requires MySQL server
version 4.1.0 or higher. This option is ignored with
earlier server versions.
|
|
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
Originally posted by Gavin:
the newer versions add new features. they use this syntax to hide new stuff from previous versions. unfortunately the older versions can have trouble importing them.
there is a way to force it to use a target version.
I'd try something like this:
--compatible=no_key_options,no_table_options
( from mysqldump --help )
--compatible=name
Change the dump to be compatible with a given mode. By
default tables are dumped in a format optimized for
MySQL. Legal modes are: ansi, mysql323, mysql40,
postgresql, oracle, mssql, db2, maxdb, no_key_options,
no_table_options, no_field_options. One can use several
modes separated by commas. Note: Requires MySQL server
version 4.1.0 or higher. This option is ignored with
earlier server versions.
That was one of the first things I tried, and it still shows up. Even using ansi, shows that extra text.
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
|
Top
