{"id":2852,"date":"2023-05-15T07:17:44","date_gmt":"2023-05-15T05:17:44","guid":{"rendered":"https:\/\/projektinfo.pl\/?page_id=2852"},"modified":"2023-05-15T07:29:36","modified_gmt":"2023-05-15T05:29:36","slug":"windows-mysql-online-backup","status":"publish","type":"page","link":"https:\/\/projektinfo.pl\/index.php\/windows-mysql-online-backup\/","title":{"rendered":"Windows Mysql Online Backup"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Windows Mysql Online Backup is a very useful application for managing database backups.<\/p>

Main features:<\/div>
\u00a0<\/div>
1. Scheduled backup \u00a0(to remote server or to file).<\/div>
\u00a0<\/div>
2. Add a DROP DATABASE statement before each CREATE DATABASE statement<\/div>
\u00a0<\/div>
3. Add a DROP TABLE statement before each CREATE TABLE statement<\/div>
\u00a0<\/div>
4. Add a DROP TRIGGER statement before each CREATE TRIGGER statement<\/div>
\u00a0<\/div>
5. Surround each table dump with LOCK TABLES and UNLOCK TABLES statements<\/div>
\u00a0<\/div>
6. Dump all tables in all databases<\/div>
\u00a0<\/div>
7. Allow creation of column names that are keywords<\/div>
\u00a0<\/div>
8. Add comments to the dump file<\/div>
\u00a0<\/div>
9. Produce more compact output<\/div>
\u00a0<\/div>
10. Use complete INSERT statements that include column names<\/div>
\u00a0<\/div>
11. Use charset_name as the default character set<\/div>
\u00a0<\/div>
12. Write INSERT DELAYED statements rather than INSERT statements<\/div>
\u00a0<\/div>
13. For each table, surround the INSERT statements with statements to disable and enable keys<\/div>
\u00a0<\/div>
14. Lock all tables before dumping them<\/div>
\u00a0<\/div>
15. This option suppresses the CREATE DATABASE statements<\/div>
\u00a0<\/div>
16. Do not write CREATE TABLE statements that re-create each dumped table<\/div>
\u00a0<\/div>
17. Do not dump table contents<\/div>
\u00a0<\/div>
18. Do not add a DROP TABLE statement before each CREATE TABLE statement<\/div>
\u00a0<\/div>
19. Suppress the SET NAMES statement<\/div>
\u00a0<\/div>
20. Suppress the USE statement<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Windows Mysql Online Backup is a very useful application for managing database backups. Main features:\u00a01. Scheduled backup \u00a0(to remote server or to file).\u00a02. Add a DROP DATABASE statement before each CREATE DATABASE statement\u00a03. Add a DROP TABLE statement before each CREATE TABLE statement\u00a04. Add a DROP TRIGGER statement before each CREATE TRIGGER statement\u00a05. Surround each<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"class_list":["post-2852","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/pages\/2852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/comments?post=2852"}],"version-history":[{"count":4,"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/pages\/2852\/revisions"}],"predecessor-version":[{"id":2878,"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/pages\/2852\/revisions\/2878"}],"wp:attachment":[{"href":"https:\/\/projektinfo.pl\/index.php\/wp-json\/wp\/v2\/media?parent=2852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}