mysqldump: command to backup a database on another remote server

Thursday, August 12th, 2010

MySQL: mysqldump command tip!

The mysqldump program is often used to getting a data dump of a local database for backup reasons or just for moving a database from one server to another. To make this even easier, mysqldump can accept a remote host as an arguement. This means that if you are logged into server A you can get a backup of server B immediatly without having to login to server B and then transfer the file manually vis FTP or SCP etc. Just use this command:

Read the rest of this entry »

Setcookie() Path Problems / Gotchas In PHP

Thursday, April 22nd, 2010

Cookie Problems With PHP?

“The path on the server in which the cookie will be available on. If set to ‘/’, the cookie will be available within the entire domain. If set to ‘/foo/’, the cookie will only be available within the /foo/ directory and all sub-directories such as /foo/bar/ of domain. The default value is the current directory that the cookie is being set in.”
Read the rest of this entry »

Use JQuery To Automatically Set IFrame Height

Wednesday, April 21st, 2010

Auto Adjust IFrame's Height With JQuery

It’s a fairly common problem when developing web applications and using IFrames (inline frames) - the height of an IFrame can’t easily be determined and it’s essentially dynamic as it depends on content and CSS inside the framed page.

Read the rest of this entry »

Drupal: HTTP request status fails / Drupal Status Page Reports Errors

Tuesday, February 23rd, 2010

Drupal status: http request fails

HTTP request status Fails

Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings, and should be resolved in order to download information about available updates, fetch aggregator feeds, sign in via OpenID, or use other network-dependent services.

Read the rest of this entry »

WYSIWYG: The version of TinyMCE could not be detected

Sunday, February 21st, 2010

TinyMCE - Bug In WYSIWYG Drupal Module

There is a bug currently in the WYSIWYG module for Drupal affecting TinyMCE which seems to be in the queue for patching into the stable release.
Read the rest of this entry »

PHP - Load Plain Text CSV Data Into MySQL / Convert CSV To MySQL

Tuesday, January 26th, 2010

The resulting MySQL table after loading CSV data into MyDQL

For a while now, possibly like many other developers, I’ve been coding in PHP using CSV related functions such as fgetcsv() and explode(). This usually works out fine until you want to read data from a CSV file and the store the data inside a MySQL database. Using mysql_query inside a loop is not fun for your servers processor!

As usual, the best way to do things when it comes to PHP & MySQL is to wherever possible get MySQL to do most of the work. Here is an example PHP script for effectively converting a CSV format database into a MySQL table. It presumes you already have a working connection and have selected a database.

Read the rest of this entry »

Use PHP To Backup All MySQL Databases On A Server

Thursday, December 10th, 2009

Here is a useful PHP script I worte for doing web based MySQL backups.  You could integrate this code into some kind of admin web app.  As it is, keep in mind security - don’t put this code up publicly on your server unless you want to share all of your MySQL data!
Read the rest of this entry »

New Site: Destiny Lounge & Guest House, Tanzania

Saturday, December 5th, 2009

Destiny Lounge / Guest House In Tanzania

The Destiny Lounge Bar & Guest House offers contemporary and innovative foods and cocktails with an international flavor. All the Rooms are self containers and equipped with full air condition, TV and DVD player, the room services are available throughout the Lounge bar’s opening hours.

Read the rest of this entry »

3 Newbie Mistakes - Web Design / Development Myths

Wednesday, October 21st, 2009

Newbies beware the web design myths!

Here is a quick look at three different myths that can land budding newbie web designers / developers in hot water later down the line.  If these myths are busted earlier on newbies can graduate on to producing excellent results faster without suffering the painful learning curves.  Web design is not a new job - it’s tried, tested and mature so wheels don’t need re-inventing and mistakes don’t need repeating.  Newbies - read and enjoy!
Read the rest of this entry »

Spin2u Dimiliki Oleh HYGEN

Saturday, October 3rd, 2009

Spin2u Dimiliki Oleh HYGEN

Spin2u menyediakan produk terbaik dan plan perniagaan hebat buat anda mencapai kejayaaan. Sertai kami untuk membebaskan diri anda dari beban kewangan.

Selain daripada web dagang Spin2u beliau juga merupakan pangasas minyak angin 7G dan pembesih wanita sayang.

Read the rest of this entry »