Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

837 questions
0
votes
1 answer

MySQL Connecting with Blank User Name & Password

I'm having serious trouble for the last few days, please have empathy with my question. After a series of server crashes and hackings, today I've found out that my mysql can be connected via a web interface without a username and password. Is this…
ibyte
  • 83
  • 6
0
votes
1 answer

MariaDB failed at step namespace spawning /bin/sh: read-only file system

Recently my MariaDB stopped working and when I tried to start it, it always throws an error. The error message is: MariaDB failed at step namespace spawning /bin/sh: read-only file system What does that mean? The operating system is CentOS 7
andre
  • 3
  • 2
0
votes
1 answer

NginX and Galera Cluster are friends?

So I've found NginX's official tutorial, how to use NginX Plus as the proxy for the MariaDB Cluster. However, if I do this with my standard NginX (not the Plus edition) I constantly get the error nginx: [emerg] invalid URL prefix in…
Bert
  • 1,028
  • 1
  • 16
  • 33
0
votes
0 answers

MariaDB install failling on Debian 10 based VM

Trying to simply install MariaDB server on Azure Debian 10 VM host However it fails during the process I had tried few different ways but it seems to get stuck somewhere in the half way The last i tried was using this link…
antoniogbn
  • 13
  • 3
0
votes
1 answer

MariaDB 10.4.13 on Fedora 31

Learning MariaDB on Fedora 31. Installed successfully, able to connect; however, cannot seem to get the error log global variables to register. Steps taken: Created maria.log file in /var/log/ Added [mysqlid] log-error = /var/log/maria.log to…
Ami
  • 1
  • 1
0
votes
1 answer

On CentOS7: Uninstalling mariadb-server also uninstalls php-mysql package

On CentOS7: I need to upgrade MariaDB from 5.5 to 10.4 I followed this guide: https://itcloudnet.blogspot.com/2019/10/how-to-upgrade-mariadb-55-to-mariadb.html but instructions on other sites are similar. When I do yum remove mariadb-server…
Pavel Tankov
  • 376
  • 3
  • 16
0
votes
1 answer

How to import data into a MariaDB instance running in a Docker container?

I'm setting up a server to host a wordpress site and I have wordpress + mariadb + nginx all running in Docker very well. I can create and configure a new site in Wordpress and its all successful. I'd like to import some pre-existing site data into…
Tim Long
  • 1,738
  • 1
  • 21
  • 41
0
votes
1 answer

Can't start mysql on ubuntu 16.04

A query which was killed was still running. So I stopped the server and tried to start it back up. But now it refuses to start up. Here is the error: Job for mysql.service failed because the control process exited with error code. See "systemctl…
spheroid
  • 1
0
votes
1 answer

MariaDB mysql_upgrade 10.3.22 to 10.4.13 fails with error "Specified key was too long"

I'm on Debian Buster and an already seemingly functioning MariaDB 10.4.13 after upgrading from 10.3.22. However, the recommended mysql_upgrade script fails with the following error: [..] Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1071…
Chaeska
  • 51
  • 5
0
votes
1 answer

product import is broke behind cloudflare

Im having trouble to resolve my database errors and how to optimize it. Coz of the slowness of my server (mostly querries i believe), my imports turns with a cloudflare error code. (Cloudflare blocks connections over 15 secs as i remember) Need…
execash
  • 3
  • 2
0
votes
1 answer

MariaDB service doesn't start

I tried to restart it but still doesn't. I've been seeing some post but don't is the same problem. The server is CentOS Linux release 7.5.1804 (Core) The output o systemctl status mariadb is: ● mariadb.service - MariaDB database server Loaded:…
enmanuelmag
  • 1
0
votes
1 answer

Is mysql_install_db needed to install MariaDB?

I'm learning to run my own VPS and I tried install whole stack few times already. But I found one thing that is not same in the all tutorials: mysql_install_db command. I'm using Ubuntu LTS and it was always like this: apt install…
dodaner
  • 1
0
votes
3 answers

Transfer a bigger MySQL/MariaDB DB fast, save and restartable

I have to transfer a Drupal site with a 43GB MariaDB DB via ssh/scp to another server. I have a limited downtime window early in the morning. In the past I transferred smaller DB's (<3GB) directly via pipes like this: ssh -l webuser 10.0.0.99 "cd…
Matthias
  • 179
  • 1
  • 7
0
votes
2 answers

MySQL - alter table column vs mysqldump + load data infile

I have a large table (~250 Gb) and I want to change the column of the primary key from INT to BIGINT. Assuming that the server instance has sufficient resources to configure MySQL in an optimal way for both methods, which method is going to run in…
wowpatrick
  • 101
  • 4
0
votes
1 answer

Exported MariaDB dump different size

I'm trying to copy a database from a MariaDB server on another. I made a dump of the database on server A with : sudo mysqldump -u root -p --databases database1 > /var/tmp/database1.sql I created the new database on server B with : create database…
Ror
  • 321
  • 3
  • 16
1 2 3
…
55 56