I did the same thing but using O-10g Used a sql statement to move the data from one table to another I'm looking for my statement but it is written w/my DB names & Oracle Have not used MySql but wld like to try it for knowledge Let me know if u want the sql & u can try it??
Ian Redding NTP Website System Administrator (http://ntp.niehs.nih.gov) Contractor - INDUS Corp (www.induscorp.com) E-mail: [EMAIL PROTECTED] 919-541-0642 -----Original Message----- From: RobG [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 1:47 PM To: farcry-dev Subject: [farcry-dev] Setting up a duplicate (development) FC instance My client isn't happy with the standard webskin, so I want to make a new one for him. Before I start, I want to create a complete copy of his FarCry site on my local machine. I have everything setup and running... the sticking point is the database. I made a copy of his db, but the new instance wouldn't install into an existing DB (MSSQL). So I created a clean db and let it install into that. Now I want to copy the data out of his regular db into the new one. I tried a regular data export/import using MSSQL Management Studio but ran into all kinds of errors. Then I tried just switching the DSN to point to the copy of his existing db, but that doesn't seem to work either. How can I get the db's synchronized? On another topic... my new local install is 4.0.9 and his site is on 4.0.3. I want to upgrade his site to 4.0.9. Can I just copy all of the core/plugin files over top of 4.0.3? Thanks! Rob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
