MariaDB 10

Questions about hosting a Website, using MySQL, PhP or MariaDB may be posted here.
Forum rules
1) This is a user forum for Synology users to share experience/help out each other: if you need direct assistance from the Synology technical support team, please use the following form:
https://account.synology.com/support/suppo ... p?lang=enu
2) To avoid putting users' DiskStation at risk, please don't paste links to any patches provided by our Support team as we will systematically remove them. Our Support team will provide the correct patch for your DiskStation model.
Akirainblack
I'm New!
I'm New!
Posts: 5
Joined: Mon Feb 02, 2015 4:03 pm

Re: MariaDB 10

Postby Akirainblack » Thu Jul 27, 2017 3:42 pm

wags1 wrote:Glad it finally forked for you. One question, had you upgraded PHPMyAdmin to the latest release before you did the export/import?

Yes, I'd updated it to the latest version.
wags1
Trainee
Trainee
Posts: 15
Joined: Tue Sep 10, 2013 6:43 pm

Re: MariaDB 10

Postby wags1 » Thu Jul 27, 2017 5:52 pm

That was my last idea as to why it didn't just work for you... :D
Oh well, at least you found a way to get it to work.
Yearofthegoat
Beginner
Beginner
Posts: 25
Joined: Mon Jul 04, 2016 4:55 pm

Re: MariaDB 10

Postby Yearofthegoat » Thu Sep 14, 2017 10:18 am

wags1 wrote:For Kodi Users -

If you are using MariaDB 5.5 for your Kodi database and are trying to figure out how to migrate your database to MariaDB 10 here is what I did to get it migrated and working. There are, I'm sure, easier and quicker ways to do this but this is what worked for me. I hope it helps someone.

1 - Using the Synology package center install MariaDB 10 and then upgrade PHPMyAdmin.
2 - Using PHPMyAdmin login to MariaDB 5.5 (if both 10 and 5.5 are running you should have a selection box at the bottom of the PHPMyAdmin login screen).
3 - On the home screen click on Export, accept the defaults and click on Go. This will export your existing databases to your browsers download folder.
4 - Click on the logoff icon.
5 - Using PHPMyAdmin login to MariaDB 10. Note - the default login is root with no password. After your first login you should change it for security.
6 - If your Kodi databases were using a userid and password complete the following step, if not skip it - Click on User Accounts and create an account with the exact same username, password, and privileges as your were using with MariaDB5.5.
7 - Click on Import and point to the file you exported in step 3 and accept the defaults. Once the import competes you should see your Kodi databases in the left pane.
8 - If you created a username and password in step 6 click on Databases and then click on Privileges next to each of your Kodi databases to ensure that the user that you created is there and has the correct privileges.
9 - Click on the logoff icon.
10 - Using the Synology Package Center stop MariaDB 5.5.
11 - For each of your Kodi systems you will need to edit your advancedsettings xml file and change the port setting from 3306 to 3307.
12 - Run each of your Kodi systems to test and ensure they are working correctly.
13 - If everything is working you can uninstall MariaDB 5.5 and delete the databases associated with that server.

That's it, at that point you should be good to go.


Fantastic - worked fine for me, using Kodi Jarvis 16.1 at present.

In step 7 I unticked the 'interrupt...if near timeout' option, but all went well.

If this isn't in the Kodi Wiki, it should be!

Thanks again.
DS212J, DS916+
Joffer
I'm New!
I'm New!
Posts: 2
Joined: Thu Dec 20, 2012 1:35 am

Re: MariaDB 10

Postby Joffer » Tue Sep 19, 2017 1:48 pm

If you want to run MariaDB10 on 3306, put the following into /var/packages/MariaDB10/etc/my.cnf :

Code: Select all

[client]
port = 3306

[mysqld]
port = 3306


Then (re)start MariaDB10. MariaDB5 should be uninstalled, as it will create a collision on port 3306 if you start MariaDB5
Ltek
Enlightened
Enlightened
Posts: 423
Joined: Sat Dec 10, 2011 9:21 pm

Re: MariaDB 10

Postby Ltek » Fri Oct 20, 2017 5:51 am

Is there a major performance benefit to running Kodi's DB on 10 vs 5.5?
User avatar
Freeco
Experienced
Experienced
Posts: 112
Joined: Wed Dec 24, 2008 12:11 pm
Location: Belgium
Contact:

Re: MariaDB 10

Postby Freeco » Fri Oct 20, 2017 2:28 pm

Ltek wrote:Is there a major performance benefit to running Kodi's DB on 10 vs 5.5?

Not that I've noticed...
Is your Kodi slow with v5.5?

Model: DS414 (1.33GHz dualcore - 1GB RAM)
Firmware: DSM 6.1
RAID1: 3 x WD Red 4TB (WD40EFRX)
Network: Netgear GS724T-300
Backup: Sharkoon SATA QuickDeck Pro USB3 + Seagate Barracuda 7200.14 3TB (ST3000DM001)

Sold: DS212 & DS209+
Ltek
Enlightened
Enlightened
Posts: 423
Joined: Sat Dec 10, 2011 9:21 pm

Re: MariaDB 10

Postby Ltek » Fri Oct 20, 2017 4:57 pm

Is there a major performance benefit to running Kodi's DB on 10 vs 5.5?
romu
Novice
Novice
Posts: 56
Joined: Wed Nov 26, 2014 10:12 am

Re: MariaDB 10

Postby romu » Mon Dec 04, 2017 9:57 pm

Hello,
I'm in the upgrade process to convert my DBs from MariaDB 5.5 to 10. I'm facing a strange issue.

If I run this command:

Code: Select all

mysql --user=root -p


I get:

Code: Select all

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)


I've to run this to make it work:

Code: Select all

mysql --user=root --socket=/run/mysqld/mysqld10.sock -p


Currently, because of this strange problem, I can't get software "MariaDB client" to work. Any idea? Thanks.

Return to “Web Server + PHP / MySQL + MariaDB”

Who is online

Users browsing this forum: No registered users and 3 guests