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
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 →
If you meet the following error when importing DB thru the EasyPHP phpMyAdmin.
- #1100 – Table ‘pma_column_info’ was not locked with LOCK TABLES
Open the phpMyAdmin configuration file config.inc.php and the uncomment the following 2 lines.
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'password';
Reference: error while importing DB in mysql
After so many days we have talked about setting up Nginx, PHP-FPM, MariaDB and some PHP caching. We can now try to run a Drupal instance on them. Before we starts, let me listed out all the previous posts.
It’s time to start the Drupal installation.
Continue reading Run Drupal 7 in Nginx →
Previous: MariaDB – Installation on Ubuntu Precise
1. Install phpMyAdmin.
- apt-get install phpmyadmin
2. Select neither Apache nor Lighttpd for the web server selection as we want to run it in Nginx.
3. And say NO for the Configure database for phpmyadmin with dbconfig-common?
Continue reading Run phpMyAdmin on Nginx in Ubuntu Precise →
I don’t know why my newly installed phpMyAdmin selects simplified chinese as default. I hate simplified chinese. And now i figure out how to set the default language.
If you want to enforce a specific language, append the following line in the config.inc.php
$cfg['Lang'] = 'en-utf-8'; // Force this language for all users
Continue reading phpMyAdmin – Set default language →
MAMP is Apache, MySQL and PHP runs on Mac. For Mac users, it is very convenient to use the MAMP package such that they don’t need to install the those application one by one. Moreover, MAMP package also bundled with some other useful programs as well as libraries such as phpMyAdmin and the PHP GD library. For more information, you can refer to the MAMP website.
During the installation, you can include the MAMP control panel into you Mac Dashboard. This is quite helpful for you to start and stop the server. you can also pick either PHP4 or PHP5 by switching to the back panel by clicking the i button which is located under the Apache label on the front panel.
Continue reading MAMP – Introduction →