This tutorial will cover how a user can manage MySQL databases.
It assumes you have first logged into Virtualmin.
Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
Select the MySQL database you want to back up from the left-hand column under Database name and click Manage...
Click Backup Database. You should now see the Backup Database page.
For Backup to file, enter a location on your account where you want the data base to be saved and a suitable filename (e.g., /users/home/yourusername/dbbackup). Clicking … will allow you to browse to a suitable location on your account.
Select whether you want all tables to be saved, or just a few specific ones. If you want to back up everything, then just leave All tables selected.
For Add drop table statements to backup?, leave it as No unless you need a drop table statment.
Leave Character set for backup as the default.
Leave Backup compatability format as the default.
And for Compression format decide whether you want to compress your backup to save space.
Now, click Backup Now. You should now see a page confirming a successful backup and your database should be saved in your desired location.
Bosanski
Engleski