How to Backup and Restore MySQL/MariaDB database using mysqldump

[@georgiosdoumas2446]

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.

[@rempire380]

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!

[@tnoel57]

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

[@khajasujath4919]

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

[@collinharmon3207]

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

[@effeh7303]

meglio dei tecnici di servereasy, grande!

[@lukmangani8911]

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

[@riteshsaha6881]

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

[@swevos7632]

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

[@baniputri96]

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!

[@Suraj-vz4jc]

sales_order_table
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [22018] [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.3.32-MariaDB-1:10.3.32+maria~stretch-log].
I have getting this error please help me

[@TheIyerganapas]

Will it create user in destination DB SERVER

[@alktab8993]

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

[@rahulmouryaofficial6615]

Can you help me for mariadb dump using azure

[@python123]

Clear and well explained

[@azadehhassanian4940]

Thank you; It was perfect.

[@murwaneisa2287]

thnaks this help me a lot

[@bash6442]

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

[@pelemate]

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

[@muhsin98]

thank you Mr.Yusuf

[@philipbrindle867]

great video, thanks so much for sharing...

[@deividalmeida7393]

Amazing job! Thank you so much

[@johnyoucantseena7484]

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.

[@dwaynewade343434]

I keep getting zsh: command not found: mysqldump

[@ahmadzia8557]

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

[@sankar2805]

Yusuf, can you help me with how to take entire mysql server backup in linux?

[@robertferguson4366]

very good video!!! Thanks

[@JavaAidTutorials]

Nice video..

[@nedoyk]

how use the comand using the password?

[@GSoftagon]

Easy. substitute your own password: mysqldump -uroot -pmypassword mydb1 > mybackup.sql
The above statement won't ask for your password.

[@smurffronda2951]

Thank you

[@pratik6501]

thanks a lot

[@maishamolepo2216]

awesome!

[@yashwanturade3488]

Thanks

[@Earlam]

Thx.

[@dontknowwhattotypelo]

super!

[@villastube]

This is not for production.

[@rahulmouryaofficial6615]

Hi

[@Clearlylakecounty121]

Wow