Question about output of mysqldump

[npereira]

Hello all,

My question is when I backup my DB using the command

mysqldump --user=username -ppassword dbname > dbname.sql

the output looks like

[code=php]

-- Table structure for table 'phpads_zones'

CREATE TABLE phpads_zones (
zoneid mediumint(9) NOT NULL auto_increment,
affiliateid mediumint(9) default NULL,
zonename varchar(245) NOT NULL default '',
description varchar(255) NOT NULL default '',
delivery smallint(6) NOT NULL default '0',
zonetype smallint(6) NOT NULL default '0',
what blob NOT NULL,
width smallint(6) NOT NULL default '0',
height smallint(6) NOT NULL default '0',
chain blob NOT NULL,
prepend blob NOT NULL,
append blob NOT NULL,
appendtype tinyint(4) NOT NULL default '0',
PRIMARY KEY (zoneid),
KEY zonenameid (zonename,zoneid)
) TYPE=MyISAM;

--

-- Dumping data for table 'phpads_zones'

[/code]

then, when trying to restor it via phpmyadmin, it complains saying

Error

SQL-query :  

--
* - 

MySQL said: 


You have an error in your SQL syntax.

It does not recognise the -- as comments.

How can I fixe this so that when i do a mysqldump, it put # instead of -- for comments?

[BeastRider]

This incompatibility between mysqldump and phpMyAdmin drove me absolutely nuts... so much so that I finally gave up and installed a local copy of phpMyAdmin so that I would have dump file compatibility.

You can force mysqlsump to dump data and sql separately... I fergits the exact command line syntax. Then, within phpMyAdmin you can find a place to load a text file. I did get this to work eventually by matching the end of field, end of line, and field delimiter characters. But it was a pain in the arse.

Although setting up phpMyAdmin on my local machine was a hassle... Sambar Server, then PHP, then phpMyAdmin, I am happy I did it... exports and imports now work seamlessly.

[npereira]

I'm wondering why, when you dump via phpMyAdmin it formats the comment lines with # on the lines, but when you use mysqldump it formats the comment lines with --

phpMyAdmin should be smart enough to recognise -- as comment lines. But I guess it's not!