allex01 Posted March 3, 2009 Share Posted March 3, 2009 I have a social networking script that contains about 45 tables. Thru out the years i have added many custom fields and tables to the database. A new version of the script came out with a database that still uses the same database structure + newly added tables and columns. Again My older database also have new tables and new added columns per table. What is the easiest way to transfer export and import my old database to the new one and write all the information over the new database so that if a column or table did not exists in the new database, it will simply get created and all information will be written. Any php code that could help do this. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/147801-database-table-columns-upgrade/ Share on other sites More sharing options...
fenway Posted March 4, 2009 Share Posted March 4, 2009 Sounds like a freelanching request.... Quote Link to comment https://forums.phpfreaks.com/topic/147801-database-table-columns-upgrade/#findComment-776207 Share on other sites More sharing options...
allex01 Posted March 4, 2009 Author Share Posted March 4, 2009 I'm asking about the easiest way to do this and not how to do it. I can do it manually but it takes a long time to transfer all the tables and create the newly added columns. Quote Link to comment https://forums.phpfreaks.com/topic/147801-database-table-columns-upgrade/#findComment-776523 Share on other sites More sharing options...
fenway Posted March 4, 2009 Share Posted March 4, 2009 I'm asking about the easiest way to do this and not how to do it. I can do it manually but it takes a long time to transfer all the tables and create the newly added columns. So what's the difference between the dbs? Quote Link to comment https://forums.phpfreaks.com/topic/147801-database-table-columns-upgrade/#findComment-776676 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.