I’m in the middle of project deadline and need to create simple erd. I ever see designer tab in phpmyadmin long time ago but when I need it today I see nothing. To enable the designer tab  : Edit config.inc.php In case only config.inc.sample.php available then you need to rename the file into config.inc.php Locate […]

When browsing for FreeBSD ports on database section I stumbleupon percona server and decide to see whats the difference between pkg and ports : update pkg # pkg update Updating FreeBSD repository catalogue… FreeBSD repository is up-to-date. All repositories are up-to-date. # update ports #portsnap fetch #portsnap extract pkg and ports give same version : […]

edp# perl /usr/local/sbin/mysqlblasy.pl Can’t locate Compress/Zlib.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.8/mach /usr/local/lib/perl5/5.8.8 .) at /usr/local/lib/perl5/site_perl/5.8.8/Archive/Zip.pm line 11. BEGIN failed–compilation aborted at /usr/local/lib/perl5/site_perl/5.8.8/Archive/Zip.pm line  11. Compilation failed in require at /usr/local/sbin/mysqlblasy.pl line 1340. BEGIN failed–compilation aborted at /usr/local/sbin/mysqlblasy.pl line 1340. Solution : edp# cd /usr/ports/archivers/ edp# cd p5-Compress-Zlib && make install edp# […]

Its very rare case when I see message : “MYSQL server has gone away” , a few things to consider are : * Check variable max_timeout * Check variable max_allowed_packet These setting available in my.ini or my.cf file, edit the value and restart mysql daemon. Example : max_allowed_packet=16M max_timeout=28800 Try again to import database using […]