We hope that they will be helpful for you in mitigating the problem. ConclusionĪll of these provided solutions are the best for resolving the issue. Step 5: Select sql file from drop down list from phymyadmin to import. Step 4: Copy and paste the large sql file into upload directory which you want importing to phymyadmin. When prompted, provide your MySQL credentials and complete the import process. Step 3: Create a directory called ‘upload’ within the phpmyadmin directory. ★ /path/old_database.sql - Full path to your. ★ new_database - A file name in which you want to import your old database file. mysql -u username -p new_database < old_database.sql ➔ Use the command below if your database file is in the public_html directory. mysql -u username -p new_database < /path/old_database.sql ➔ First, open a terminal and use the following command below when your database file is in any other directory. ➢ Solution-3: Use MySQL Command in TerminalĪnother solution for solving this problem is to consider using the command line in your terminal to import the SQL file. ➔ Once you update it, just save the file.Īfter that, restart your web server to apply the changes.Īlso Read: How to Increase Max Upload Size in cPanel? ➔ In that, you just need to update the given lines below. ➔ You have to Open the ‘php.ini’ file on your server. To do this, you simply need to follow the following: Increasing your server’s PHP file size limit is another good solution that you can apply to solve this problem. If the solution mentioned above doesn’t work for you. ➢ Solution-2: Increase Your Server’s PHP File Size Limit With the help of this, you can achieve a major size reduction.Īlso Read: How to Download SQL Database From cPanel? You can also use any other compression method as well. If you have SQL files that are not much larger in size, you can use this solution to import the file in phpMyAdmin quickly. Solutions to Import Large SQL file in phpMyAdmin ➢ Solution-1: Compress SQL File In this article, we will discuss the solutions with which you can easily import large SQL files in phpMyadmin.Īlso Read: How to Fix the 504 Bad Gateway Timeout Error? With the right approach and some optimizations, it is possible to import large SQL files into phpMyAdmin successfully. When importing large SQL files into phpMyAdmin, you can often result in timeouts or server errors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |