Jasiek’s Blog

Jasiek’s Blog header image 4

Entries from April 2007

MySQL Daily backup

April 7th, 2007 · Comments Off · MySQL

@ECHO OFF
rem Daily MySQl backup of all databases
rem J Tylek 06-03-2003
FOR /f “tokens=2,3,4 delims=-/. ” %%F IN (’DATE /T’) DO SET FN=%%F%%G%%H
d:\mysql\bin\mysqldump –user=user –all-databases –password=password >%FN%.sql”
SET FN=
To cleanup a directory of backups
@echo off
rem Utility to clean MySQL data dumps
rem older than 30 days
rem J. Tylek - 06-03-2003
rem using purger.exe
d:\purger\purger -wd 30 D:\MySQL_Backup\*.sql
You will need Purger [...]

[Read more →]

Tags:

Startup, Tool Bars, Menu Bars, Shortcuts, DB Window, etc

April 6th, 2007 · Comments Off · MS Access

In the application’s startup options (Tools-Startup) under Display Form enter the name of the form you want the user to see when the application loads.
In that form’s OnOpen event put =SetStartupOptions()
Also in the startup options uncheck the “Display Database Window.” (You can also do this from code and I have that if you [...]

[Read more →]

Tags:

Refering to form/subform

April 2nd, 2007 · Comments Off · General, MS Access

http://www.mvps.org/access/forms/frm0031.htm

[Read more →]

Tags: