| Bug #4372 | mysqldump -e has no effect | ||
|---|---|---|---|
| Submitted: | 2 Jul 2004 11:56 | Modified: | 2 Jul 2004 16:14 |
| Reporter: | David Newcomb (OCA) | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: mysqldump Command-line Client | Severity: | S3 (Non-critical) |
| Version: | 4.1.3-beta-nt-log | OS: | Windows (Win2000 sp4) |
| Assigned to: | Dean Ellis | CPU Architecture: | Any |
[2 Jul 2004 16:14]
Dean Ellis
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: from the 4.1.0 changelog: "The --opt option for mysqldump now is enabled by default, as are all the options implied by --opt." Use --skip-extended-insert to disable that particular option.
Description: mysqldump always behaves as though -e is on. ie removing -e has no effect. How to repeat: C:\tmp\t>mysqldump -hsprint -uroot mentor > men.sql C:\tmp\t>mysqldump -e -hsprint -uroot mentor > men-e.sql C:\tmp\t>dir men* Volume in drive C has no label. Volume Serial Number is 7415-54D3 Directory of C:\tmp\t 02/07/2004 10:33 5,361,114 men-e.sql 02/07/2004 10:33 5,361,114 men.sql 2 File(s) 10,722,228 bytes 0 Dir(s) 46,926,274,560 bytes free C:\tmp\t>fc men-e.sql men.sql Comparing files men-e.sql and MEN.SQL FC: no differences encountered C:\tmp\t>mysqldump --extended-insert -uroot -hsprint mentor > men-e.sql C:\tmp\t>mysqldump -uroot -hsprint mentor > men.sql C:\tmp\t>dir men* Volume in drive C has no label. Volume Serial Number is 7415-54D3 Directory of C:\tmp\t 02/07/2004 10:50 5,361,114 men-e.sql 02/07/2004 10:50 5,361,114 men.sql 2 File(s) 10,722,228 bytes 0 Dir(s) 46,926,237,696 bytes free C:\tmp\t>fc men-e.sql men.sql Comparing files men-e.sql and MEN.SQL FC: no differences encountered Suggested fix: Worked in 4.0.x. Did not work in 4.1.2b either