Hi, I have two tables I wish to combine into a single table. Both tables use the same format and include a unique key (ID) auto-increment field. Each row also contains a date field. Whoever managed this database in the past at some point set up a new server, and initially had new data sent to whichever server was less busy, but the two databases were not mirrored, so each contains entirely unique data, and there is a date overlap from when both servers were collecting data. I want to combine them into a single table now and get rid of the old server, but, because of 3rd-party software that interacts with the database, I need for the entire table to be sorted by the date field and assign all new auto-increment IDs based on that sorting (ie. the oldest dated record should have the lowest unique ID, etc..). There are approx 2.5 million records in each table (give or take), and, of course, I need to minimize downtime on the live database.
I'm no database expert, but I have read through a good part of O Reilly's MySQL book and scanned the FAQ and mail list, but this is a pretty specific case and I haven't turned up a lot of meaningful results thus far. My biggest concern is downtime. If not for that, I could probably muddle through it and get it done using my own crude methods. FYI The server is running RedHat 7.2 and MySQL 3.23.41 on Intel-based hardware. Thanks for any and all suggestions. Brendan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php