When you are developing with the Server2Go stack, you might want to\u00a0automatically\u00a0backup your database periodicly.
\n
\nI propose a simple script that backups your database each time when you start up your Self configuring database.<\/p>\n
Script:<\/p>\n
\r\n@echo off\r\n\r\nrem Add date to filename\r\nfor \/f \"tokens=2\" %%i in ('date \/t') do set DATE_DOWNL=%%i\r\nfor \/f \"tokens=1,2 delims=:\" %%i in ('time \/t') do set DATE_DOWNL=%DATE_DOWNL%_%%i%%j\r\n\r\necho dumping database to MySql_%DATE_DOWNL%.sql\r\n\r\n.\\server\\mysql\\bin\\mysqldump --port=7188 -u root --all-databases >.\\MySql_%DATE_DOWNL%.sql\r\n<\/pre>\n
\nCreate a batch file with a name such as “backup.cmd<\/strong>” and place it in the same location where “server2go.exe<\/strong>” is located.
\n
\nYou will need to place it in your pms_config.ini<\/strong> :<\/p>\n\r\n[Startup]\r\n;--- You can add additional EXE files that will be started in the startup process of Server2Go\r\n;--- At the moment the EXE files will be started invisible and right AFTER the webserver\r\n;--- and MySQL-Start\r\nStartup1=backup.cmd\r\nStartup2=\r\nStartup3=\r\n<\/pre>\n
\nSo every time you start Server2Go a backup will be made. Also as long Server2Go is running you can execute the batch file whenever you want to make an additional extra backup.<\/p>\n
Please +1 When you are using it!<\/p>\n","protected":false},"excerpt":{"rendered":"
When you are developing with the Server2Go stack, you might want to\u00a0automatically\u00a0backup your database periodicly. I propose a simple script that backups your database each time when you start up your Self configuring database. Script: @echo off rem Add date to filename for \/f “tokens=2” %%i in (‘date \/t’) do set DATE_DOWNL=%%i for \/f […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[14],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p61yPs-54","_links":{"self":[{"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/posts\/314"}],"collection":[{"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/comments?post=314"}],"version-history":[{"count":17,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/posts\/314\/revisions"}],"predecessor-version":[{"id":334,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/posts\/314\/revisions\/334"}],"wp:attachment":[{"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/media?parent=314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/categories?post=314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/floris.briolas.nl\/floris\/wp-json\/wp\/v2\/tags?post=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}