On Thu, May 16, 2002 at 11:32:48AM -0400, Lance Lovette wrote: > I have partitioned my data such that each client has its own > database (clientdb1, clientdb2, ... clientdbN). All the databases > have the same structure (same tables, columns, etc.). This design > works great except for one caveat - when I make a change to the > database structure I have to make the same change to all the client > databases. Before I roll up my sleeves I thought I'd ask if there is > an easy way to synchronize the structure of databases so I can make > my changes to clientdb1 and then apply the changes to clientdb2...N.
Not really. You'll need to write a Perl/Python/whatever script to automate the process. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --------------------------------------------------------------------- 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