How to Backup a MySQL Database

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

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

Post a Comment