NYCPHP Meetup

[Peter Sawczynec]

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
ps at blu-studio.com 
www.blu-studio.com 


> -----Original Message-----
> From: talk-bounces at lists.nyphp.org [mailto:talk-
> bounces at lists.nyphp.org] On Behalf Of Daniel Convissor
> Sent: Monday, July 26, 2010 10:08 AM
> To: NYPHP Talk
> Subject: Re: [nycphp-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