Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: MySQL Table Merging
10-23-2009, 04:47 AM #1
- Join Date
- Feb 2009
- Thanked 0 Times in 0 Posts
MySQL Table Merging
I am working on a system to provide remote updates to installations of my software. Basically, the remote installation will grab the update zip file from my server and copy appropriate files.
In certain cases, a database structure update may be required as well. What would be the best method to accomplish this? Ideally, all of the information contained within the database would be copied to the corresponding columns in the new table structure. The problem seems to lie in transferring table rows when a column no longer exists.
For example, in a system configuration table, the column "TestURL" is no longer needed, and is removed in the new table structure. When I export the original table data, this column exists, but when I try to import the data an error is thrown that the column does not exist.
Rather confusing to explain, I hope this makes sense to someone who has encountered and solved this before. Thanks!
10-23-2009, 02:54 PM #2
- Join Date
- Jun 2002
- Nashville, TN
- Thanked 26 Times in 26 Posts
eak | "Doing a good deed is like wetting your pants; every one can see the results, but only you can feel the warmth."