Executive Summary: The eMachines EL1300G-02w is a good choice for a low power home theater PC (HTPC) or media computer. Pros: Small form factor, low energy use, low noise with stock fans, DVD-DL R/W +/- optical drive, lots of media card readers. Cons: 160GB stock HD will need to be swapped out for back-end use, VGA video out (only), Analog Audio out (only), minimal expansion capabilities.
Continue reading →

Backup the database on your source machine. Newer versions of mythtv do this for you automatically. Check out the mythconverg_backup.pl script if you have to do it manually.

Delete any existing database on your destination machine:

$ mysql -u root
mysql> DROP DATABASE IF EXISTS mythconverg;
mysql> quit


Re-create the empty database on your destination machine:

$ mysql -u root < mc.sql (You may need to use the -p option and enter your root password)

You may also have to set up the mythtv user with the correct password:

$ mysql -u root < mc.sql UPDATE user SET Password=PASSWORD('YOURPASSWORDHERE') WHERE user='mythtv'; FLUSH PRIVILEGES;

After this, run the mythconverg_restore.pl script:

mythconverg_restore.pl --filename mythconverg-1214-20091010150513.sql.gz

You may have to specify hostname, database name and enter the password if you don’t have a mysql.txt file set up in my .mythtv directory. You may also have to specify the fully qualified path to the file if it’s not located in your default backup directory.