Learn Devops tools online from the blog. Devops Institute Ahmedabad.

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

1 comment:

  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