Webmin method:
Log in to Webmin at https://localhost:10000.
Click Servers button at the top of Webmin home page
Go to Servers page and select MySQL Database Server
For all databases
Select Backup Databases
Select a directory to store backup file (this should be a user home or if you want /root)
Enable Add drop table to backup? if you wish
Leave the rest as it is
if you want to schedule the backup, enable Scheduled backup enabled?
Choose Simple schedule or Times and dates selected below.
Set the schedule
Click Save and Backup Now to save the project now and run the backup immediately or Save
For individual database
Select database from database list
Click Backup Database button
Select directory to store backup file and name of backup file.
Select tables if needed (make sure you deselect all tables before that)
Select Add drop statement... if you wish
Leave the rest as it is
If you want to schedule the backup, enable scheduling and set the schedule as described earlier.
Click Save and backup
MySQL Administrator method:
If installed, follow the Windows MySQL Administrator guide. MySQL Administrator works the almost identically on both Linux and Windows.
Restoring databases
If you are using MySQL Administrator, visit the Windows guide Restoring databases. There is no need to worry there, MySQL Administrator sports the same look on Linux.
There is no obvious button to press on Webmin. Restoration is actually done by running the backup script following the method described in Creating Athena and ROCP databases. As a recap, click on the target database to call up Edit Database page, select Execute SQL, point it to the backup script.
The same technique is used to port (migrate) databases from one host to another.
|
|