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.<\/p>\n
Delete any existing database on your destination machine: Re-create the empty database on your destination machine: You may also have to set up the mythtv user with the correct password: After this, run the mythconverg_restore.pl script: 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 … Continue reading
\n
\n $ mysql -u root
\n mysql> DROP DATABASE IF EXISTS mythconverg;
\n mysql> quit
\n<\/code><\/p>\n
\n
\n$ mysql -u root < mc.sql\n<\/code> (You may need to use the -p option and enter your root password)<\/p>\n
\n<\/code>
\n$ mysql -u root < mc.sql\nUPDATE user SET Password=PASSWORD('YOURPASSWORDHERE') WHERE user='mythtv';\nFLUSH PRIVILEGES;\n<\/code><\/p>\n
\n<\/code>
\nmythconverg_restore.pl --filename mythconverg-1214-20091010150513.sql.gz
\n<\/code>
\nYou 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.<\/p>\n","protected":false},"excerpt":{"rendered":"