How to increase phpmyadmin import memory

How To increase the memory limit for PHPMyAdmin import memory, you’ll need to modify the relevant PHP settings. By default, PHPMyAdmin relies on the PHP configuration for its memory limit. Here’s a step-by-step guide on how to increase the memory limit for PHPMyAdmin:

1. **Locate the php.ini File:**
The first step is to find the `php.ini` file on your server. The location of this file can vary depending on your server setup. Common locations include `/etc/php.ini`, `/etc/php/7.x/php.ini`, or `C:\xampp\php\php.ini` for XAMPP users.

2. **Backup the php.ini File (Optional):**
Before making any changes, it’s always a good practice to create a backup of the `php.ini` file. This way, you can revert to the original settings if something goes wrong.

3. **Open the php.ini File:**
Open the `php.ini` file using a text editor. You can use tools like Notepad++ (Windows), nano (Linux), or any other text editor of your choice.

4. **Find the memory_limit Directive:**
In the `php.ini` file, look for the `memory_limit` directive. It sets the maximum amount of memory PHP scripts can use. It might look like this:

memory_limit = 128M

5. **Increase the Memory Limit:**
Modify the value of the `memory_limit` to increase the memory allocation. For example, set it to 256M, 512M, or more based on your requirements. If you want to set it to 512 megabytes, it will look like this:

memory_limit = 512M

Make sure to use the appropriate unit “M” for megabytes.

6. **Save the php.ini File:**
After making the necessary changes, save the `php.ini` file and close the text editor.

7. **Restart the Web Server:**
To apply the changes, you need to restart your web server (Apache, Nginx, or whatever you’re using). Use the appropriate command for your server:

– On Linux with Apache:
sudo service apache2 restart

– On Linux with Nginx:
sudo service nginx restart

– On XAMPP (Windows):
Stop and start Apache from the XAMPP control panel.

8. **Verify the Change:**
To verify that the memory limit has been increased, create a PHP file with the following content:


Save this file as `phpinfo.php` in your web server’s root directory (e.g., `/var/www/html` on Linux). Then, access this file in your web browser (e.g., http://localhost/phpinfo.php) and search for “memory_limit” to see the new value.

With the increased memory limit, PHPMyAdmin should now be able to handle larger imports more effectively. However, remember that setting a very high memory limit may consume excessive server resources, so be mindful of your server’s capabilities and adjust the memory limit accordingly. If you encounter any issues or errors during the process, ensure that you have the necessary permissions to edit the `php.ini` file and consider seeking assistance from your hosting provider or system administrator.

Design Raddle

Design Raddle is a website design and digital marketing company registered in Delhi, founded by Mr. Viraj Patel in 2019, Design Raddle worldwide deals on services like Software, Web Designing and Development or Digital Marketing etc.

Related Articles

Leave a Reply

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

Back to top button
Best Traveling Place In Ireland

Adblock Detected

It seems that you are encountering an issue with an ads blocker while trying to access an article on Viraj IT News. An ads blocker is a browser extension that prevents ads from loading on websites. While it can be helpful to avoid annoying and intrusive ads, some websites rely on ads to generate revenue and may prevent access to content when an ads blocker is detected. To access the article on Viraj IT News, you may need to disable your ads blocker temporarily. You can do this by clicking on the ads blocker extension icon in your browser and selecting "disable on this website" or similar option. Once you have done this, you should be able to access the article without any issues. However, it is important to note that ads can sometimes be harmful or contain malware, so it is essential to exercise caution when disabling an ads blocker. Make sure to only disable it on trusted and reputable websites, and consider enabling it again once you have finished reading the article. Alternatively, you can also try accessing the article in a different browser that does not have an ads blocker installed, or use a paid subscription service that offers ad-free access to the website.