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 […]
Category: Database
Startup memory difference Percona Server vs MariaDB
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 : […]
mysql error : Can’t create/write to file ‘/tmp/#sql_1581_0.MYI’ (Errcode: 13)
Recent PHP downgrade to 5.2.10 also bring another problem with phpmyadmin. When I try to browse data it work but when I try to see table structure I have this error : Can’t create/write to file ‘/tmp/#sql_1581_0.MYI’ (Errcode: 13) Being curios if the problem caused by phpmyadmin I try shell way : # mysql -uroot […]
Can’t locate Compress/Zlib.pm
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# […]
MYSQL server has gone away
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 […]