Full Description:
<b>MySQL Snap</b> is intended for creation of backup copies of MySQL database or a collection of databases as well as for recovering or transferring the data to another SQL server (not necessarily a MySQL server). This utility is fully compatible with standard MySQL utilities. <br><br> Below is the list of main functions the program realizes: <br> <dl><dd> <li>Dumping databases (creation of backup copies of databases) <ul><li>Connection to the specified database or to all databases at the same time; <li>Saving connection parameters and keys in special files to reduce time required for connection and parameters settings; <li>Choosing the necessary databases for dumping (from one database to all MySQL databases); <li>Dump parameters settings: setting the keys influencing the forming of result file (which contains MySQL statements); <li>Choosing the necessary tables and conditions for dumping selected rows only; <li>Dumping the databases taking into account chosen settings and conditions into result dump file containing SQL statements; <li>Possibility of displaying of dump process with the help of special process indicator. </ul> <li>Recovering databases <ul><li>Connection to the specified database or to all databases at the same time; <li>Saving connection parameters and keys in special files to reduce time required for connection and parameters settings; <li>Choosing the necessary database, where recovery will be implemented to (only if one database is recovered); <li>Setting recovery parameters; <li>Recovery of one or several databases from files containing SQL statements (dump files); <li>Possibility of displaying of recovery process with the help of special process indicator. </ul> </dl> The <b>result of dumping</b> is the file containing SQL statements and all the necessary information for recovering the exact copy of the database. <BR><BR> The <b>result of recovering</b> is the database (or collection) recovered at MySQL server.