Jasiek’s Blog

During restore from SQL dump.
Insert is probably too big. Try to increase:
Max. packet size from default of 1 MB to something bigger (2, 3 MB)
You can use MySQL Administrator GUI available at mysql.com

[Read more →]

@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 →]

Process:
Downloaded MySQL 4.1.7 from http://www.mysql.com/
Downloaded PHP 4.3.9 from http://www.php.net/downloads.php full version
Downloaded Mambo 4.5.1 from www.mamboserver.com
MySQL installed in default settings (used Microsoft installer) but changed path from C: drive to D: drive.
Downloaded and installed MySQL GUI front end from webyog.com
Changed the password for the user to OLD_PASSWORD because of the problem with password hashing. See more [...]

[Read more →]

Create table with ENGINE=MyISAPI tag causes errors.

[Read more →]