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 :
"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
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 :
CREATE TABLE `testing` (
`id` tinyint(3) NOT NULL auto_increment,
`name` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
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
2. Choose destination folder, in previous step I choose C
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
Here’s the the installation steps :