[mythtv] Documentation: Save Recording Data
cmaahs at eatenbygrue.com
Tue Jun 10 10:16:22 EDT 2003
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
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.
More information about the mythtv-dev