MySQL Tutorial - 40 - BACKUP & RESTORE MySQL Database

[@Compsciyesi]

Thank you for posting this! I've been looking everywhere for an example that show beginning to end running as an administrator and command line client and this was the only one I could find. Showing the change to the bin file was a life saver as well.

[@WebDevPro-Tutorials]

You're very welcome!

[@GuzmanE92]

Hi! I wanted to thank you for such an easy to follow video. You helped me complete one of my college assignments that I was having trouble with. I want to say thanks for taking the time to make these videos, you help a lot of students, and aspiring IT professionals understand the steps needed to complete an assignment. Thank you once again. Thumbs up.

[@WebDevPro-Tutorials]

Great job!

[@antoniofuller2331]

LMAO

[@taher786...]

I was reading an article about this, which made me scratch my head all along, wish i'd saw your video first ❤

[@WebDevPro-Tutorials]

Glad it was helpful!

[@margaretdarden8366]

Great video because got right to the point. I wanted to if any video on how to correct the error 1932 or is that an advanced topic & something not discussed on your channel..

[@scottdowney4318]

Great job here. I tested on 8.0.36 server restoring a dump from a 5.7 server, and it worked fine. I also run win11, and one of the machines has 2 instances, mysql5.7 at port 3306 and mysql 8.0.36 at port 3307. to connect you need to specify port as in mysql - u root -p --port=3307; etc.... or it gives me mysql 5.7 server.

[@GarethLategan]

Thanks so much! Loved you energy and your accent!

[@WebDevPro-Tutorials]

You are so welcome

[@yadayada5186]

Hi! Thankyou for the video~~ But i want to ask, is this method considered as cold or hot backup?

[@ritikshrivastava9442]

thank you bhai just curious to know where this kind of accent of english do people speak

[@ankandutta6022]

Thank you so much for your tutorial. Without it, I would be left wondering hours for the solution.

[@WebDevPro-Tutorials]

You're welcome!

[@machine804]

Great video mate! You were a great help. I genuinely couldnt do it without using the administrator application, which didnt work on my pc for some reason. :)

[@WebDevPro-Tutorials]

You're welcome!

[@jeffersonsantiago7902]

Hi, may I ask if I can restore the dump file from 5.6 to 8.0 series?

[@p.c62]

Bhai tune bacha liya🙏🙏..mashiha he tu mashiha

[@pksinformer7012]

Very helpful content

[@WebDevPro-Tutorials]

Glad it was helpful!

[@vanteview]

Can i use this to access the database on another computer?

[@RDEllis28]

This is not working for me. I keep getting "The system cannot find the path specified." notification. I'm not sure what else to do.

[@arshdeepkaur8913]

easiest tutorial, thank you so much

[@WebDevPro-Tutorials]

Glad it helped!

[@mandy1339]

I just tried using mysqldump and it worked great for the tables and the data but it did NOT copy the procedures. BeWare.

[@mandy1339]

OK I just researched this and learned that you need to add the --routines flag to the command so that it exports the stored procedures as well as the data.

[@audreywarren6777]

See, my problem is I don't even know where to start typing on. Why can't you start this from the VERY beginning? I'm so confused!

[@danilovalle3263]

Thanks for sharing

[@WebDevPro-Tutorials]

Thanks for watching!

[@Andrew-jx7iu]

Было бы здорово увидеть так же другие виды диферентиал и тд

[@WebDevPro-Tutorials]

How do you mean "diferential" ?

[@eagleslandin1692]

This accent is definitely eastern European....it's either: 1) Bulgarian 2) Serbian/Croatian/Bosnian 3) Russian? (Not too likely) or 4) Macedonian?

[@luistorrez7807]

Muchas gracias.

[@WebDevPro-Tutorials]

Thank you.

[@ManuelsNoTalkCodeVideos]

Can you restore that database in other MySQL version on other computer ?

[@WebDevPro-Tutorials]

Dump is just a dump, if it's not working there's always way around.

[@praveenkumarc6371]

bro I wanna say something in tamil language "Thailai va ur Great !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"

[@RarelyMediocre]

Pozdrav, zvucis kao nas lik? Sve u svemu, odlican tutorijal! :) Sve najbolje...

[@WebDevPro-Tutorials]

Hvala :)

[@jayantghorpade]

Thank you very much 💖

[@WebDevPro-Tutorials]

You're welcome 😊

[@a.a.b.by.y.z.z956]

🐐🐐 Lifesaver

[@hematogen50g]

It does not work if you have dump file in different directory

[@Factstipsnmotivation]

Thankyou ..It is very clear

[@WebDevPro-Tutorials]

Glad it helped

[@luiscarlosmartinez3034]

THANK YOU!

[@WebDevPro-Tutorials]

Welcome!

[@rajasami2960]

In my case, Access denied comes instead Enter password..

[@entertainment0407]

Password error... How to solve

[@rudezexo7555]

6:41 knows 😂 ...

[@venusdille8179]

Tttoopp

[@antoniofuller2331]

Hello moto