Migration to a new database

Wed, 30 Nov 2022 21:24:06 +0100

adminsforum@hubzilla.org

roere wrote the following post Wed, 30 Nov 2022 21:24:06 +0100

Migration to a new database

Migration to a new database
I have an old Hubzilla installation, which I cannot get up and running long. After starting, the server crashes after a few minutes with overload and a crashed database.
Anyway, I have the database in Mysql8. Is there a way to export my old channels (on a Mysql level!) and import them to my new instance, that I am using right now?

Thu, 01 Dec 2022 12:19:21 +0100

roere

roere@zentrumderarbeit.net

Actually I found nothing in the logs. There are some php processes consuming more and more cpu until the server cracks, leaving me with a crashed items-table. I think I read something, that older hubzilla versions act like this, if the database is corrupted. So I decided to start clean.
As there are channel ex- and import options on web-level, I hoped to able to run the underlying scripts manually.

Thu, 01 Dec 2022 18:49:35 +0100

Grouchy

grouchy@hub.grouchysysadmin.com

You could try exporting the database, and importing it to a new database to see if that fixes the corruption. I assume you're using InnoDB?

Fri, 02 Dec 2022 09:26:01 +0100

roere

roere@zentrumderarbeit.net

Yes, InnoDB. I can try importing the whole DB, but I just would need the Channels.