How to Backup and Restore a MySQL/MariaDB Database

Learn how to back up and restore a MySQL/MariaDB database from the command line, step by step.

In this video, you'll learn how to back up and restore a MySQL database on the Linux command line, and how to schedule backups to run automatically, using a cronjob.

[HallucinVIII]

Thank you for your great videos.
Every time I see the term drop tables all I can think of is little Bobby Tables from xkcd.
I imagine that I'm not the only one.

[acidrazor]

I would love more tutorials for production/real world scenarios for n00b DBAs or someone setting out to build their own cluster etc.

[runnerwannabe]

Thanks for you videos.
But in this instance I disagree with this approach (i.e. the use of mysqldump), I would like to propose the use of Percona's Xtrabckup or the tool Mylvmbackup.
These should be the de facto standard, tools for MySQL backups backups and restoring.
Sure for your example, the a small database and my proposal is overkill, but if one of viewers is on the road to managing larger databases, least they can hit the ground running or learning and doing proper DBA tools / methodologies.
HTH

[xavierl]

Great guide, and excuse me if this has been mentioned before but how about a guide on tuning mysql. Oh and tuning mysql to run along side apache.

[jordannash]

Hi I'm stuck at 6:47 and get a permission denied statement when I execute the mysqldump. I'm doing this on Ubuntu 18.04.2 LTS. Anybody run into the same problem whilst following all the steps? Were you able to solve it?

[rogernevez]

This method is also very fast for large databases (10Mi rows)?

[ko]

how do you keep database and web app files in sync? dump the sql to a version controlled git folder?

[uchitesting]

What about crontab -e
Didn't have to deal with that for a while but if I'm correct this is how crontab should be edited.
Anyway thanks for the video. It showed very useful. I'm working in a project where many people are involved and shit happened so here I am to quickly know how to backup my stuff.

[Dipesh]

How to migrate mysql user, host and password from old to new server?

[Linuxbabeofficial]

--add-drop-table is on by default. You don't need to type it :)

[JohnSmith-zlrz]

why not just this? mysqldump -u username -p database_name > source_dump.sql why the --add-drop-table, I think by default drop table is add it.