How to backup mysql database on ubuntu server
server·@kratos·
0.000 HBDHow to backup mysql database on ubuntu server
**How to backup mysql database on ubuntu server**
Here is how to backup mysql database on ubuntu server, mysql database user "groovy"
password "XgjtCbnhZffdnbbf" mysql database data will be copied to a file "groovydump.sql"
login to ssh
login as: root
root@stoli.serverfarm.com's password:
Welcome to Ubuntu 12.04.5 LTS (GNU/Linux 2.6.32-042stab083.2 x86_64)
* Documentation: https://help.ubuntu.com/
No mail.
Last login: Tue Jul 5 21:49:35 2016 from 41.203.71.186
root@stoli:~# mysqldump -ugroovy -pXgjtCbnhZffdnbbf --all-databases > groovydump.sql
root@stoli:~# ls
groovydump.sql install.sh Maildir virtualmin-install.log
To restore dump
root@stoli:~# mysqldump -ugroovy -pXgjtCbnhZffdnbbf [database_name] < groovydump.sql👍 kratos, fyrstikken, grey580, sqube, kurtbeil, proglobyte, proglobyte-m1, steembriefing, steemint, tingaling, zentat, steemitguide, patelincho, stray, darthnava, pairmike, proctologic, ubg, karenmckersie, daisyd, runridefly, barrydutton, denmarkguy, konelectric, andrei, driptorchpress, forrestwillie, justinashby, whatageek, giantbear, thedeplorable1, meysam, jamesjarman, timelapse, richardcrill, contentjunkie, francomason, peeweeherman, kickass, mrhanky, chair, dickbutt, kitt, steemet, shapeshifter, charity, mrssteve, scratchy, coolcat, towelie, reaction, cartman, cowboycurtis, wilburtsmythe, qantheman, icet, opall, drnick, clarence, itchy, elviss, fyrst-witness, vanilla, azz, curei, nedd, sideshowbob, suntzu, jag, annul, wiggum, austinpowers, movietrailers, jebus, oreo, dademurphy, scene, krusty, newsbot, bitrx, view, icecube, fentan99, chart, stun, conky, philipjfry, highfive, popcornmachine, statsbot, guerilla, mchammer, jambii, shape, quimby, katt, ladder, bluetrade, currie, mishabux, irrelevant,