Press J to jump to the feed. Press question mark to learn the rest of the keyboard shortcuts

Found the internet!

Create an account to follow your favorite communities and start taking part in conversations.

MariaDB

r/mariadb

Hot New Top Rising

Hot New Top

Rising

2

Posted by3 days ago

MariaBackup Restore to Second 'test' database

I have a backup created with mariabackup...

I would like to restore a specific database, "DB1" into a new test database "DB2"

I can't seem to see an option for this on the maria docs, and --help... didn't.

I even asked ChatGPT lol, it mentioned an argument "--new-data-dir"

But this Arg isn't mentioned in the docs or --help.

How do I accomplish my goal without jacking up "DB1"s directory?

It isn't a prod box, but the data is valuable for testing, and I am unable to match the other variables in my personal lab...

2

7 comments

4

Posted by4 days ago

[Question] Activate Python script after new entry

Hello,

I have been trying to set up a Trigger that activates a python script when a new entry into my table is created. This trigger tries to get a piece of data from the new entry and uses that in the Python script, but I get the following error: "mysql.connector.errors.NotSupportedError: 1415 (0A000): Not allowed to return a result set from a trigger"

I just can't seem to get around this error and was wondering if someone here could give my advice on how to do this. Is what I'm trying even possible?

The following is the code for my stored procedure and trigger:

``

DELIMITER $$

CREATE PROCEDURE run_nmap(IN ip_address VARCHAR(15))

BEGIN

4

1 comment

1

Posted by4 days ago

Can OQGraph's Backing Table be Spider?

Hello, I am new to MariaDB and was looking into OQGraph, The documentation says:

To create an OQGRAPH v3 table, a backing table must first be created. This backing table will store the actual data, and will be used for all INSERTs, UPDATEs and so on. It must be a regular table, not a view.

Can this backing table be a table using the Spider storage engine?

1

0 comments

5

Posted by5 days ago

I'll just leave this here (👏 to whoever made this)

5

0 comments

0

Posted by8 days ago

unable to login to Mariadb

unable to login to Mysql

R 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ ~]#
[root@~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@ ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ ~]# cat /etc/passwd
root:x:0:0:root:/root:/bin/bash

can anyone assist much thanks

0

2 comments

3

Posted by11 days ago

understand pro/cons haproxy vs proxysql loadbalancing galera

good morning,

i am studying mariadb and galera, and i see someone uses haproxy, other proxysql, and i would like to understand if there is a real design reason to choose one or another (beside they are not exacty the same thing, one is general tcp lb, other more specific understand sql, it is obvious :)

thank you very much

3

4 comments

1

Posted by12 days ago

mariabackup backup and prepare phase

Hi all,

For mariabackup physical backups, just seeking some clarity on whats standard practice.Say for example, I take a full backup and a few hourly incrementals.

Full backup  @/Midnight
Incr1 backup @/1AM
Incr2 backup @/1AM
Incr3 backup @/3AM

e.g.

$ mariabackup --backup --target-dir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr1/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr2/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr3/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw

So, then using the 'prepare' command, I chain these backups together, by preparing the Full and then each subsequent incremental in turn.

$ mariabackup --prepare    --target-dir=/dir1/fullbackup
$ mariabackup --prepare    --target-dir=/dir1/fullbackup    --incremental-dir=/dir1/incr1

1

1 comment

About Community

MariaDB Server is an open source relational database

Created Mar 17, 2013

1.9k

Members

2

Online

Moderators

Moderator list hidden. Learn More

User Agreement Privacy policy

Content policy Moderator Code of Conduct