MySQL Tutorial - 40 - BACKUP & RESTORE MySQL Database

Поділитися
Вставка
  • Опубліковано 18 жов 2024

КОМЕНТАРІ • 53

  • @Compsciyesi
    @Compsciyesi 4 місяці тому +1

    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.

  • @GuzmanE92
    @GuzmanE92 3 роки тому +8

    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.

  • @taher786...
    @taher786... 10 місяців тому +1

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

  • @margaretdarden8366
    @margaretdarden8366 2 роки тому +3

    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
    @scottdowney4318 7 місяців тому +1

    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
    @GarethLategan 3 роки тому +2

    Thanks so much! Loved you energy and your accent!

  • @machine804
    @machine804 2 роки тому +1

    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. :)

  • @yadayada5186
    @yadayada5186 Рік тому

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

  • @jeffersonsantiago7902
    @jeffersonsantiago7902 4 місяці тому

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

  • @ritikshrivastava9442
    @ritikshrivastava9442 2 роки тому +1

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

  • @ankandutta6022
    @ankandutta6022 Рік тому +1

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

  • @vanteview
    @vanteview 3 роки тому +1

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

  • @a.a.b.by.y.z.z956
    @a.a.b.by.y.z.z956 6 місяців тому +1

    🐐🐐 Lifesaver

  • @Andrew-jx7iu
    @Andrew-jx7iu 3 роки тому +1

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

  • @RDEllis28
    @RDEllis28 8 місяців тому

    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.

  • @ManuelsNoTalkCodeVideos
    @ManuelsNoTalkCodeVideos 4 роки тому +1

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

    • @WebDevPro-Tutorials
      @WebDevPro-Tutorials  4 роки тому +1

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

  • @luistorrez7807
    @luistorrez7807 Рік тому +1

    Muchas gracias.

  • @arshdeepkaur8913
    @arshdeepkaur8913 Рік тому +1

    easiest tutorial, thank you so much

  • @p.c62
    @p.c62 2 роки тому

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

  • @RarelyMediocre
    @RarelyMediocre 2 роки тому +1

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

  • @audreywarren6777
    @audreywarren6777 2 роки тому

    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!

  • @pksinformer7012
    @pksinformer7012 2 роки тому +1

    Very helpful content

  • @danilovalle3263
    @danilovalle3263 3 роки тому +1

    Thanks for sharing

  • @mandy1339
    @mandy1339 2 роки тому +1

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

    • @mandy1339
      @mandy1339 2 роки тому +1

      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.

  • @jayantghorpade
    @jayantghorpade Рік тому +1

    Thank you very much 💖

  • @praveenkumarc6371
    @praveenkumarc6371 2 місяці тому

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

  • @hematogen50g
    @hematogen50g 2 роки тому

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

  • @luiscarlosmartinez3034
    @luiscarlosmartinez3034 2 роки тому +1

    THANK YOU!

  • @Factstipsnmotivation
    @Factstipsnmotivation 3 роки тому +1

    Thankyou ..It is very clear

  • @eagleslandin1692
    @eagleslandin1692 3 місяці тому

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

  • @rajasami2960
    @rajasami2960 3 роки тому

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

  • @entertainment0407
    @entertainment0407 Рік тому

    Password error... How to solve

  • @rudezexo7555
    @rudezexo7555 3 роки тому

    6:41 knows 😂 ...

  • @venusdille8179
    @venusdille8179 2 роки тому +1

    Tttoopp

  • @antoniofuller2331
    @antoniofuller2331 3 роки тому

    Hello moto