NYCPHP Meetup

[Peter Sawczynec]

Okay, here is an issue that is not straight PHP related, but close and I
really could use some good feedback.

___________

 

Recently, I have had a DB dump/backup (created using the phpMyAdmin
interface) fail because there is a single table in this db that needs this
exception written into the backup file output: "SET
SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;" 

 

It seems, the phpMyAdmin interface does not have an option to create this in
a backup output. 

 

Is anyone familiar with a db backup/copy tool that can handle this special
exception state and can backup/copy a db with this need? 

 

Two other small things:

1)  This term:  SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO" << this is part of SQL
or MySQL? 

2) /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;  << if
I see a row like this in a db dump, what is it? is this a comment or what?

 

Thanks for any input on the above. 

 

Warmest regards, 

 

Peter Sawczynec 

Technology Dir.

blūstudio 

941.893.0396

 <mailto:ps at sun-code.com> ps at blu-studio.com 

 <http://www.blu-studio.com> www.blu-studio.com 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20100724/4d36d9ae/attachment.html>