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:p...@sun-code.com> p...@blu-studio.com <http://www.blu-studio.com> www.blu-studio.com
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
