[mythtv-users] moving database from FC4 to gentoo (mysql 4 to 5)
David Campbell
dave at cpfc.org
Sun Feb 11 22:14:42 UTC 2007
Brad Fuller wrote:
>
> David Campbell wrote:
>> Brad Fuller wrote:
>>
>>> I'm looking thru the online MySql docs but can't find the answer. The
>>> mythtv gossamer threads server seems to be down (Unable to connect to
>>> search server: Connection refused)
>>>
>>> I'm trying to move a mythtv database from FC4 to Gentoo
>>>
>>> On the FC4 machine running mysql version 4 I dumped the mythconverg
>>> database using:
>>> mysql dump -tc -u mythtv -p mythconverg > mythdb.sql
>>>
>>> On the gentoo machine (it's actually the same machine) I ran the
>>> mysql -u root -p < /usr/share/mythtv/database/mc.sql
>>>
>>> because I figured I needed to add the user first.
>>>
>>> I DROP'd the database and I tried to restore the database using from the
>>> FC4 database:
>>>
>>> mythsql -u mythtv -p mythconverg < mythdb.sql
>>>
>>> but I receive the following error:
>>>
>>> ERROR 1146 (42S02) at line 21: Table 'mythconverg.callsignnetworkmap'
>>> doesn't exist.
>>>
>> 1. delete the database on gentoo
>>
>> mysql -uroot -p
>>
>> mysql> drop database mythconverg;
>>
>> Then recreate it;
>>
>> mysql> create database mythconverg;
>>
>> 2. Dump the myth db on the fc server
>>
>> mysqldump --opt -uroot -p mythconverg > mythconverg.sql
>>
>
> I did see the --opt option in the MySql docs and I noted it. I wanted to
> get some more opinions about it first. Thanks!
>
> you did not add a "-c" option which i see all the time. Why?
I have never used the -c option in all my years using mysqld
Dave
--
David Campbell :: www.cpfc.org
More information about the mythtv-users
mailing list