[mythtv] Documentation: Save Recording Data

[Christopher Maahs]

In doing my upgrade from CVS to the 0.9 release (I realize there aren't 
that many differences) I found that the 0-8-to-0-9.sql didn't quite work, 
likely because I created the initial database from CVS after the 0.8 
release.  Anyway, rather than remove the lines, I decided to just drop the 
entire database, and recreate.  Taking the following advice from IMDB!

"Ripley: I say we take off and nuke the entire site from orbit. That's the 
only way to be sure."

Of course, not wanting to lose my existing recording information, I simply 
dumped the data I wanted to keep and restored it.

I'm thinking a section akin to 19.6, to describe how to backup the 
important data and restore it into the new database.  With a disclaimer of 
course that it may not work if there have been structure changes to these 
tables.

The process I suppose is simply:

1. backup the data
  - mysqldump -u root mythconverg --no-create-info --tables oldrecorded 
recorded recordedmarkup > tmp.mysql

2. drop the database (already in the docs)

3. create the database (mc.sql, also in the docs)

4. restore the data
  - mysql -u root mythconverg < tmp.mysql



I'm not sure if these three tables are the only three, but they seemed to 
accomplish what I was looking for.

If this is something we might want to have in the docs, let me know, and 
I'll do a more detailed version in the standard format.

~cj