Database

Backup and Restore many mysql database in one shot

Its my bad for not reading database manual that lead me for doing boring task .

Dump a few database from server and dumping it in my windows xp. one by one.

Perhaps someone who see this post can learn and not doing same mistake as me.

Command to backup one database :

backup database pendidikan :

edp# mysqldump -ualam -p pendidikan > pd.sql

backup database cms_study :

edp# mysqldump -ualam -p cms_study> cms1.sql

backup database cms_stmik :

read more »

PHP

PHP 4 end of life announcement

From php.net

"Today it is exactly three years ago since PHP 5 has been released. In those three years it has seen many improvements over PHP 4. PHP 5 is fast, stable & production-ready and as PHP 6 is on the way, PHP 4 will be discontinued. The PHP development team hereby announces that support for PHP 4 will continue until the end of this year only. After 2007-12-31 there will be no more releases of PHP 4.4. We will continue to make critical security fixes available on a case-by-case basis until 2008-08-08. Please use the rest of this year to make your application suitable to run on PHP 5. For documentation on migration for PHP 4 to PHP 5, we would like to point you to our migration guide. There is additional information available in the PHP 5.0 to PHP 5.1 and PHP 5.1 to PHP 5.2 migration guides as well.

For documentation on migration for PHP 4 to PHP 5, we would like to point you to our migration guide. There is additional information available in the PHP 5.0 to PHP 5.1 and PHP 5.1 to PHP 5.2 migration guides as well."

Wow, seem that  php5 campaign get full support

it’s also make zend framework full acceleration since it’s only run in php5 not like codeigniter that run on php4 and php5.

OK, php5 I’m coming icon smile PHP 4 end of life announcement

 

Database

Diff database structure with sqlyog

When requirement for information stored in database grow, old table structure need to adjust for flexibility.

Common task to do in  normal cycle :

1. Build new application in other place

2. Synchronize database ( tables)

3. Upload application.

Second step ( synchronize tables) often  painful when a lot of changes made at home and need to sync with server environment.

A handy tool to sync database table I often use is sqlyog.

For example I have two database :

db1 (at server)

db2 (at home)

table structure has changed.

In db1, table testing has this fields :

 Diff database structure with sqlyog

