Try solution :
Install / upgrade Microsoft visual c++ 2008 sp1 redistributable package (x86)
Tag: mysql
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/