How to Backup and Restore MySQL/MariaDB database using mysqldump

Поделиться
HTML-код
  • Опубликовано: 24 авг 2024

Комментарии • 39

  • @georgiosdoumas2446
    @georgiosdoumas2446 4 года назад +3

    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.

  • @rempire380
    @rempire380 3 года назад +1

    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!

  • @tnoel57
    @tnoel57 4 года назад +1

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

  • @lukmangani8911
    @lukmangani8911 3 года назад +1

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

  • @riteshsaha6881
    @riteshsaha6881 2 года назад

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

  • @khajasujath4919
    @khajasujath4919 Год назад

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

  • @collinharmon3207
    @collinharmon3207 3 года назад

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

  • @baniputri96
    @baniputri96 4 года назад +1

    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!

  • @python123
    @python123 Год назад

    Clear and well explained

  • @muhsin98
    @muhsin98 2 года назад

    thank you Mr.Yusuf

  • @swevos7632
    @swevos7632 2 года назад

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

  • @smurffronda2951
    @smurffronda2951 Год назад

    Thank you

  • @azadehhassanian4940
    @azadehhassanian4940 3 года назад +1

    Thank you; It was perfect.

  • @pratik6501
    @pratik6501 Год назад

    thanks a lot

  • @murwaneisa2287
    @murwaneisa2287 2 года назад

    thnaks this help me a lot

  • @deividalmeida7393
    @deividalmeida7393 3 года назад

    Amazing job! Thank you so much

  • @pelemate
    @pelemate 3 года назад

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

  • @rahulmouryaofficial6615
    @rahulmouryaofficial6615 6 месяцев назад

    Can you help me for mariadb dump using azure

  • @alktab8993
    @alktab8993 2 года назад

    hi Yusuf you this video us system MAC OS What commands for win 7 - 8 - 10 - 11 ... thank

  • @TheIyerganapas
    @TheIyerganapas 2 года назад

    Will it create user in destination DB SERVER

  • @philipbrindle867
    @philipbrindle867 3 года назад

    great video, thanks so much for sharing...

  • @robertferguson4366
    @robertferguson4366 3 года назад

    very good video!!! Thanks

  • @johnyoucantseena7484
    @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.

  • @bash6442
    @bash6442 2 года назад

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

  • @yashwanturade3488
    @yashwanturade3488 3 года назад

    Thanks

  • @dwaynewade343434
    @dwaynewade343434 2 года назад

    I keep getting zsh: command not found: mysqldump

  • @Clearlylakecounty121
    @Clearlylakecounty121 Год назад

    Wow

  • @maishamolepo2216
    @maishamolepo2216 3 года назад

    awesome!

  • @JavaAidTutorials
    @JavaAidTutorials 4 года назад

    Nice video..

  • @ahmadzia8557
    @ahmadzia8557 4 года назад

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

  • @Earlam
    @Earlam 3 года назад

    Thx.

  • @dontknowwhattotypelo
    @dontknowwhattotypelo 3 года назад

    super!

  • @sankar2805
    @sankar2805 3 года назад

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

  • @Suraj-vz4jc
    @Suraj-vz4jc 2 года назад

    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

  • @rahulmouryaofficial6615
    @rahulmouryaofficial6615 6 месяцев назад

    Hi

  • @nedoyk
    @nedoyk 4 года назад

    how use the comand using the password?

    • @gideon17you
      @gideon17you 4 года назад

      Easy. substitute your own password: mysqldump -uroot -pmypassword mydb1 > mybackup.sql
      The above statement won't ask for your password.

  • @villastube
    @villastube 3 года назад

    This is not for production.