CREATE TABLE `testing` (
`id` tinyint(3) NOT NULL auto_increment,
 `name` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 read more »

Blog

Forum List for webmaster

It’s been long time I don’t visit a forum, my first paging code gave by someone in sitepoint icon smile Forum List for webmaster

Today I just cross some forum list in digitalpoint forum, list some top forum. To make it interesting they give PR and Alexa rank, here’s the list :

forums.Digitalpoint.comAlexa :140 —- PR :6 — Signature link : Without Nofollow

sitepoint.com/forums/ Alexa :413 —- PR : 7 — Signature link : Without Nofollow

webmasterworld.comAlexa :447 —- PR : 8 — Signature link : No signatures

warriorforum.com/forum/ Alexa :582 —- PR : 5 — Signature link : Without Nofollow

V7N.com/forums/Alexa 960 —- PR : 6 — Signature link : Without Nofollow

Webhostingtalk.com Alexa :1557 —- PR : 6 — Signature link : Without Nofollow

namepros.com Alexa :1767 —- PR : 5 —- Signature link : Without Nofollow

dnforum.comAlexa : 2286 —- PR : 5 —- Signature link : Without Nofollow

webmaster-talk.com Alexa :5131 —- PR : 6 — Signature link : Without Nofollow

kirupa.com/forum/ Alexa :8224 —- PR : 7 — Signature link : Without Nofollow

EarnersForum.com Alexa :9650 —- PR : 5 — Signature link : Without Nofollow

http://forums.devshed.com/ — Alexa:3849 —- PR: 6 — signature link : With NoFollow

Source : DP

 

Blog Software

A definitely must have tool : Massive Keyword List Builder

After a few days deploy All in SEO Pack for wordpress. I made a few experiment with keyword selection and visit to overture, wordtracker etc. In fact its very time consuming but the result is worth. Specially with slackware release posting icon smile A definitely must have tool : Massive Keyword List Builder

Today I found an information in DP forum about this software : "Massive Keyword List Builder"

Visiting author site don’t lead me to download page but quick googling help me to download icon smile A definitely must have tool : Massive Keyword List Builder

Download it from tucows

Wanna see how installation process and screenshots, here you are :

1. Unzip the file and double click installer

 A definitely must have tool : Massive Keyword List Builder

  read more »

PHP

Running php5 and php4 in single machine using wampserver

In previous post I explain about install wampserver. This step only install php5 not php4, to add php4 support in wampserver php4 add on must installed first.

Here’s sthe steps :

1. Double click php4 add-on installer

 Running php5 and php4 in single machine using wampserver

2. Choose destination folder, in previous step I choose C

read more »

PHP Software

Step by step install wamp in windows xp

With recent progress of php5 campaign and minimum windows xp deployment I think I should upgrade my appserv to wampserver mode.

Wampserver can use dual php mode, php5 by default with php4 as addon.

Latest release :

WAMP5 1.7.2 with PHP 5.2.3 and MySQL 5.0.41

PHP4.4.7 ADD-ON for WAMP5 1.7.2

Latest release can be download here

I download WAMP5 1.7.2 with addon php4

 Step by step install wamp in windows xp

Here’s the the installation steps :

read more »

Speak

Weekend Links : php and slackware

It is a dangerous cycle, and one that needs to be broken. The PHP developer community has decided that it is indeed now time to move forward, together. Therefore, the listed software projects have all agreed that effective February 5th, 2008, any new feature releases will have a minimum version requirement of at least PHP 5.2.0. Furthermore, the listed web hosts have agreed that effective February 5th, 2008, they will include PHP 5.2 (or a more recent version) in their service offer.

  • Need slackware12 iso for DVD or CD, click here for mirror list.

Software

Installation guide for OpenOffice 2.2 in Windows XP

Can I use openoffice in my windows XP?

Thats my friend question after taking linux workshop where he use export in pdf using writer.

OpenOffice support  5 platforms :

  • Windows
  • Linux
  • Solaris
  • MacOS
  • FreeBSD

1. Download latest version from here, I take windows version.

 Installation guide for OpenOffice 2.2 in Windows XP

read more »

Blog PHP

Hello dosh dosh, problogger, johnchow, google etc

I often visit to some blog and give a comment and back visit come back for 1 or 2 icon smile Hello dosh dosh, problogger, johnchow, google etc .

One of my friend ask :

"I want to add php snippet in my wordpress, is it possible?"

Yes, I just modify my cwlis wordpress theme (index.php) file and integrate rthanks plugin inside index.php for say hi to visitor from reference site/blog like google, problogger, johnchow etc.

More fun but might be not suitable for person who like to change wordpress theme easily since they must edit index.php each time they change template icon smile Hello dosh dosh, problogger, johnchow, google etc

The point I wanna tell is adding manual php code also possible to other engine like joomla. Make sure You know where to put it and doing little trial error to make it really  work icon wink Hello dosh dosh, problogger, johnchow, google etc

For example :

I add this code :

<?php get_header(); ?>

             <?

        if (preg_match(‘/^http:\/\/(\w+\.)?(google|johnchow|yahoo|

blogspot|doshdosh|problogger|cosaaranda|vavai)\./’,$_SERVER['HTTP_REFERER']) == 1)

{

 // get host name from URL

preg_match(‘@^(?:http://)?([^/]+)@i’,$_SERVER['HTTP_REFERER'], $matches);

$host = $matches[1];



 // get last two segments of host name

preg_match(‘/[^.]+\.[^.]+$/’, $host, $matches);

 //echo "domain name is: {$matches[0]}\n";





echo "<p style=’border:thin dotted black; padding:3mm;’>Welcome <b>{$matches[0]}</b> user . Thanks for visiting my Blog icon smile Hello dosh dosh, problogger, johnchow, google etc </p>";

?>



<?

}

?>

in index.php before this :

<div id="leftside">
    <?php if (have_posts()) : ?>
       
        <?php while (have_posts()) : the_post(); ?>

same output with wordpress plugin.

Just change "google|johnchow|yahoo|blogspot|doshdosh|problogger|cosaaranda|vavai" into some domain that often send visitor to your site/blog.

For some level by write this code directly to php code of engine will decrease load of plugin call icon smile Hello dosh dosh, problogger, johnchow, google etc

 

Blog

Step by Step Guide to Make Blending Adsense Ads

Just found a site called "I like your colors"

I like this site, this site can help make blending adsense ads with its power to determine color of my templates using.

In my new blog about reiki I use a template that need to match the color with adsense.

Here’s my steps :

1. Visit I like your colors site and type my blog address :

  Step by Step Guide to Make  Blending Adsense Ads

read more »