BlogEdi

Memula, download file Excel kat SINI.
Cuba selesaikan masalah yang diberikan.

I want two jars with 10 liters of Water!?
Saya mahu dua balang dengan 10 liter air!?

Let’s try it, very interesting. I have done it!

This method apply to XAMPP and phpMyAdmin.

1. Backup database from the source. Normally the database will using name : localhost.sql
2. After backup, transfer to any folder in the MySQL server that you want to restore, it’s better put into /root
3. Delete database using phpMyadmin if the database exist
3. Then execute commmand: mysql -u root -p < localhost.sql
4. If using XAMPP, it may show error message: -bash: -bash:: command not found
5. If you found this error, try find using this command: find /opt/lampp -name mysql
6. You should found this result: /opt/lampp/bin/mysql
7. Now create shortcut to execution path (/bin)
8. Using this command to create shortcut: ln -s /opt/lampp/bin/mysql /bin/mysql
9. After that, try again to execute: mysql -u root -p < localhost.sql
10. If everything OK, you should prompted the phpMyadmin password
11. Enter password and it will restore the database
12. Double check again the restored database

Good Luck!

Are you found similar error below?

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2411535 bytes)in /opt/lampp/phpmyadmin/libraries/import.lib.php on line 269

This message appear when you try to restore the MySQL database using phpMyAdmin restore wizard.

Solutions:
1. Create file info.php at htdocs
2. Add below code  into info.php:
<?
phpinfo();
?>
3. Load the info.php at your browser
4. Find the parameter –> Loaded Configuration File
Verify the value : it should be : /opt/lampp/etc/php.ini
5. Then, go the the location of php.ini. Open it
6. Then find parameter -> memory_limit. View the memory (Normally default size is 8M)
7. Change it to 256M and save it (It’s depend on your total memory.If you can assign more is better)
8. Restart XAMPP/Apache
9. Load again info.php
10. Check memory_limit. It should changed to 256M
11. You’re done. Try to restore again the database.

That’s all!