How to Export a Database in MySQL Workbench

Поділитися
Вставка
  • Опубліковано 23 лип 2024
  • 📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
    🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
    There's an easy way to export your entire MySQL database in MySQL Workbench.
    You can use the default settings to export it to an SQL file, or you can change a lot of different parameters to set it just the way you like.
    In this video, I'll show you how to run the Data Export process, how to change settings, and what the generated file looks like.
    ⏱ TIMESTAMPS:
    00:00 - Opening Data Export
    00:41 - Configuring the options
    03:47 - Export the data and view the file
  • Наука та технологія

КОМЕНТАРІ • 25

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

    Thank you! Very useful.

  • @avataraang3334
    @avataraang3334 2 місяці тому +1

    Thankyou.. this was really helpful!!

  • @Abuakasilkyjohnson
    @Abuakasilkyjohnson 19 днів тому +1

    gotta leave a like when a video is good and direct

  • @spacex6997
    @spacex6997 5 місяців тому

    Thanks, this is good to know

  • @pradeepjangid811
    @pradeepjangid811 Рік тому +2

    In my workbench database after selecting database there is no option in bottom like export how to export now

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

      What options are you seeing? Do you have a database on your computer to export?

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

      I have the same problem, but It might be a GUI issue/bug on Windows, if you have the output panel open it could be visually blocking the options. To fix this go to View > Panels > hide output area

    • @aasthasolanki7559
      @aasthasolanki7559 5 місяців тому

      ​@PepperDoom thank you so much really i was so frustrated with the same issue. Thanks for your comment it was really helpful 💯

  • @umairghouri7122
    @umairghouri7122 5 місяців тому

    When we select the scheme, the tables are not shown on the right side??
    Kindly help

    • @DatabaseStar
      @DatabaseStar  5 місяців тому

      Oh, you may need to click the refresh button on the left panel to see the tables after you import them.

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

    thaaaaaaaaanks

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

    Yes it is cool now I think it was bad Network on my mobile thanks

  • @TheAbsoluteSir
    @TheAbsoluteSir 22 дні тому

    I don't have a data export button

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

    Video is not seen only sound

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

      Oh that’s strange. I just checked and it seems ok to me. What browser or app are you using?

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

      It must be something on Your side. I can see the video.

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

    Thanks you very much!!!