Tips – Error message when to restore MySQL using phpMyAdmin wizard

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!

 

Related Posts Plugin for WordPress, Blogger...

Leave a Reply

Your email address will not be published. Required fields are marked *