Jump to content

Database table columns upgrade


allex01

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.