site v2 table dumps

Here is the table dump feature I want my site’s apps to have:

  • Dump changed tables into files on the server’s file system right after changes are made.
  • Distribute dump files into the directory in such a way that the time of the dump will be known from the URI.
  • Distribute dump files in such a way that no one directory grows too large.
  • File dump time will be the UTC+0 UNIX Time (same value as a timestamp).
  • Make sure I’ll have enough information to accurately recreate the database at any point in time.
  • Have an app or memorandum instructing me on how to recreate the database.
  • Email a copy of the dump file to me every time one is created.

What if I end up using PHP Fog or similar cloud hosting?

  • Each app already has master and slave databases.
  • I still want a CVS style backup of the database tables.
    • Do what I said I’ll do above.
    • Maintain these table files as part of the Git repository.

Caution: Let’s say I do some development at my workstation. And then I merge that repository with production. Maybe the files for the database tables will get erased. I’ll need to make sure that doesn’t happen.

Advertisements

About samehramzylabib

See About on https://samehramzylabib.wordpress.com
This entry was posted in Version 2.0 Site Design and tagged , . Bookmark the permalink.

Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s