Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Upgrading MySQL from 5.7 to 8.x

breeze0
Topic Author
Offline
New Member

More

1 year 9 months ago - 1 year 9 months ago #243283 by breeze0

Upgrading MySQL from 5.7 to 8.x was created by breeze0

Please help us help you and fill where relevant:
Your LimeSurvey version: 6.x
Own server or LimeSurvey hosting: Own
Survey theme/template:
==================
Is there any potential issue or recommended way to move from MySQL 5.7 (EOL this year) to MySQL 8.x ?

Thanks

Last edit: 1 year 9 months ago by breeze0.

Please Log in to join the conversation.

breeze0
Topic Author
Offline
New Member

More

1 year 9 months ago #243287 by breeze0

Replied by breeze0 on topic Upgrading MySQL from 5.7 to 8.x

Update - exported database from the Limesurvey console and imported back into ver. 8 MySQL. No issues so far.

The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

1 year 9 months ago #243362 by DenisChenu

Replied by DenisChenu on topic Upgrading MySQL from 5.7 to 8.x

Great

Thank you

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

sperrony
Offline
New Member

More

1 year 8 months ago #243672 by sperrony

Replied by sperrony on topic Upgrading MySQL from 5.7 to 8.x

Hi.
Can you please help how to export the database from the old console (MySQL 5.7) and how to import it back in the MYSQL8 server? I did not find it in the console UI itself.

Please Log in to join the conversation.

sperrony
Offline
New Member

More

1 year 8 months ago #243673 by sperrony

Replied by sperrony on topic Upgrading MySQL from 5.7 to 8.x

need asssitance to understand how to do it, could not found the place in the console

Please Log in to join the conversation.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

1 year 8 months ago #243680 by DenisChenu

Replied by DenisChenu on topic Upgrading MySQL from 5.7 to 8.x

Not related to LimeSurvey

dev.mysql.com/doc/refman/8.0/en/mysqldump.html
dev.mysql.com/doc/refman/8.0/en/mysqlimport.html

for example

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

holch
Offline
LimeSurvey Community Team

More

1 year 8 months ago #243700 by holch

Replied by holch on topic Upgrading MySQL from 5.7 to 8.x

No idea about how to do with console, but with tools like PHPmyAdmin this is pretty easy to do in a couple of clicks.

Help us to help you!

Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).

Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

1 year 8 months ago #243707 by DenisChenu

Replied by DenisChenu on topic Upgrading MySQL from 5.7 to 8.x

holch wrote:
No idea about how to do with console, but with tools like PHPmyAdmin this is pretty easy to do in a couple of clicks.

Not with a lot of data

Easy way in console

Code:

#mysqldump -u LSuser -p limesurvey > limesurvey.sql
#mysql -u LSuser -p limesurvey < limesurvey.sql

You have to write password of LSuser

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

holch
Offline
LimeSurvey Community Team

More

1 year 8 months ago #243720 by holch

Replied by holch on topic Upgrading MySQL from 5.7 to 8.x

Not with a lot of data

That might be the case, but the amount of data was not mentioned. So I thought I might just given an alternative.

Help us to help you!

Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).

Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

sperrony
Offline
New Member

More

1 year 8 months ago - 1 year 8 months ago #243819 by sperrony

Replied by sperrony on topic Upgrading MySQL from 5.7 to 8.x

Any chance to get help ? willing to pay for help, need to fix that.

Last edit: 1 year 8 months ago by holch. Reason: Excluded email address.

Please Log in to join the conversation.

holch
Offline
LimeSurvey Community Team

More

1 year 8 months ago #243824 by holch

Replied by holch on topic Upgrading MySQL from 5.7 to 8.x

For commercial support of the community edition you can get in touch with one of the official Limesurvey partners over here:

www.limesurvey.com/

The user DenisChenu who also posted here is one of these official partners that you can find on this website and you can get in touch here:
www.sondages.pro/

Help us to help you!

Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).

Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

1 year 8 months ago #243855 by DenisChenu

Replied by DenisChenu on topic Upgrading MySQL from 5.7 to 8.x

sperrony wrote:
Any chance to get help ? willing to pay for help, need to fix that.

The screenshot you send to me seems clearly a issue on LimeSurvey then
You must report on the Bug Tracker community.limesurvey.org/bug-tracker/
And if you can activate debug mode to report the issue www.limesurvey.org/manual/Debug_mode

Other partners can help : www.limesurvey.com/installation

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans

Get started

Welcome to the LimeSurvey Community Forum

Upgrading MySQL from 5.7 to 8.x

Lime-years ahead

Legal

About Us

Open Source