How to backup and restore a MySQL (MariaDB) database in CentOs Linux

preview_player
Показать описание
For a free Linux cheat sheet click here:

This video shows how to backup a MySQL (MariaDB) database to a file and then shows how to restore the database from that file.
Рекомендации по теме
Комментарии
Автор

Thanks a lot loved this tutorial keep it up.

freeroyaltymusic-nocopyrig
Автор

is it imprortan in which directory we do backup and run commands?

daroboro
Автор

Hello!, i have a DB where i modified one table, and now i want to import the table with the modifications i made, how can i import this table instead of the old one?
Thanks a lot in advance!

abrahamdecode
Автор

I have a MariaDB with 10+ tables totalling in around 1TB, growing at around 500GB monthly, what is your advice on the appropriate backup method?

lucas_teo
Автор

For online backup consider using mariabackup, it's faster and better.

MO-hqiz