[horde] horde-db-migrate error

[Simon B]

On 20 June 2013 16:24, Michael J Rubinsky <mrubinsk at horde.org> wrote:
>
> Quoting Simon B <simon.buongiorno at gmail.com>:
>
>> Hi
>>
>> I'm trying to upgrade the backup DB to the latest structure, but I get
>> this error..
>>
>> root at mail:/usr/share/horde-prod# horde-db-migrate imp
>> [  INFO  ] Migrating DB up.
>>
>> ====================
>>
>> Fatal Error:
>> QUERY FAILED: Table 'horde4backup.imp_schema_info' doesn't exist
>>
>> SELECT version FROM imp_schema_info
>> In /usr/share/php/Horde/Db/Adapter/Mysqli.php on line 315
>>
>> 1. Horde_Db_Migration_Migrator->getCurrentVersion()
>> /usr/bin/horde-db-migrate:140
>> 2. Horde_Db_Adapter_Mysqli->selectValue()
>> /usr/share/php/Horde/Db/Migration/Migrator.php:121
>> 3. Horde_Db_Adapter_Mysqli->selectOne()
>> /usr/share/php/Horde/Db/Adapter/Mysqli.php:267
>> 4. Horde_Db_Adapter_Mysqli->execute()
>> /usr/share/php/Horde/Db/Adapter/Mysqli.php:252
>>
>> ====================
>>
>> Any ideas?
>>
>> No doubt I could add (copy?) the table from the current one - but that
>> seems exessive and extreme - right?
>
>
> What version of Horde is the backup database from? How did you back it up?
> Is it possible you missed the schema_info table?

I think it was actually v5.  I believe just did
mysqldump -u root -p --database horde4 > horde4backup.sql
mysql -u root -p < horde4backup.sql

Simon