{"id":698,"date":"2024-03-15T08:46:03","date_gmt":"2024-03-15T08:46:03","guid":{"rendered":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?p=698"},"modified":"2024-03-15T08:46:44","modified_gmt":"2024-03-15T08:46:44","slug":"how-to-import-large-sql-file-in-phpmyadmin-html","status":"publish","type":"post","link":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html","title":{"rendered":"How to Import Large SQL file in phpMyAdmin?"},"content":{"rendered":"
\n

When importing large SQL files into phpMyAdmin, you can often result in timeouts or server errors. <\/span><\/p>\n

Don\u2019t worry!<\/strong><\/span><\/p>\n

With the right approach and some optimizations, it is possible to import large SQL files into phpMyAdmin successfully. <\/span><\/p>\n

In this article, we will discuss the solutions with which you can easily import large SQL files in phpMyadmin.<\/span><\/p>\n

\n

Also Read: <\/strong>How to Fix the 504 Bad Gateway Timeout Error?<\/strong><\/a><\/span><\/p>\n

\n

Solutions to Import Large SQL file in phpMyAdmin<\/strong><\/span><\/h2>\n

\u27a2 Solution-1: Compress SQL File<\/strong><\/span><\/h3>\n

If you have SQL files that are not much larger in size, you can use this solution to import the file in phpMyAdmin quickly. <\/span><\/p>\n

You just need to compress the .sql file using gzip or zip. You can also use any other compression method as well. With the help of this, you can achieve a major size reduction.<\/span><\/p>\n

\n

Also Read: <\/strong>How to Download SQL Database From cPanel?<\/strong><\/a><\/span><\/p>\n

\n

\u27a2 <\/strong>Solution-2: Increase Your Server\u2019s PHP File Size Limit<\/strong><\/span><\/h3>\n

If the solution mentioned above doesn\u2019t work for you. Increasing your server\u2019s PHP file size limit is another good solution that you can apply to solve this problem.<\/span><\/p>\n

To do this, you simply need to follow the following:<\/strong><\/span><\/p>\n

\u2794 You have to Open the \u2018php.ini\u2019 file on your server.<\/span><\/p>\n

\u2794 In that, you just need to update the given lines below.<\/span><\/p>\n\n\n\n
\n

max_execution_time = 1024    \/\/ 30 minutes <\/span><\/p>\n

max_input_time = 1024        \/\/ 30 minutes <\/span><\/p>\n

memory_limit = 2048M         \/\/ 2 GB<\/span><\/p>\n

upload_max_filesize = 2048M  \/\/ 2 GB <\/span><\/p>\n

post_max_size = 2048M        \/\/ 2 GB<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u2794 Once you update it, just save the file.<\/span><\/p>\n

After that, restart your web server to apply the changes.<\/span><\/p>\n

\n

Also Read: <\/strong>How to Increase Max Upload Size in cPanel?<\/strong><\/a><\/span><\/p>\n

\n

\u27a2 <\/strong>Solution-3: Use MySQL Command in Terminal<\/strong><\/span><\/h3>\n

Another solution for solving this problem is to consider using the command line in your terminal to import the SQL file.<\/span><\/p>\n

To do this, you simply need to follow the following:<\/strong><\/span><\/p>\n

\u2794 First, open a terminal and use the following command below when your database file is in any other directory.<\/span><\/p>\n\n\n\n
mysql -u username -p new_database < \/path\/old_database.sql <\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u2794 Use the command below if your database file is in the public_html directory.<\/span><\/p>\n\n\n\n
mysql -u username -p new_database < old_database.sql<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

In this case: <\/strong><\/span><\/p>\n

\u2605 username: Your username of MYSQL. <\/span><\/p>\n

\u2605 new_database – A file name in which you want to import your old database file.<\/span><\/p>\n

\u2605 \/path\/old_database.sql – Full path to your .sql file or  old_database.sql file name <\/span><\/p>\n

When prompted, provide your MySQL credentials and complete the import process.<\/span><\/p>\n

Conclusion<\/strong><\/span><\/h2>\n

All of these provided solutions are the best for resolving the issue. We hope that they will be helpful for you in mitigating the problem.<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

When importing large SQL files into phpMyAdmin, you can often result in timeouts or server errors.  Don\u2019t worry! With the right approach and some optimizations, it is possible to import large SQL files into phpMyAdmin successfully.  In this article, we will discuss the solutions with which you can easily import large SQL files in phpMyadmin. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[57],"tags":[],"class_list":["post-698","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"\nHow to Import Large SQL file in phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import Large SQL file in phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\" \/>\n<meta property=\"og:site_name\" content=\"Host IT Smart Knowledge base\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T08:46:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-15T08:46:44+00:00\" \/>\n<meta name=\"author\" content=\"Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9\"},\"headline\":\"How to Import Large SQL file in phpMyAdmin?\",\"datePublished\":\"2024-03-15T08:46:03+00:00\",\"dateModified\":\"2024-03-15T08:46:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\"},\"wordCount\":468,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\",\"name\":\"How to Import Large SQL file in phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website\"},\"datePublished\":\"2024-03-15T08:46:03+00:00\",\"dateModified\":\"2024-03-15T08:46:44+00:00\",\"description\":\"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\",\"name\":\"Host IT Smart Knowledge base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\",\"name\":\"Host IT Smart Knowledge base\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/\",\"url\":\"\",\"contentUrl\":\"\",\"width\":240,\"height\":80,\"caption\":\"Host IT Smart Knowledge base\"},\"image\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"sameAs\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\"],\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import Large SQL file in phpMyAdmin?","description":"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html","og_locale":"en_US","og_type":"article","og_title":"How to Import Large SQL file in phpMyAdmin?","og_description":"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!","og_url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html","og_site_name":"Host IT Smart Knowledge base","article_published_time":"2024-03-15T08:46:03+00:00","article_modified_time":"2024-03-15T08:46:44+00:00","author":"Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html#article","isPartOf":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html"},"author":{"name":"Admin","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9"},"headline":"How to Import Large SQL file in phpMyAdmin?","datePublished":"2024-03-15T08:46:03+00:00","dateModified":"2024-03-15T08:46:44+00:00","mainEntityOfPage":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html"},"wordCount":468,"commentCount":0,"publisher":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization"},"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html","name":"How to Import Large SQL file in phpMyAdmin?","isPartOf":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website"},"datePublished":"2024-03-15T08:46:03+00:00","dateModified":"2024-03-15T08:46:44+00:00","description":"Get a solution for importing large SQL files in phpMyAdmin and optimize your database management for seamless performance. Let\u2019s get started!","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/305\/How-to-Import-Large-SQL-File-In-phpmyadmin.html"]}]},{"@type":"WebSite","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/","name":"Host IT Smart Knowledge base","description":"","publisher":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization","name":"Host IT Smart Knowledge base","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/","url":"","contentUrl":"","width":240,"height":80,"caption":"Host IT Smart Knowledge base"},"image":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g","caption":"Admin"},"sameAs":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/"],"url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/comments?post=698"}],"version-history":[{"count":1,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/698\/revisions"}],"predecessor-version":[{"id":699,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/698\/revisions\/699"}],"wp:attachment":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/media?parent=698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/categories?post=698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/tags?post=698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}