[mythtv-users] major db problem upgrading from 0.21-fixes to 0.22
Audio Phile
da_audiophile at yahoo.com
Sun Mar 7 10:30:43 UTC 2010
Thank you both for the advice.
@mtdean - I attempted your procedure (http://www.gossamer-threads.com/lists/mythtv/users/406111#406111) but ran into trouble:
I can drop the db okay but I couldn't use your code with the echo << "EOF", I had to type out each step as shown:
$ mysql -umythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 535
Server version: 5.0.75 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> DROP DATABASE IF EXISTS mythconverg;
Query OK, 54 rows affected (0.01 sec)
mysql> CREATE DATABASE IF NOT EXISTS mythconverg;
Query OK, 1 row affected (0.00 sec)
mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Query OK, 1 row affected (0.01 sec)
mysql> quit
Bye
I can restore the blank one okay:
[mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-blank.sql.gz --verbose
Configuring environment:
- username: mythtv
- HOME: /home/mythtv
- MYTHCONFDIR: /home/mythtv/.mythtv
Parsing configuration files:
- checking: /home/mythtv/.mythtv/config.xml
parsing: /home/mythtv/.mythtv/config.xml
- checking: /home/mythtv/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 0
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/mythtv
DBBackupFilename: mythconverg-1214-blank.sql.gz
create_database:
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Found 0 tables in the database.
Backup file is compressed.
- Uncompressing backup file with IO::Uncompress::Gunzip.
Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.
Executing command:
'mysql' --defaults-extra-file='/tmp/RCfj5LUMX4' --host='localhost' --user='mythtv' 'mythconverg'
mysql exited with status: 0
Restored 1553 of 1553 lines.
Successfully restored backup.
But I can't restore my backup:
[mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl --dir=$HOME --file=mythconverg-1215-20100306190349.sql.gz --verbose
Configuring environment:
- username: mythtv
- HOME: /home/mythtv
- MYTHCONFDIR: /home/mythtv/.mythtv
Parsing configuration files:
- checking: /home/mythtv/.mythtv/config.xml
parsing: /home/mythtv/.mythtv/config.xml
- checking: /home/mythtv/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 0
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/mythtv
DBBackupFilename: mythconverg-1215-20100306190349.sql.gz
create_database:
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Found 54 tables in the database.
WARNING: Database not empty.
ERROR: Unable to do a full restore. The database contains data.
Can you advise?
More information about the mythtv-users
mailing list