Changes

Changes

716 bytes added , 6 April

→‎Manual migration of mysql 5.7, mariadb 10.1 10.2 10.3 and 10.5

Line 2: Line 2:

__TOC__

−

== ~~manual~~ migration of mysql 5.7, mariadb 10.1 10.2 10.3 and 10.5 ==

== server-manager is replaced by smanager ==

The good old server-manager while still present for beta/RC stage has been replaced by a new manager access to the new manager is at:

https://myip/smanager

We know that a few things are broken in the old manager, and they will remain as won't fix. It was left in the build so that we did not loose any existing function during the migration.

For final release we plan to redirect the old url to the new manager

== Minimal php is 7.2 ==

You need to be sure all your software is compatible with this version of php at very least. However as this version now deprecated, please test/upgrade your software or migrate to something compatible with a supported branch of php8.x

== Manual migration of mysql 5.7, mariadb 10.1 10.2 10.3 and 10.5 ==

Those version of the mariadb and mysql server were available as a contrib offering an extra server on the same machine.

Line 12: Line 24:

* /home/e-smith/db/mariadb101

−

You will have to manually restore those dump to your new mariadb 11.4 in SME11. ~~Pay attention first~~ to not erase a newer copy of those first.

You will have to manually restore those dump to your new mariadb 11.4 in SME11. Be sure to not erase a newer copy of those first.

−

To check what is currently in your new DB (if you need to se more of the content, either read for specific SQL syntax or install phpmyadmin:<syntaxhighlight lang="bash">

To check what is currently in your new DB (if you need to see more of the content, either read for specific SQL syntax or install phpmyadmin:<syntaxhighlight lang="bash">

# mariadb-show

+--------------------+

Line 34: Line 46:

-rw-r--r-- 1 root root 961623685 6 avr 06:40 nextcloud.dump

−

</syntaxhighlight>to restore the wanted dump<syntaxhighlight lang="bash">

</syntaxhighlight>to restore the wanted dump:<syntaxhighlight lang="bash">

mariadb < /home/e-smith/db/mariadb105/nextcloud.dump

</syntaxhighlight>you might also want to check inside mysql.privileges.dump to restore selective user for this db <syntaxhighlight lang="bash">

Line 46: Line 58:

== ERROR 1071 (42000) at line 33: Specified key was too long; max key length is 1000 bytes ==

−

~~Newer~~ version of mariadb do not allow MyISAM key larger than 1000 bytes. If you are unable to restore a dump ~~with sycn~~ an error, a workaround is to convert this to either Innodb or Aria.

The newer version of mariadb does not allow MyISAM key larger than 1000 bytes. If you are unable to restore a dump without an error, a workaround is to convert this to either Innodb or Aria.

Open the dump and search for the line similar to that for your table causing issue :<syntaxhighlight lang="sql">

Line 70: Line 82:

</syntaxhighlight>and change ENGINE=MyISAM to ENGINE=Aria, or any Engine you want.

−

if you want to convert the whole MyIsam tables to Aria (probably you want to only do for some, and this is not the wise way to do it ), here is a ~~oneliner~~:<syntaxhighlight lang="bash">

if you want to convert the whole MyIsam tables to Aria (probably you want to only do for some, and this is not the wise way to do it ), here is a one-liner:<syntaxhighlight lang="bash">

sed -i -e 's/ENGINE=MyISAM/ENGINE=Aria/' /home/e-smith/db/mysql/CHANGEME.dump

</syntaxhighlight>

Line 82: Line 94:

You now have a panel to handle you NUT UPS.

−

Also behaviour of the services ~~have change~~ completly, see the new documentation [[Uninterruptable Power Supply]]

Also behaviour of the services has changed completly, see the new documentation [[Uninterruptable Power Supply]]

__TOC__

Brianr

Administrators (Semantic MediaWiki), Administrators

795

edits