How to Backup and Restore MySQL/MariaDB database using mysqldump

In this video we will learn to create backup and restore MySQL and MariaDB database using mysqldump.

Subscribe my YouTube channel:

Support me:

Find me on:

Music:
Kona Sun - YouTube Audio Library

[georgiosdoumas]

Clear English accent/pronunciation, and smooth voice, and also good choice of helper commands (e.g. the fact that you get inside the DB and type the show and the select commands to display things). Good video. What surprised me is that for the restore phase, you first had to get into mysql> and create the Database, and only then you were able to do the bash command for restore. I thought that in the mydb1_withdata_dump.sql file, even the required commands to create the Database mydb1 would be present.

[effeh]

meglio dei tecnici di servereasy, grande!

[rempire]

Just what I needed tanks a lot, now I can make my WP code local, dump it, and upload the db on the server afterwards, great resource!

[tnoel]

Yusuf, This is EXACTLY what I needed. Thank you so much for a very informative video!!!

[lukmangani]

I very happy to have watched this video, it was very helpful, thank you.

[riteshsaha]

Thank you very much, mate. I needed this for my job.

[collinharmon]

Wow thanks so much! Did exactly what I needed to do. I love the guitar in the background. Very nice video :D

[khajasujath]

Thank you shakeel bhai, this video is very clear and helpful....👌👌👌

[swevos]

You are incredible, i really thank you, you are the best my brotha

[baniputri]

Great Video of you! Can you make a step by step Video of how to :
1. Dumb a database
2. Compress it
3. Copy to the Cloud (AWS/Alibaba/GCP) and
4. Restore it.

It will be nice if you can share more of your knowledge in the database with us! Thank you, Yusuf!

[alktab]

hi Yusuf you this video us system MAC OS What commands for win 7 - 8 - 10 - 11 ... thank

[pelemate]

me sirvio gracias, is usefull for me thanks a lot lord.

[philipbrindle]

great video, thanks so much for sharing...

[TheIyerganapas]

Will it create user in destination DB SERVER

[rahulmouryaofficial]

Can you help me for mariadb dump using azure

[johnyoucantseena]

Hi Yusuf, thank you soo much for the tutorial, it helped me with my job :D. One thing i want to ask you if you have time is Does the backup database disappear after you restore the database with **mysql -u user -p dbName < dumpFile.sql** ? I just asked because mine did for some reason.

[dwaynewade]

I keep getting zsh: command not found: mysqldump

[bash]

how to dump sql database without overwriting the existing db? thanks in advance!

[ahmadzia]

i am using MariaDB and i have tried the back up statement, it keeps rejecting.. do you know why?

[Suraj-vzjc]

sales_order_table
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [22018] [MySQL][ODBC 8.0(a)
I have getting this error please help me