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
. 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.
Reference: Mahdi Yusuf – MySQL ‘The server quit without updating PID file’
If you have problem on importing the SQL in phpMyAdmin. First, try increasing the following two values in php.ini.
Second, Add the following line in the phpMyAdmin config.inc.php.
$cfg['ExecTimeLimit'] = 0;
Reference: Best way to import large .sql files to PHPmyAdmin via WAMP
Access To MySQL is a freeware which help converting the data in .mdb in Microsoft Access to .sql in MySQL. Check this out.
Bullzip – Access To MySQL
1. Download and install Access To MySQL.
2. Run the Access To MySQL.
Continue reading Export Microsoft Access .mdb to MySQL →
Setting you a web development environment in Windows is a big heahache. Here is a list of all on one WAMP packages.
Continue reading WAMP Stacks →
Use the following SQL to list out all database users in MySQL.
select host, user from mysql.user;
Reference: Alvin Alexander – MySQL show users – how to show the users in a MySQL database
You could use the following command to drop all the tables of a MySQL DB.
- mysqldump -u<user> -p<pwd> --add-drop-table --no-data <db> | grep ^DROP | mysql -u<user> -p<pwd> <db>
Just replace the <user>, <pwd> and <db> with your MySQL username, password and database name. That’s all.
Reference: MySQL drop all tables command
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.
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 →
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 →
The MySQL commands such as mysqldump can be found in
Continue reading MAMP – Run MySQL commands in Terminal →
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 →