/*!40000 Alter Table ???

[theboss]

hello, do you know how avoid that mysqldump produce lines starting with /*!40000 ALTER TABLE nametable ...


thanks

[Steve Machol]

I'm not aware of any way to do this - or any reason for that matter. Is this in regards to a vB backup? If so, to get vb support on these forums you first need to register for Priority Forum Support. To do this, please click HERE (http://www.vbulletin.com/members/forums.php) and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page. Thanks.

[theboss]

it is not vB related, but mysql 3.23.54 produce, by default, this line with command mysqldump --opt, when I try to restore the db (mysql -u -p db < db.sql) I receive error 1065, error that disappear removing (manually) the 40000 refer.

thanks

[Steve Machol]

Sorry, I don't know how to remove this. Since these are vB support forums, you might have more luck searching for an answer at http://www.mysql.com

Good luck!

[eva2000]

hello, do you know how avoid that mysqldump produce lines starting with /*!40000 ALTER TABLE nametable ...


thanks
this mysql forum is for vB related support... you should be able to find you answer at http://www.mysql.com/doc/en/mysqldump.html look at the options

[theboss]

anyway thanks for your courtesy.

[fury]

Dumps made on 3.23.5x usually need to be restored on the same version or higher.

[theboss]

Dumps made on 3.23.5x usually need to be restored on the same version or higher.


thanks for your courtesy, I verified that problem was about 2 different version between local and remote mysql, 3.23.34 and 3.23.54 .

[Streicher]

We have had the same problem. You can avoid this by using:

mysqldump --no-defaults --add-locks -e -q -h localhost -u user -p password dbname > backup.sql

This is the dump The_Sisko has written for our server.