Linux.com

Home Learn Linux Linux Tutorials Evolving A Database With MySQL

Evolving A Database With MySQL

In present-day programming, the data storage is far from the static beast some people believe it once was. Lots of applications have their own piece of data storage in relational databases and the shape of that storage alters as often as the applications themselves: daily. The only problem is that while the structure must change often, the data just has to morph itself around that, and stay essentially what it was, but in the new form.

In this howto, I will show you how to "grow" your own database definition in a way that is maintainable. I will make so-called "recreate" scripts. These scripts can be used to both create a database from scratch and update an existing database. When I say database definition, it will not be limited to table structure, we will "grow" the data also. But not all of it. Only what's necessary...

 

Article Source HowtoForge
October 23, 2009, 6:25 am
Read More

 

Comments

Subscribe to Comments Feed

Upcoming Linux Foundation Courses

  1. LFS201 Essentials of System Administration
    12 Jan » 30 Mar - Online Self-Paced
    Details
  2. LFD331 Developing Linux Device Drivers
    06 Apr » 10 Apr - Virtual
    Details
  3. LFS540 Linux KVM Virtualization
    06 Apr » 09 Apr - Austin - TX + Virtual
    Details

View All Upcoming Courses

Become an Individual Member
Check out the Friday Funnies

Sign Up For the Linux.com Newsletter


Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board