What BackUp capabilities does STUDIO provide?
1) Using Backup Database Service. It can create a full or differential backup of a database, as well as a backup of transaction log. You can create a backup of the whole database or of some separate files. This method is highly reliable. While a backup is created, the users can continue their work with the database – the data integrity is ensured. A backup can be created to a logical backup device, a file, a tape or to a named pipe. In all the cases the device should be placed on the server or in the local network where the server is installed. The path to the device is defined from the server side. To use the network devices, SQL Server Service should be launched from the user name that has an access to the device. To call this service, please, open Database Management tab in STUDIO and choose Backup Database. To call this service from SQL Manager for SQL Server you can use Services/Backup Database in the main menu. To restore database or transaction log from backups created in this w
STUDIO supports several methods of creating database backups. 1) Using Backup Tables Service. This method can be used for creating backups of MyISAM tables. It is characterized by high speed and reliability. When creating a backup in this way, MyISAM tables chosen by a user are blocked (LOCK TABLES SQL command) and then the files, where structure (.frm) and data (.MYD) are physically kept, are copied according to the chosen path (BACKUP TABLES command). The last can be either a local directory on the server or a shared folder in the network. This path is defined from the server side where MySQL is installed. To call Backup Tables Service, please, open Database Management tab in STUDIO and choose Backup Tables. To call this service from SQL Manager for MySQL open Services/Backup Tables. In order to restore tables from backups created by this method, please, use Restore Tables Service that restores MyISAM tables (RESTORE TABLES SQL command) previously saved by Backup Tables Service. Rest
