Okay, thank you all and here is how this worked out. David's suggestion that I just use the MySQL Administrator tool for ad hoc backups worked correctly. The dump was created and the proper comments, settings and switches included. Nice.
As to the email client: I use Outlook 2007 on Windows 7 (~}:|) So email formatting (especially top-posting vs. bottom-posting) has its place among sweeping major unsolved historical mysteries such as the plains of Nazca lines and Puma Punku at Tiahuanaco. Nonetheless, I did set it so that my plain text replies will be indented with a >. Do not try any of this at home. Warmest regards, Peter Sawczynec Technology Dir. blūstudio 941.893.0396 [email protected] www.blu-studio.com > -----Original Message----- > From: [email protected] [mailto:talk- > [email protected]] On Behalf Of Daniel Convissor > Sent: Monday, July 26, 2010 10:08 AM > To: NYPHP Talk > Subject: Re: [nyphp-talk] phpMyAdmin and MySQL DB Backup > > Peter: > > On Sat, Jul 24, 2010 at 12:55:21PM -0400, Peter Sawczynec wrote: > > > understand one way to get around this all is to remove the record > with the > > autoincrement value of 0. After that this mode would no longer be > needed. > > IIRC > > you cannot simply edit an autoincrement field (by design), so you'd > need to > > take the restrictions of and do some data massaging. > > Sure you can. This query should run without incident. > > UPDATE table SET id = MAX(id) + 1 WHERE id = 0; > > --Dan > > PS: Get an email client that knows how to properly quote prior > messages > you are replying to. > > -- > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > data intensive web and database programming > http://www.AnalysisAndSolutions.com/ > 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 > _______________________________________________ > New York PHP Users Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
