Jump to content

[SOLVED] PHPMyAdmin MYSQL DB Structure Update Without Overwriting Data


dlebowski

Recommended Posts

Hello.  I have been using mysql and phpmyadmin for quite a while and came across a question the other day that I couldn't answer.  Is it possible to import in a new database structure (i.e. - i added some new tables, and modified other tables) without overriding the existing database data?  Basically I have a number of different databases that all have the same structure.  If I update the database structure, it would be much easier to be able to import the new structure without compromising the existing data.  Please let me know if anyone is aware of a way to do this.  Thanks.

 

Ryan

The only way you would mess up existing data is if you actually UPDATE those tables.  If you add new tables, then your old tables don't get touched.

 

Hard to tell exactly what you are asking.

I am referring to the import feature in phpmyadmin.  Sorry I'm unclear.  I'm not good with explaining myself on here. 

 

If I am in phpmyadmin, can I use that import feature to import new db structures without overwriting the existing data?

I would just want to update the table structure.  The table names would never be different.  It would just be adding new tables or new fields to existing tables. 

 

Basically I have my development database and then my "live" databases.  I want to make changes to the development database structure, export it, then import it into the live databases without messing up the existing data in the database.

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.