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



Subscribe to Comments Feed

Upcoming Linux Foundation Courses

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

View All Upcoming Courses

Become an Individual Member
Check out the Friday Funnies

Sign Up For the 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