[Solution] Unable to load or find PHP extension php_intl.dll in WAMP 0

Recently I was started to working with CakePHP 3.x. The latest version of CakePHP needed intl extension to work with it. But I could not enable intl extension in my latest version of Wamp 2.5. So, I have got an error,

PHP Startup : Unable to load dynamic library C:/wamp/path/to/php/ext/php_intl.dll - The specified module could not be found.

We can solve it in a two ways.

Solution 1:

1. Just go to C:/wamp/path/to/bin/php/php5.5.12/. Copy all the files starts with icu* and paste it into C:/wamp/path/to/bin/apache/apache2.2.22/bin/  directory.
2. To enable intl extension,
• Click on the wamp icon
• Click on PHP
• Click PHP extensions
• Click on php_intl
3. Now Restart All Services. 

Thats all... Your intl extension is enabled now... 

Solution 2:

1. Just include the PHP directory into the system's PATH variable.
2. Install the full Microsoft VC++ 2012 Runtime Redistributable package. Make sure to get the 32 bit version for 32 bit PHP builds.

Have any doubt, feel free to comment here!

Read More

How to get sql dump using command prompt in WAMP 0

To get a mysql dump of a database in wamp, first we need to set our mysql path using set path command. The example is given below.
  

set path=c:\wamp\bin\mysql\mysql5.1.36\bin

Replace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.

Then use the below command to export our database.
 

mysqldump -u YourUserName -p YourDatabaseName > sqlDumpFileName.sql

YourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.

Have any doubt, feel free to comment here!

Read More

How to change MYSQL database data directory to another location? - WAMP 0

Database server storing the values in files data directory. So, if you want to change the storage location for the database, you can just put this data directory in any location in your system and tell that path to MYSQL to manipulate data.

In this post I'm going to show some screen shots to do this.

Note : I'm using WAMP in this example.

• First step you should Stop All services
• Just click on the WAMP icon, then select MySQL, then select my.ini file like the above image

• After open you my.ini y.ini in your editor(notepad), find the word datadir. Here you can see the file path for data directory.
• datadir=c:/wamp/bin/mysql/mysql5.5.24/data is current file path for data directory.
• Just go and cut that data directory from the current place and paste it to your desired location.
• Then replace your current directory path to your data directory.
• For example, I pasted my data directory E:/CJ_Ramki/data. So, I changed that directory path to datadir=E:/CJ_Ramki/data like below picture.

•  Finally Start All Services

That's it... Your database server will write and read files from you new location.

Read More