How to do backup ubuntu server's all the mysql databases single script [Solved] Here the simple intro, how my script works. Please read the script fully before you execute. Actually there is no harm there but you have to do what you doing.. backup each mysql db into a different file, rather than one big file as with --all-databases. This will make restores easier. To backup a single database simply add the db name as a parameter (or multiple dbs) mkdir -p /vv_files/backups useradd --home-dir