Re: [Slashcode-development] OT: mysqldump and auto_increment

[Clifton W. <cl...@sl...>]

On Wednesday 23 July 2003 06:17, shane wrote:
> Anyone know how to make mysqldump ignore the auto_increment field?
>
> There's a mention from Sinisa Milivojevic from TcX saying that it
> was to be put on the TODO list - from 04/2000.
>
> <URL:
> http://groups.google.com/groups?q=mysqldump+auto_increment&ie=ISO-
>8859-1&hl=en&btnG=Google+Search
>
>
>
> As far as I can tell, w/ mysql 4.x mysqldump doesn't yet have the
> cabability.
>
> So... does anyone know how to do it?
>
> Or is everyone, including OSDN, using a custom script to pull data
> out of the db to create dump files such as datadump.sql for
> themes?

Shane,

Right now, I think you are limited to either writing a script to do 
it or editing by hand. It would be a nice feature to be sure.

Makes an interesting problem, though. I can see one way a
general script could be written that would take a field and an 
optional table and would then go through the output of a
"mysqldump -c" and remove all values that match. That would
be rather easy for me to do, I think. If you want, I can try and
crank it out by the end of the weekend.

'twould be a fun excercise.

- Cliff