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
  • breeze0's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 months 1 week ago - 11 months 1 week 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: 11 months 1 week ago by breeze0.

Please Log in to join the conversation.

  • breeze0
  • breeze0's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 months 1 week 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
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 months 1 week 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 service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

More
11 months 13 hours 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
11 months 13 hours 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
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 months 12 hours 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 service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 months 2 hours 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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 4 weeks 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 service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 4 weeks 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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

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

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 3 weeks 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/
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 months 3 weeks 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 manual.limesurvey.org/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 service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source