Giter Club home page Giter Club logo

Comments (13)

jc21 avatar jc21 commented on June 16, 2024 4

I've just added another tag:

jc21/mariadb-aria:10.4.15-innodb

for those who still need innodb enabled.

from docker-mariadb-aria.

jc21 avatar jc21 commented on June 16, 2024 3

Ah right 10.4 had innodb enabled and this one doesn't.

To get around this, you can create a my.cnf file in the same place as your docker-compose.yml file with this:

[mysqld]
default-storage-engine=Aria
default-tmp-storage-engine=Aria
symbolic-links=0
log-output=file
skip-host-cache
skip-name-resolve

and mount it in docker-compose.yml

    image: jc21/mariadb-aria:10.4.15
    volumes:
      - ./my.cnf:/etc/mysql/my.cnf

See if that works?

from docker-mariadb-aria.

jc21 avatar jc21 commented on June 16, 2024 1

Umm you can do a mysqldump in the current database, bring up a new database with latest and the reimport the sql. However the sql will have some crap about the table type including innodb stuff, that needs to be stripped out of the file first.

In the case of NPM I'm looking into an option to convert the mysql database to the sqlite one, so you don't have to rely on any future mysql problems.

from docker-mariadb-aria.

jc21 avatar jc21 commented on June 16, 2024 1

Yeah I'm still not sure why the 10.4 tag was deleted. I know dockerhub cleans up images but if they were still being pulled it shouldn't have been killed.

from docker-mariadb-aria.

andrewhaji avatar andrewhaji commented on June 16, 2024

Just wanted to chime in and say that I'm having the exact same issue. Ran a docker-compose pull; docker-compose up -d today and got the error that the 10.4 tag is no longer available. Tried to switch to latest and it broke NPM. Any ideas? Many thanks.

from docker-mariadb-aria.

jc21 avatar jc21 commented on June 16, 2024

You can use the 10.4.15 tag instead it won't break NPM.

Just tested it myself.

from docker-mariadb-aria.

andrewhaji avatar andrewhaji commented on June 16, 2024

Thanks, but I just tried that and now get this error from the app:

app_1  | [8/18/2021] [10:52:26 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'

from docker-mariadb-aria.

andrewhaji avatar andrewhaji commented on June 16, 2024

Thank you - that works perfectly! Much appreciated.

(Is there any way of converting our existing databases so that we can use the latest tag without having to manually enable InnoDB? Or would we have to start from scratch?)

from docker-mariadb-aria.

TWhidden avatar TWhidden commented on June 16, 2024

This one got me too. Might want to have a notice up that :latest will break existing nginx-proxy-manager deployments if they update an existing system. Or, create a different tag for the new version, that doesn't break existing nginx proxy manager sites and push a :latest tag that reverses this. The latter prob creates less havoc; Wish I caught this thread a couple hours ago. Glad its an easy work around though. Thanks.

from docker-mariadb-aria.

TWhidden avatar TWhidden commented on June 16, 2024

there is a jc21/mariadb-aria:10.4.15 , but it has

[mysqld]
skip-innodb
default-storage-engine=Aria
default-tmp-storage-engine=Aria
innodb=OFF
symbolic-links=0
log-output=file
skip-host-cache
skip-name-resolve

from docker-mariadb-aria.

andrewhaji avatar andrewhaji commented on June 16, 2024

Thank you!

from docker-mariadb-aria.

lug-gh avatar lug-gh commented on June 16, 2024

I've just added another tag:

jc21/mariadb-aria:10.4.15-innodb

for those who still need innodb enabled.

Will that innodb tag stay for the future?

from docker-mariadb-aria.

jc21 avatar jc21 commented on June 16, 2024

Yep certainly will

from docker-mariadb-aria.

Related Issues (9)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.