Linux, DevOps and Cloud Expert at Linux Guru !

Backup a Single and All the MysQl Databases.

Single database:
mysqldump -u root -pmypasswd vishalvyas > /opt/vishalvyas.sql

Restore:
mysql -uroot -pmypasswd vishalvyas < /opt/vishalvyas.sql


To back up all databases on a particular server, use the mysqldump command:
 
Backup all the databases:
mysqldump -u root -pmypasswd --all-databases > /opt/alldatabase.sql

Restore:
mysql -uroot -pmypasswd < /opt/alldatabases.sql


















Thanks,
Vishal Vyas

7 comments:

  1. Thanks for the auspicious writeup. It if truth be told was
    a leisure account it. Look complex to more delivered agreeable from you!
    By the way, how could we communicate?

    Stop by my blog: bug spray

    ReplyDelete
  2. Hi there everybody, here every one is sharing such familiarity, thus it's pleasant to read this webpage, and I used to pay a visit
    this weblog every day.

    my site: garnicia cambogia

    ReplyDelete
  3. Great post. I was checking continuously this blog and
    I'm impressed! Very helpful info specially the last part :) I care
    for such information a lot. I was seeking this particular info for a
    very long time. Thank you and good luck.

    Feel free to visit my weblog ... garcinia cambogia cleanse

    ReplyDelete
  4. Hey there fantastic website! Does running a blog like this take a large amount of work?

    I have very little knowledge of programming but I was
    hoping to start my own blog in the near future. Anyway, if you have any ideas or tips for new
    blog owners please share. I understand this is off topic but I
    just had to ask. Thanks!

    Feel free to visit my page: garcinia cambogia max

    ReplyDelete
  5. Peculiar article, just what I wanted to find.

    Also visit my webpage :: cambogia garcinia

    ReplyDelete
  6. Hey very nice blog!

    Feel free to surf to my web-site: Dragon City Gold Hack

    ReplyDelete
  7. Online backup service is the real answer to all of their concerns regarding data storage and recovery because they are more likely to face data corruption or loss than big businesses.
    goodcloudstorage

    ReplyDelete