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.

[@tnoel57]

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

[@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!

[@collinharmon3207]

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

[@khajasujath4919]

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

[@riteshsaha6881]

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

[@lukmangani8911]

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

[@effeh7303]

meglio dei tecnici di servereasy, grande!

[@swevos7632]

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

[@python123]

Clear and well explained

[@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!

[@azadehhassanian4940]

Thank you; It was perfect.

[@muhsin98]

thank you Mr.Yusuf

[@murwaneisa2287]

thnaks this help me a lot

[@deividalmeida7393]

Amazing job! Thank you so much

[@pelemate]

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

[@robertferguson4366]

very good video!!! Thanks

[@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.

[@philipbrindle867]

great video, thanks so much for sharing...

[@smurffronda2951]

Thank you

[@pratik6501]

thanks a lot

[@JavaAidTutorials]

Nice video..

[@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

[@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

[@maishamolepo2216]

awesome!

[@TheIyerganapas]

Will it create user in destination DB SERVER

[@yashwanturade3488]

Thanks

[@Earlam]

Thx.

[@dontknowwhattotypelo]

super!

[@ahmadzia8557]

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

[@bash6442]

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

[@Clearlylakecounty121]

Wow

[@sankar2805]

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

[@dwaynewade343434]

I keep getting zsh: command not found: mysqldump

[@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.

[@rahulmouryaofficial6615]

Hi

[@villastube]

This is not for production.