{"id":179,"date":"2021-06-26T10:54:47","date_gmt":"2021-06-26T10:54:47","guid":{"rendered":"https:\/\/tiruppurwebhosting.com\/blog\/?p=179"},"modified":"2021-07-16T06:45:03","modified_gmt":"2021-07-16T06:45:03","slug":"import-wordpress-manually","status":"publish","type":"post","link":"https:\/\/tiruppurwebhosting.com\/blog\/import-wordpress-manually\/","title":{"rendered":"How to 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<h3>Fist step :-Exporting the mySQL database<\/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 above database_name 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>Second step :-Downloading the WordPress files<\/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\/\" target=\"_blank\" rel=\"noopener\">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>Third step:-Importing the database into your new hosting account (or new cPanel account)<\/h3>\n<p>Here just login to your <a href=\"https:\/\/www.squarebrothers.com\/wordpress-web-hosting-india\/\" target=\"_blank\" rel=\"noopener\">new hostin<\/a>g cpanel &gt;&gt;Goto database 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\" \/><\/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 add 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>Fourth step:-Import the new mySQL database<\/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:\/\/tiruppurwebhosting.com\/blog\/2021\/07\/15\/php-installation-appears-to-be-missing\/\">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, \/* MySQL settings *\/ define(<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,92,1,9],"tags":[],"class_list":["post-179","post","type-post","status-publish","format-standard","hentry","category-basics","category-general","category-home","category-linux"],"_links":{"self":[{"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":0,"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"wp:attachment":[{"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tiruppurwebhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}