{"id":6684,"date":"2019-10-18T06:09:42","date_gmt":"2019-10-18T06:09:42","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6684"},"modified":"2019-10-18T06:09:42","modified_gmt":"2019-10-18T06:09:42","slug":"mysql-database-import-is-failing-reason-the-sql-file-is-too-big","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/","title":{"rendered":"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big"},"content":{"rendered":"<p>Uploading browser-based file can fail in case the file size that you are trying to upload is larger as compared to the HTTP post size configuration on the web server.<\/p>\n<p>In case this happens, your MySQL database can be restored just by logging onto your account via SSH client (or if you want you can get the web-based terminal access in cPanel).<\/p>\n<p>After creating the database and the database user in cPanel, check below the steps to import the <strong>.sql database<\/strong> <strong>file<\/strong>:<\/p>\n<p>1. Using an<strong> FTP client<\/strong> or the<strong> cPanel File Manager<\/strong>, upload the <strong>.sql file<\/strong> to your <strong>\/public_html<\/strong> directory.<\/p>\n<p>2. Then start a terminal client (PuTTy, etc.) and connect to your account.<\/p>\n<p>3. Execute the below command in the console:<\/p>\n<pre class=\"lang:default decode:true \">mysql -u mysql_user -p mysql_db &lt; public_html\/database.sql<\/pre>\n<p>Ensure that you replace <strong>mysql_user<\/strong> with your <strong>database username<\/strong>, <strong>mysql_db<\/strong> with your <strong>database name<\/strong>, and <strong>database.sql<\/strong> with the name of<strong>.sql file<\/strong> that you have uploaded.<\/p>\n<p>4. Enter the MySQL user password and click on your enter key.<\/p>\n<p>Now, if you don&#8217;t get an error in your terminal client, it indicates that the database import was successful.<\/p>\n<p>If there is still trouble importing your database after following these steps, please open a ticket in MilesWeb and include the .sql file name and the name of the database you want to import to. Our support team will assist you with the import.<\/p>\n<p><strong>Also Read:<\/strong><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-optimize-a-mysql-database-using-ssh\/\" target=\"_blank\" rel=\"noopener\"><strong>How to Optimize a MySQL Database Using SSH?<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\" target=\"_blank\" rel=\"noopener\"><strong>How To Create MySQL Tables In phpMyAdmin?<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uploading browser-based file can fail in case the file size that you are trying to upload is larger as compared to the HTTP post size configuration on the web server. In case this happens, your MySQL database can be restored just by logging onto your account via SSH client (or if you want you can [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[947],"tags":[1051,471,1050],"class_list":["post-6684","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-mysql","tag-sql-file","tag-mysql-database","tag-mysql-database-import-failed"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Database Import Is Failing, Reason: The .sql File Is Too Big<\/title>\n<meta name=\"description\" content=\"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big\" \/>\n<meta property=\"og:description\" content=\"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-18T06:09:42+00:00\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/\",\"name\":\"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"datePublished\":\"2019-10-18T06:09:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big","description":"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.","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:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/","og_locale":"en_GB","og_type":"article","og_title":"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big","og_description":"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-10-18T06:09:42+00:00","author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/","name":"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"datePublished":"2019-10-18T06:09:42+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article describes the steps to resolve the MySQL database import failure error due to the large size of .sql file.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysql-database-import-is-failing-reason-the-sql-file-is-too-big\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"MySQL Database Import Is Failing, Reason: The .sql File Is Too Big"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":583,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6684"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6684\/revisions"}],"predecessor-version":[{"id":6685,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6684\/revisions\/6685"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}