Skip to main content

How to Increase Import Size Limit in phpMyAdmin?

If you are reading this blog then probably you are facing the same issue that I had faced, i.e., how to import the sql-dump-file in the mysql where size of the sql-dump-file exceeds the maximum file size limit of phpMyAdmin.

I was having a sql-dump-file (got from client) that I need to import on my local database in mysql. The file size was 186 MB while the maximum size limit of phpMyAdmin was 8 MB. A BiG PrObLeM!


Then I searched on Google and found that, there are few tricks available to achieve this. Most of them are related to modifying the php.ini file as given below:
  1. Increase the upload_max_filesize limit.
  2. Increase the post_max_size limit.
  3. Increase the memory_limit limit. Though you can not go beyond 128M.
I tried it all. Unfortunately none of them worked for me. But fortunately, I had the full access of my server. So I did it via command-prompt. It is so simple and smooth, if you put all the paths correctly.

Let's see the process to solve our problem. Steps to follow:
  1. Find the location of mysql on the system.
  2. Go inside it's bin directory.
  3. Copy the path displaying in the address bar.
  4. Open the command-prompt.
  5. Change the directory in command-prompt to the directory in which mysql is installed.
  6. Type cd  then paste the path that we had copied and press Enter. 
  7. The prompt will show the path where mysql is installed. Verify that!
  8. Type mysql -u your_user -p your_database < dump_file.sql and press Enter. Here,
    • your_user is mysql username
    • your_database is the mysql database/schema
    • dump_file is the complete physical path of the sql-dump-file.
  9. Now enter mysql password, press Enter and wait ...
  10. If prompt appears, then your sql-dump-file is successfully uploaded. Otherwise, re-iterate the process.

Labels:

Comments

Post a Comment

Popular posts from this blog

Unlock protected blocks in Siemens SIMATIC Step 7

Recently I'd been called by Hindalco's Fabrication Plant division to unlock the protected blocks in Siemens SIMATIC Step 7. They were in need to unlock those blocks since an year because of 1 million Rupees of loss per month. They want to re-program those blocks but it was locked by the man who'd done the setup. From the people working in that department, I came to know that they were trying to call that man (someone from Italy) right here but he's not coming. Actually, what he'd done was that he'd locked some of the blocks and deleted the source file. And Siemens didn't provide any feature to unlock. Department people also told me that even the people working in Siemens don't know how to do it. Being a software engineer I know that any thing can be reverse engineered. So I took up the challenge. How did I unlocked the blocks? The first thing I'd done was searched about this software at Google and read about what is this software all about. Aft...
50 comments
Read more

Launching a Jupyter Notebook with TensorFlow using Docker

This article will walk you through setting up a Jupyter Notebook environment with TensorFlow pre-installed using Docker. Docker allows you to run isolated containerized applications, providing a consistent environment regardless of your underlying operating system. Prerequisites: Docker: Ensure you have Docker installed and running on your system. You can download and install it from the official Docker website ( https://www.docker.com/ ). Steps: Start Docker: Open your Docker application (Docker Desktop for Windows/macOS or the command line if using Linux). Run the Jupyter Notebook container: For macOS/Linux: Open your terminal application and run the following command: docker run -it --rm -p 8888:8888 -v "${PWD}":/home/jovyan/work jupyter/tensorflow-notebook For Windows: Open your Command Prompt application and run the following command: docker run -it --rm -p 8888:8888 -v "%CD%":/home/jovyan/work jupyter/tensorflow-notebook Explanation of the command flags: -...
Post a Comment
Read more

JS: The complete code example of Crypto.js (DES)

For one of the project I was trying to use crypto.js but I found that the Quick-start Guide have some deficiency in terms of library usage. So I am writing it here as a useful note for memory recap. <script src="http://crypto-js.googlecode.com/svn/tags/3.1.2/build/rollups/tripledes.js"></script> <script> var encrypted = CryptoJS.DES.encrypt("The secret message", "secret_key"); var e_msg = encrypted.toString(); console.log(e_msg); var decrypted = CryptoJS.DES.decrypt(e_msg, "secret_key"); var d_msg = decrypted.toString(CryptoJS.enc.Utf8); console.log(d_msg); </script>
4 comments
Read more