Showing posts with label MariaDb. Show all posts
Showing posts with label MariaDb. Show all posts

Wednesday, August 12, 2026

Review: HeidiSql vs DBeaver > Simple MariaDb database backup

I have about a gig worth of custom data in MariaDb in a docker container on a Linux server. I just wanted to do a simple backup of a database that I have been manually entering data for about 6 months now.

I first tried in DBeaver and I keep getting an error but cannot figure out why. 

1. Database > Tasks > Create new task...


2. MySQL dump




3. After executing the task, I get error.




I could not find more details on the error, so I just went to HeidiSql to perform a backup because I had successfully done so in the past. I thought maybe there was a data issue.


1. Right click on the server name

2. Export database as SQL

3. Click checkbox to select all databases

4. Output: Single .sql file

5. Filename: [location to put the file]

6. After a few minutes, it completed just under 1G of data.

Monday, March 14, 2022

Notes: MariaDb Sequence

1. Create a sequence

CREATE SEQUENCE [Name of Sequence]


2. Get next sequence id

nextval([Name of Sequence])



Reference

https://mariadb.com/kb/en/create-sequence/

Thursday, September 2, 2021

Notes: MariaDb setup




MariaDb Setup

/etc/mysql/maria.conf.d/50-server.cnf

comment out:

bind-address = 127.0.0.1



Check Configurations

On db server, open shell (mysql -u root -p)

Run query, SELECT User, Host FROM mysql.user



Google Cloud Setup


VPC Network
Firewall Rules

Direction: Ingress
Source Filters: IP Address of device accessing db server
Applicable to instances: permission to users