Feeds:
Posts
Comments

Posts Tagged ‘mysql’

Apache / mysql cannot start in xampp?

Posted in Softwares, tagged , , , on July 17, 2012| Leave a Comment »

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

Read Full Post »

Error import mysql from PHPmyadmin

Posted in Softwares, tagged , , , , , on May 4, 2012| Leave a Comment »

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;

Read Full Post »

Chat Server Local

Posted in Softwares, tagged , , , , , , on January 9, 2012| Leave a Comment »

Server –> Openfire
IM Client –> Spark

Database –> Postgressql/Mysql

Read Full Post »

Grant Priviledge di MySQL

Posted in Softwares, tagged , , on December 10, 2011| Leave a Comment »

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

Read Full Post »

rename table di mysql ????

Posted in Softwares, tagged , , on June 22, 2009| Leave a Comment »

>alter table tabel_lama rename table_baru;

Read Full Post »

Backup dan Restore database MYSQL ?????

Posted in Softwares, tagged , , , on April 29, 2009| Leave a Comment »

uhmmMelalui Query

>> Backup

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

backup-mysql5 

>> Restore

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

Melalui PHPMYAdmin

>>Backup/Export

export_php_myadmin

>Restore/Import

import

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

Read Full Post »