Tag Archives: MySQL

Database, Mac

OS X – Fail to start MySQL server which is installed by Homebrew

Leave a comment

After i reboot my OS X, i find that i couldn’t start the MySQL server and it throws the following error:

hatuey:5.6.19 yingkityuen$ mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/hatuey.local.pid).

 

Go to the above folder and delete the mysql error log which is ended with .err. In my case, i executed the following command:

hatuey:5.6.19 yingkityuen$ rm /usr/local/var/mysql/hatuey.local.err

Where hatuey is my Mac machine name.

This should fix the problem.

Done =)

Reference: Mahdi Yusuf – MySQL ‘The server quit without updating PID file’

Database

phpMyAdmin – SQL import timeout

1 Comment

If you have problem on importing the SQL in phpMyAdmin. First, try increasing the following two values in php.ini.

  • max_execution_time
  • max_input_time

 

Second, Add the following line in the phpMyAdmin config.inc.php.

$cfg['ExecTimeLimit'] = 0;

 

Done =)

Reference: Best way to import large .sql files to PHPmyAdmin via WAMP

Database

MariaDB – Installation on Ubuntu Precise

2 Comments

Next: Run phpMyAdmin on Nginx in Ubuntu Precise

It’s time to give up MySQL and move on to MariaDB. Here is the steps for MariaDB installation on Ubuntu Precise (Ubuntu 12.04.1 LTS) with root privilege.

1. Create the following file.
/etc/apt/sources.list.d/MariaDB.list

# http://downloads.mariadb.org/mariadb/repositories/
deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main
deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main

Continue reading MariaDB – Installation on Ubuntu Precise →

CMS

Drupal 7 – Create a Datetime field in hook_schema() @ 1

3 Comments

Next: Drupal 7 – Create a Datetime field in hook_schema() @ 1

If your custom module requires an additional table in the Drupal database, you have to create the .install file and define the schema inside it. In Drupal 7, the datetime field is no longer support by the Drupal Schema API. If you want to create a datetime field, you have to use the mysql_type or pgsql_type. Here is an example.
Continue reading Drupal 7 – Create a Datetime field in hook_schema() @ 1 →

Linux, PHP

PHP – PHP 5.3 Repository for CentOS from Webtatic.com

Leave a comment

Webtatic.com provides its own repository. If you want to get the latest packages such as PHP and MySQL, you can consider adding it to your yum repo by the following steps.

1. Add the yum repository information

Continue reading PHP – PHP 5.3 Repository for CentOS from Webtatic.com →