Category Archives: mysql

MySQL connection ERROR 1129

Today I had to configure a MySQL database cluster and I faced the following error ERROR 1129 (HY000): Host ‘192.168.1.12’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ while I was trying to access a MySQL instance … Continue reading

Posted in Databases, HaProxy, Linux, mysql | Tagged , , , , , , | 1 Comment

Import a large sql dump file to a MySQL database from command line

Today I had to import a very large SQL dump file (6 Gb) to a MySQL database using windows command line. If you are using linux it is the same. The process is the following: Open a command prompt (or … Continue reading

Posted in Databases, mysql | Tagged , , , , , , , , , , , , | 33 Comments

Change timezone to Apache server , PHP and MySql in XAMPP

I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in server error.log, access.log and php_error_log output. After some searching I … Continue reading

Posted in Apache, Databases, HTTP, mysql, PHP | Tagged , , , , , , , , , , , | 8 Comments