MySQL export/import database

June 9, 2011 · Posted in mysql · Comment 

The easiest way to export is use syntax in command prompt (cmd):
mysqldump -u USER -p PASSWORD DATABASE > filename.sql

To import the same file, the syntax is:
mysql -u USER -p PASSWORD DATABASE < filename.sql

Tags: no tags

Enable XDebug on WAMP using Eclipse

June 7, 2011 · Posted in apache, php, Windoze · Comment 

For Windows machine running WAMPServer:

1) Install PDT plugin on your eclipse
2) Download XDebug to match your php
3) Install XDebug – save XDebug dll to wamp_path/bin/php/php5.3.5/ext folder
4) Enable XDebug – update php.ini file
4a) comment zend debugger information
4b) enable xdebug
[xdebug]
xdebug.remote_enable = on
xdebug.profiler_enable = off
xdebug.profiler_enable_trigger = off
; xdebug.profiler_output_name = cachegrind.out.%t.%p
xdebug.profiler_output_dir = "path to tmp folder"
xdebug.remote_handler = dbgp
xdebug.remote_host = localhost
xdebug.remote_port = 9000

5) restart apache
6) Update PHP settings on eclipse to enable XDebug

Tags: no tags