[mythtv-users] How to move MythTV database to another partition?

[Steven Adeff]

On 2/12/06, Yeechang Lee <ylee at pobox.com> wrote:
> Following up to my earlier report of the horrific disk crash that
> claimed the life of my previous MythTV database, I'd like to move the
> new database to a partition of its own. I am using the ATrpms Myth
> distribution on Fedora Core 4.
>
> I did the following:
>
> * Create a new partition mounted as, amazingly enough, /mythtv.
> * Shut down both mysqld and mythbackend.
> * Create /mythtv/mysql and chown it to mysql:mysql.
> * Move all the files in /var/lib/mysql to /mythtv/mysql. (I did it
>   this way instead of just moving /var/lib/mysql to /mythtv because I
>   wanted to not break any RPM package links connected to the
>   directory.)
> * Edit the datadir, socket, and basedir parameters in /etc/my.cnf to
>   reflect the new paths (basically, just change '/var/lib/' to '/mythtv'.
>
> However, the above steps result in an error when starting
> mysqld. (Fortunately, reversing the steps restored everything to
> normal.) What am I missing?

I did the exact same as you when I created a new system drive, moved
the db over to my recordings drive temporarily. Worked fine, so I
don't know what went wrong in your process. What was the error mysql
gave you?

--
Steve