Apache / mysql cannot start in xampp?

Try solution :
Install / upgrade  Microsoft visual c++ 2008 sp1 redistributable package (x86)

Error import mysql from PHPmyadmin

Error:

Fatal error: Maximum execution time of 300 seconds exceeded in E:\xampp\phpMyAdmin\libraries\import\sql.php on line 134

Solusi:

edit file config.default.php di folder phpmyadmin/libraries

cari baris $cfg[‘ExecTimeLimit’] = 300; rubah nilainya menjadi 0;

Chat Server Local

Server –> Openfire
IM Client –> Spark

Database –> Postgressql/Mysql

Grant Priviledge di MySQL

GRANT ALL PRIVILEGES ON db_baru.* TO dhani@’localhost’ IDENTIFIED BY ‘katakunci’ WITH GRANT OPTION;

rename table di mysql ????

>alter table tabel_lama rename table_baru;

Backup dan Restore database MYSQL ?????

Melalui Query

>> Backup

>mysqldump.exe -u dhani -p blogtastic > blogtastic.sql

 

>> Restore

>mysqldump.exe -u dhani -p blogtastic < blogtastic.sql

Melalui PHPMYAdmin

>>Backup/Export

>Restore/Import

referensi : http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/