Oh, myqldump automatically records the current auto-increment when it dumps in the .sql file... That explains it...
On Mon, 24 Jan 2005 17:10:11 -0500, "leegold" <[EMAIL PROTECTED]> said: > > On Mon, 24 Jan 2005 12:34:38 +0200, "Gleb Paharenko" > <[EMAIL PROTECTED]> said: > > Hello. > > > > Not enough information to make a conclusion. Please, send us information > > about MySQL and operating system versions. Output of "show create table" > > statement on your tables. Could you make a reproducable test case? > > Yeah, I just reproduced it at home and at work on different PC's. It > happens on windows XP or 2K. And, There is some very weird actvity were > a particular table will not update from PHP but will from the command > line. And yeah it's a new DB name which then has the tables and structue > added to it via a mysqldump dump file...the new DB adopts the auto > increment starting value of the 1st DB whose structure I dumped in to > the 2ndn (but no data is dumped). They have same table/field names but > slightly different DB names...wish I had more time to say more. But the > updating mysteriousness is causing hair ripping... > > > > > "leegold" <[EMAIL PROTECTED]> wrote: > > > I have two different databases they both have an auto-increment PK field > > > and while they are different databases with different names, they do > > > have tables with the same names. What I find is that the auto-crement > > > integer number remembers what it is across these databases. So if I > > > insert in the 1st DB and the number is 24, then I insert in the 2nd DB > > > the number will be 25. I would of thought that the number would be > > > "fresh" and independent between the DBs. Could you explain? > > > > > > > > > -- > > For technical support contracts, goto https://order.mysql.com/?ref=ensita > > This email is sponsored by Ensita.NET http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > > <___/ www.mysql.com > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]