Cobra Forum

Linux => General Help => Topic started by: mahesh on Oct 12, 2023, 02:56 AM

Title: How to take a backup in MariaDB on Ubuntu 20.04?
Post by: mahesh on Oct 12, 2023, 02:56 AM
Hello everyone,
I apologize if I'm in the wrong forum. I'm trying to take a backup of my SQL database which is on MariaDB but I'm at a loss. I've tried the commands I see on the internet but everytime I press enter I am presented with another line that looks like this

-->

These are the commands I run from a terminal

sudu su <-- To get SU

mysql -u root -p <-- I can only successfully run this command if I use sudo su (I am not logged on as root but as another administrator


mysqldump -u root -p <-- Logs into MariaDB

SHOW DATABASES; <-- Shows my databases

mysqldump -u root -p myDBName > /home/myusername/DB_backup.sql

When I press enter on the last line it just skips to the next line with a

-->

As if it's waiting for some kind of input. Am I doing something wrong?

Thanks