I solved this problem with mysqldump.
Hello,
I am trying to move our production installation (ubuntu 8.04, egw CE 1.8004) to a new server Ubuntu 12.04.
I did a new install of ubuntu and egw and that is working.
I took a backup file of my existing EGW server (db-backup…bz2 file) and tried to restore it in the new installation.
Iget following message :
restore started, this might take a few minutes …
CreateIndexSQL(NULL,‘egw_wiki_pages’,‘wiki_body’,Array ( [0] => FULLTEXT ) ) sql=Array ( [0] => ALTER TABLE egw_wiki_pages ADD FULLTEXT INDEX egw_wiki_pages_body (wiki_body) )
The used table type doesn’t support FULLTEXT indexes
eGroupWare API version 1.8.004 found. eGroupWare configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is working, but you dont have any applications installed (mysqli://egroupware:OMWkbs!(9GY3JL0D@localhost/egroupware). Use --install to install eGroupWare.
When I go back to the setup I see red crosses on everything.
Then I do “install” all applications and I get messages about "table already exist"
When I go back to setup I get :
You appear to be running version 1.8 of eGroupWare.
We will automatically update your tables/records to 1.8.004 but we highly recommend backing up your tables in case the script causes damage to your data.
If I try “upgrade”,
I get :
process->pass(): #1 for upgrade processing
process->upgrade(): Incoming : appname: phpgwapi, version: 1.8, status:
process->upgrade(): No table upgrade available for appname: phpgwapi, version: 1.8
process->upgrade(): Outgoing : appname: phpgwapi, status: F
process->upgrade(): Incoming : appname: admin, version: 1.8, status:
process->upgrade(): Upgrade of admin to 1.8 is completed.
process->upgrade(): Outgoing : appname: admin, status: C
process->upgrade(): Incoming : appname: preferences, version: 1.8, status:
process->upgrade(): No table upgrade required/availible for preferences
process->upgrade(): Outgoing : appname: preferences, status: C
process->upgrade(): Incoming : appname: etemplate, version: 1.8, status:
process->upgrade(): Upgrade of etemplate to 1.8 is completed.
process->upgrade(): Outgoing : appname: etemplate, status: C
process->pass(): phpgwapi skipped on this pass
process->pass(): admin skipped on this pass
process->pass(): preferences skipped on this pass
process->pass(): etemplate skipped on this pass
process->pass(): #2 for upgrade processing
I am a little bit stuck…
Can someone help me please ?
Thanks,
SP
