Backup and Restore MySQL Databases using MySQL Workbench [2022]

Поділитися
Вставка
  • Опубліковано 28 лип 2024
  • From this video, you will learn how to backup and restore a single database.
    MySQL Workbench is a powerful visual tool for administering your MySQL database. It replaces MySQL's previous GUI tools, such as MySQL Administrator and MySQL Query Browser, allowing you to configure, maintain, and backup your database in one place.
    if you found this video useful please give it a thumbs up and subscribe to my channel! and If you have any questions regarding this video, please ask them in the comment section. thanks for watching! :)
    Channel Subscription:
    🔗 / cscornersunitarai
    -----------------------------------------------------------------------
    Don't forget to tag our Channel...!
    #mysql #backupandrestoredatabase #mysqldatabase
    #MySQL #MySQL8 #latestmysql #cscornersunitarai #mysql #Windows10 #windows11
    Java Programming Tutorial Playlist
    🔗 • Java Programming Tutorial
    Advanced Java Tutorial Playlist
    🔗 • Advanced Java Tutorial
    ------------------------------------------------------------------------
    🎥 Tools I used for recording
    www.amazon.in/shop/cscornersu...
    🌍🌍$$$**Want To Become a SUCCESSFUL UA-camr please join FREE Webinar ***$$$🌍🌍
    digitalachievershub.com/maste...
    ------------------------------------------------------------------------
    CONNECT WITH ME ON:
    ►Facebook - / cscornersunitarai
    ►Personal Facebook A/c - / sunita.sharmarai
    ►Instagram - / cscornersunitarai
    ►Telegram - t.me/cscorner
    ►LinkedIn - / cscornersunitarai
    ------------------------------------------------------------------------
    backup & restore mysql database,how to backup mysql database,backup mysql database,mysql,mysql workbench,mysql workbench backup database,mysql workbench auto backup database,BACKUP & RESTORE MySQL Database,backup database,backup table,restore database,restore table,how to backup database automatically,backup and restore,backup and restore mysql,backup and restore mysql database,mysql workbench backup,mysql workbench restore,database backup,mysql tutorial
    Subscribe to my channel for more videos of programming and hit the bell icon to never miss an update in the future.
    Also don't forget to LIKE & COMMENT.
    Stay tuned!

КОМЕНТАРІ • 49

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

    *_Got a question on this topic? Please share through comments or reach us on telegram _**_t.me/cscorner_*

  • @andylee5969
    @andylee5969 9 місяців тому

    Thank you, this is incredibly helpful.

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

    This worked perfectly, Thanks for making it so clear and straight to the point!

  • @faisalnaveed8
    @faisalnaveed8 7 місяців тому

    Superb very detailed video, Very excellent way of teaching the topic!

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

    Excellent ! Quite helpful ! Thanks.

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

    Hi. Very good video! I have a question. How would I backup the production database(s) and restore to a dev database on the same server? Thank you!!

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

    Thank you very much!

  • @HanhTran-fx7sc
    @HanhTran-fx7sc 7 місяців тому +1

    thank u very much
    video is easy understand and conduct on mysql workbench

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

    Thank you very much madum.. it's very important 🙏🙏❤️

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

    Well explained

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

    very good information thank you

  • @MohdDanish-kv9sw
    @MohdDanish-kv9sw Рік тому

    how to send my database backup to google drive from command line ???????

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

    very nice information

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

    Well explained dear

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

    👍👍

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

    Thanks maam

  • @SameerAli-nm8xn
    @SameerAli-nm8xn Рік тому +1

    Could you help me in resolving the issue like error 1146 in my SQL workbench

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

      Please send screen shot on my telegram. Link on channel page

  • @MarjitaS389
    @MarjitaS389 6 місяців тому +1

    Hi @CSCORNERSunitaRai I’m getting error like ERROR 1049(42000): Unknown database. Please reply what to do. I want to export database to my new laptop, i have taken dumps from my old laptop.

  • @sandhyamahesh3082
    @sandhyamahesh3082 Місяць тому +1

    Can you tell me how to restore what is copied db folder while uninstall and reinstalling..

    • @CSCORNERSunitaRai
      @CSCORNERSunitaRai  Місяць тому

      Again paste it to data folder after new installation

    • @sandhyamahesh3082
      @sandhyamahesh3082 Місяць тому

      @@CSCORNERSunitaRai Thank you so very much for the reply.. I'm newbie so sorry to ask this, should I create db again here with new installation to get this data???

  • @tstephens128
    @tstephens128 8 місяців тому +1

    I have been trying to export for nearly 4 hours, and searching the internet for my error, I cannot find anything to fix MySQL Workbench, I opened DBeaver, and exported in 3 minutes...OMG, MySQL is terrible.... if anyone has any hints, please respond..
    Error when I go to Export: Unhandled exception: 'WbAdminExport' object has no attribute 'options_tab'

  • @Usmanforthevictory
    @Usmanforthevictory 6 місяців тому +1

    Can we do this on button click. Html button with ajax request?

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

    👍

  • @Mahesh717
    @Mahesh717 11 місяців тому +2

    how can we do the same using query ?

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

    Hello Mam, I was unaware of this feature and I want to restore the previous databases which are lost due to system reset. Is it possible mam?

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

      System reset means u formatted ur data then u won't

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

      @@CSCORNERSunitaRai yes mam I formatted my data. I forget to take backup. There is not any method to restore?

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

    How to automate this process?

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

      Full automation?
      Writing commands in the batch file and executing it is one way. Another way is what I have shown.
      I'm little doubtful about full automation

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

      @@CSCORNERSunitaRai I think he asked about auto export daily or weekly or monthly