Feeds:
Posts
Comments

Posts Tagged ‘mysql’

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

Read Full Post »

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 »

Server –> Openfire
IM Client –> Spark

Database –> Postgressql/Mysql

Read Full Post »

Grant Priviledge di MySQL

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

Read Full Post »

>alter table tabel_lama rename table_baru;

Read Full Post »

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 »