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

[Robert Tsai]

On Sun, Feb 12, 2006 at 06:06:15PM -0800, Yeechang Lee 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?

What is the error?

Anyway, wouldn't have been simpler to just use mysqldump to export
your old database, set up a new MySQL instance in its new home, and
import the data?

--Rob
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060212/c4dc6d61/attachment.pgp