{"id":3316,"date":"2021-10-22T10:06:53","date_gmt":"2021-10-22T10:06:53","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3316"},"modified":"2021-10-22T10:06:53","modified_gmt":"2021-10-22T10:06:53","slug":"mysql-database-import-is-failing-reason-the-sql-file-is-too-big","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/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 will fail just in case the file size that you simply try 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 would like you&#8217;ll be able to get the web-based terminal access in cPanel).<\/p>\n<p>After creating the database and also the database user in cPanel, check the steps below to import the .sql database file:<\/p>\n<p>1. Upload the <strong>.sql<\/strong> file to your <strong>\/public_html<\/strong> directory2 using an <strong>FTP client<\/strong> or the <strong>cPanel File Manager<\/strong>.<\/p>\n<p>2. Then start a terminal client (PuTTy, etc.) and connect to your account.<\/p>\n<p>3. In the console execute the below command:<\/p>\n<blockquote><p>mysql -u mysql_user -p mysql_db &lt; public_html\/database.sql<\/p><\/blockquote>\n<p>Ensure that you replace <strong>mysql_user<\/strong> along with your <strong>database username<\/strong>, <strong>mysql_db<\/strong> along with your <strong>database name<\/strong>, and <strong>database .sql<\/strong> with the name of <strong>.sql<\/strong> file that you simply have uploaded.<\/p>\n<p>4. After that enter the MySQL user password and click on your enter key.<\/p>\n<p>Now, in your terminal client if you don\u2019t get an error , it indicates that the database import was successful.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uploading browser-based file will fail just in case the file size that you simply try 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 would like [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3316","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3316"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3316\/revisions"}],"predecessor-version":[{"id":3317,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3316\/revisions\/3317"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}