Back to limesurvey.org

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

More
2 years 3 months ago - 2 years 3 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: 2 years 3 months ago by breeze0.

Please Log in to join the conversation.

More
2 years 3 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.

More
2 years 3 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.

More
2 years 3 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.

More
2 years 3 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.

More
2 years 3 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.

More
2 years 3 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.

More
2 years 3 months ago #243707 by DenisChenu
Replied by DenisChenu 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.
 
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.

More
2 years 3 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.

More
2 years 3 months ago - 2 years 3 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: 2 years 3 months ago by holch. Reason: Excluded email address.

Please Log in to join the conversation.

More
2 years 3 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.

More
2 years 3 months ago #243855 by DenisChenu
Replied by DenisChenu on topic Upgrading MySQL from 5.7 to 8.x

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

Legal

About Us

Open Source