{"id":1514,"date":"2019-04-10T11:33:30","date_gmt":"2019-04-10T06:03:30","guid":{"rendered":"https:\/\/www.coimbatorewebhosting.com\/blog\/?p=1514"},"modified":"2021-07-08T09:24:06","modified_gmt":"2021-07-08T03:54:06","slug":"know-to-importing-wordpress-maually","status":"publish","type":"post","link":"https:\/\/coimbatorewebhosting.com\/blog\/know-to-importing-wordpress-maually\/","title":{"rendered":"How to know Importing a WordPress site manually"},"content":{"rendered":"<p>Here in this article we provide steps to migrate\/Importing a word press site installation manually,<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/know-to-importing-wordpress-maually\/#Fist_step_-Exporting_the_mySQL_database\" >Fist step :-Exporting the mySQL database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/know-to-importing-wordpress-maually\/#Second_step_-Downloading_the_WordPress_files\" >Second step :-Downloading the WordPress files<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/know-to-importing-wordpress-maually\/#Third_step_-Importing_the_database_into_your_new_hosting_account_or_new_cPanel_account\" >Third step:-Importing the database into your new hosting account (or new cPanel account)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/know-to-importing-wordpress-maually\/#Fourth_step_-Import_the_new_mySQL_database\" >Fourth step:-Import the new mySQL database<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Fist_step_-Exporting_the_mySQL_database\"><\/span>Fist step :-Exporting the mySQL database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For this you have to know the name of the database which you configured earlier and you can get this from your\u00a0\u00a0\u00a0 wp-config file.<\/p>\n<p>And locate\/find the below lines,<\/p>\n<pre>\/* MySQL settings *\/\r\ndefine( \u2018DB_NAME\u2019, \u2018database_name\u2019 );\r\ndefine( \u2018DB_USER\u2019, \u2018username_here\u2019 );\r\ndefine( \u2018DB_PASSWORD\u2019, \u2018password_here\u2019 );\r\ndefine( \u2018DB_HOST\u2019, \u2018localhost\u2019 );\r\ndefine( \u2018DB_CHARSET\u2019, \u2018utf8\u2019 );<\/pre>\n<p>In the <a  href=\"https:\/\/coimbatorewebhosting.com\/blog\/how-to-secure-website-with-ssl\/\" title=\"above database_name\" alt=\"above database_name\">above database_name<\/a> will be the database name like wise the user name and password.The format will be always like the c panel username_databasename<\/p>\n<p>After the above next login phpMyAdmin via your cpanel.Once inside of phpMyAdmin, click on your database located on the left side.<\/p>\n<p>In case if you have multiple databases, you will see the option to expand your username using the + symbol.<\/p>\n<p>Once clicked on your database to migrate, you\u2019ll see all of the tables shown in the right pane. At the top, you\u2019ll click \u201cExport\u201d.<\/p>\n<p>After clicking export, you\u2019ll see a radio button selected for \u201cquick\u201d \u2013 if it is not, please click it. After, click the \u201cgo\u201d button. You\u2019ll then have the option to save the .sql file to your desktop or another folder.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Second_step_-Downloading_the_WordPress_files\"><\/span>Second step :-Downloading the WordPress files<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here you need to navigate or go to your <a href=\"https:\/\/www.coimbatorewebhosting.com\/blog\/how-to-install-wordpress-with-cpanel-in-simple-steps\/\">word press installation<\/a> path where its located,than copy\/download the files and directories such as,<\/p>\n<pre>DIRECTORIES:\r\nwp-admin\r\nwp-content\r\nwp-includes\r\nFILES:\r\n.htaccess\r\nindex.php\r\nwp-activate.php\r\nwp-blog-header.php\r\nwp-comments-post.php\r\nwp-config-sample.php\r\nwp-config.php\r\nwp-cron.php\r\nwp-links-opml.php\r\nwp-load.php\r\nwp-login.php\r\nwp-mail.php\r\nwp-settings.php\r\nwp-signup.php\r\nwp-trackback.php\r\nxmlrpc.php<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Third_step_-Importing_the_database_into_your_new_hosting_account_or_new_cPanel_account\"><\/span>Third step:-Importing the database into your new hosting account (or new cPanel account)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here just login to your <a href=\"https:\/\/www.squarebrothers.com\/wordpress-web-hosting-india\/\" rel=\"nofollow noopener\" target=\"_blank\">new hostin<\/a>g cpanel &gt;&gt;Goto <a href=\"https:\/\/coimbatorewebhosting.com\/blog\/steps-to-redirecting-the-url-by-using-htaccess\/\" title=\"database\" alt=\"database\">database<\/a> section&gt;&gt; Create the new database &amp; user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1526\" src=\"https:\/\/www.coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2019\/04\/database-1.png\" alt=\"importing\" width=\"1106\" height=\"607\" srcset=\"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2019\/04\/database-1.png 1106w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2019\/04\/database-1-300x165.png 300w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2019\/04\/database-1-768x421.png 768w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2019\/04\/database-1-1024x562.png 1024w\" sizes=\"auto, (max-width: 1106px) 100vw, 1106px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In your cPanel account where you wish to put the new WordPress install, you\u2019ll want to create a new database using the information found in step 1 from your wp-config.php file \u2013 database_name (only enter the second part after the underscore). You\u2019ll add this from cPanel &gt; mySQL Databases.<\/p>\n<p>After creating the database, you\u2019ll need to assign a user to it. To <a href=\"https:\/\/coimbatorewebhosting.com\/blog\/how-to-check-memory-usage-on-centos-server\/\" title=\"add\" alt=\"add\">add<\/a> a user, scroll down towards the bottom where you created the database at and you\u2019ll see the option to create a user.<\/p>\n<p>You\u2019ll want to use the same username found in the wp-config.php file or create a new one if one doesn\u2019t exist. (username_here \u2013 you want to use the value after the underscore). Enter a password (make sure to note the password) and add.<\/p>\n<p>After adding the user, you\u2019ll see the option for permissions \u2013 you want to select all permissions, then click add.<\/p>\n<p>Upload the files that were downloaded above into the new installation directory \u2013 this is typically in the public_html folder. If you are installing in another directory, you\u2019d upload the files into that directory.<\/p>\n<p>After uploading, navigate into the wp-config.php file and locate the entries below:<\/p>\n<blockquote>\n<pre>\/* MySQL settings *\/\r\ndefine( \u2018DB_NAME\u2019, \u2018database_name\u2019 );\r\ndefine( \u2018DB_USER\u2019, \u2018username_here\u2019 );\r\ndefine( \u2018DB_PASSWORD\u2019, \u2018password_here\u2019 );\r\ndefine( \u2018DB_HOST\u2019, \u2018localhost\u2019 );\r\ndefine( \u2018DB_CHARSET\u2019, \u2018utf8\u2019 );<\/pre>\n<\/blockquote>\n<p>You will need to edit the variables above to reflect the database name, username &amp; password we created previously.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Fourth_step_-Import_the_new_mySQL_database\"><\/span>Fourth step:-Import the new mySQL database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For this, you will repeat the steps in reverse that we took to export the database:<\/p>\n<p>1. In phpMyAdmin, highlight the new database your created. You\u2019ll see there will not be any tables on the right.<\/p>\n<p>2. At the top, click \u201cImport\u201d. You\u2019ll see the browse button that will allow you to browse to a file. Click browse &amp; locate the file you previously saved containing the .sql extension.<\/p>\n<p>If you follow the above guide lines and do the process step by step than the process of migrate\/import word press installation is easy.<\/p>\n<p>If you satisfied the above post than to know more about word press articles<a href=\"https:\/\/www.coimbatorewebhosting.com\/blog\/how-to-install-wordpress-with-cpanel-in-simple-steps\/\"> click here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here in this article we provide steps to migrate\/Importing a word press site installation manually, Fist step :-Exporting the mySQL database For this you have to know the name of the database which you configured earlier and you can get this from your\u00a0\u00a0\u00a0 wp-config file. And locate\/find the below lines, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3,17],"tags":[],"class_list":["post-1514","post","type-post","status-publish","format-standard","hentry","category-linux","category-general"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa2YU7-oq","_links":{"self":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=1514"}],"version-history":[{"count":0,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1514\/revisions"}],"wp:attachment":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=1514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=1514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=1514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}