Hello Everyone!! I've just joined this list and have already started to enjoy the various threads that are running. I also wanted to get some feedback on something that I'm trying to do.
I have currently developed a survey system that uses a mysql database that consists of 15 tables. The database is kept and administered on the server in the office and then dumped out and copied across to a notebook server which we then take out to run our application and which then get updated with user input. When we return back to the office the database is dumped out and replaces the one on the office server. The first issue is that we now have the need to run two notebook servers, which mean we can't just dump the data out and copy it across. The second issue is that the company data we are holding is getting way too big to carry around on the laptops. What I want to do is to keep the office based database as the admin, allowing us to add companies and users etc... I then, for each survey workshop, want to be able to output 11 tables exactly how they appear on the office database with the other 4 tables being empty structures that I can insert smaller amounts of company and user data into. Having read the manual I think it comes to doing it one of two ways: 1) Use replication to keep the 11 tables up to date and then use "create table" to build the other 4 tables. 2) Use "create table" to build the workshop databases from the main database. Any advice on the best solution would be greatly appreciated. Thanks in advance Regards D@n ================================== Design evokes emotion, gives identity, communicates an idea and compels a response __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.comm --------------------------------------------------------------------- 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