Frequently Asked Questions

1. Sign in to Virtualmin (see Account logins and important URLs).
2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin).
3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
    
4. Select the MySQL database you want to back up from the left-hand column under Database name and click Manage...
5. Click Backup Database. You should now see the Backup Database page.
6. 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.
7. 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
8. For Add drop table statements to backup?, leave it as No unless you need a drop table statment
9. Leave Character set for backup as the default
10. Leave Backup compatability format as the default
11. And for Compression format decide whether you want to compress your backup to save space.
12. Now, click Backup Now. You should now see a page confirming a successful backup and your database should be saved in your desired location

And that's it, you've just made a backup of your MySQL database!

------------------------------------------------------------------------------------------------------------------

Restoring a MySQL database
Using Virtualmin
 

1. Sign in to Virtualmin (see Account logins and important URLs).
2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin).
3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
4. Select the MySQL database you want to back up from the left-hand column under Database name and click Manage...
5. Click Execute SQL. You should now see the Execute SQL page.
6. Near the bottom of the page either enter a location on your account where you want the data base to be restored from for From local file (clicking … will allow you to browse and select the file) or select From uploaded file and click Choose File to select a file from your local machine.
7. For File format, leave it as Tab separated
8. Now, click Execute. You should now see the Import Data page confirming a successful restoration and your MySQL database.

Parked domains in cPanel are domains that point to, or are aliases of existing domains. Virtualmin calls these by their technically accurate term, alias. This is the term used by Apache and its documentation, as well as most other web servers.

To create an alias server in Virtualmin, select the virtual server you'd like to alias, or point to, in the dropdown list in the left-hand Virtualmin menu and click "Create Virtual Server". On the resulting form, click the "Alias of..." link in the New virtual server type: at the top of the page.

Fill in the form with domain name to alias to the selected virtual server, and a description, and click Create Server.

Virtualmin alias servers are more advanced than cPanel "parked domains" because Virtualmin alias servers can accept mail for the domain (automatically mapping users to those of existing users within the parent).