{"id":1340,"date":"2019-03-20T15:27:20","date_gmt":"2019-03-20T07:27:20","guid":{"rendered":"http:\/\/tommykwan.com\/blog\/?p=1340"},"modified":"2019-03-20T16:56:43","modified_gmt":"2019-03-20T08:56:43","slug":"wordpress-cone-migration-and-backup-from-server-a-to-server-b","status":"publish","type":"post","link":"https:\/\/tommykwan.com\/blog\/my-diaries\/wordpress-cone-migration-and-backup-from-server-a-to-server-b\/","title":{"rendered":"WordPress Cone\/migration and Backup (from Server A to Server B)"},"content":{"rendered":"

Today, I am trying to back up my WordPress on Server A to Server B.<\/strong> To assist my future operations, I would like to open a post to record the procedures briefly.<\/p>\n

Firstly, you need to backup all the wordpress folder as well as the SQL. If you can, just use the export function of phpMyAdmin on Server A.<\/p>\n

However, there is some tricky point is that you have to click two boxes: 1)\u00a0\u58d3\u7e2e: zip and 2)\u00a0\u532f\u51fa\u8cc7\u6599\u5eab\u70ba\u5404\u5225\u6a94\u6848 in order to zip the .sql by using phpMyAdmin function.<\/p>\n

Copy the whole folder from Server A<\/p>\n

MUST export xxx.sql.zip<\/span><\/strong> (one of the phpMyAdmin Export Function)<\/p><\/blockquote>\n

Then, just copy and paste the whole folder to Server B<\/p>\n

And import the\u00a0xxx.sql.zip<\/span><\/strong>\u00a0to Server B by using phpMyAdmin<\/p>\n

If you have problem during import – please pay attention on the limitation on upload setting in php.ini<\/strong>
\nReference:\u00a0http:\/\/tech.smallya.net\/2017\/11\/21\/phpmyadmin%E7%84%A1%E6%B3%95%E6%AD%A3%E5%B8%B8%E5%8C%AF%E5%85%A5%E4%B8%8A%E5%82%B3%E5%A4%A7%E5%AE%B9%E9%87%8Fsql%E6%AA%94%E6%A1%88%E5%95%8F%E9%A1%8C%E8%A7%A3%E6%B1%BA\/<\/a><\/p>\n

\n
upload_max_filesize = 100M;<\/code><\/div>\n
post_max_size = 100M;<\/code><\/div>\n<\/blockquote>\n

Then follow instruction of the link :\u00a0https:\/\/www.wpbeginner.com\/wp-tutorials\/how-to-fix-the-error-establishing-a-database-connection-in-wordpress\/<\/a>\u00a0to edit the\u00a0WP-Config.php\u00a0<\/strong><\/p>\n

Of course, you can test the connection by using another php<\/p>\n

testconnection.php<\/strong><\/p>\n

<?php
\n$link = mysqli_connect('localhost', 'username', 'password');
\nif (!$link) {
\ndie('Could not connect: ' . mysqli_error());
\n}
\necho 'Connected successfully';
\nmysqli_close($link);
\n?><\/code><\/p>\n

<\/div>\n<\/blockquote>\n
After that, in phpMyAdmin of Server B,<\/strong> use the command below to update all the old path<\/strong>(URL, root path…whatever you name it)<\/div>\n
Reference link:\u00a0https:\/\/www.hostinger.com\/tutorials\/wordpress\/how-to-change-wordpress-urls-in-mysql-database-using-phpmyadmin<\/a><\/div>\n
<\/div>\n
\n
\n
UPDATE wp_options SET option_value = replace(option_value, 'http:\/\/www.oldurl<\/strong>', 'http:\/\/www.newurl<\/strong>') WHERE option_name = 'home' OR option_name = 'siteurl';\r\n\r\nUPDATE wp_posts SET guid = replace(guid, 'http:\/\/www.oldurl','http:\/\/www.newurl');\r\n\r\nUPDATE wp_posts SET post_content = replace(post_content, 'http:\/\/www.oldurl', 'http:\/\/www.newurl');\r\n\r\nUPDATE wp_postmeta SET meta_value = replace(meta_value,'http:\/\/www.oldurl','http:\/\/www.newurl');<\/pre>\n<\/blockquote>\n<\/div>\n
<\/div>\n
Finally, follow this link:\u00a0https:\/\/codex.wordpress.org\/Changing_The_Site_URL<\/a><\/div>\n
\n
\n
Edit wp-config.php<\/span><\/h3>\n
It is possible to set the site URL manually in the wp-config.php file.<\/p>\n
Add these two lines to your wp-config.php, where “example.com” is the correct location of your site.<\/p>\n
define( 'WP_HOME', 'http:\/\/www.newurl' );\r\ndefine( 'WP_SITEURL', 'http:\/\/www.newurl' );<\/pre>\n<\/blockquote>\n
Also, please change the “define(‘WP_DEBUG’, false);” to “define(‘WP_DEBUG’, true);”<\/p>\n<\/div>\n
“define(‘WP_DEBUG’, false);” \u21d2 “define(‘WP_DEBUG’, true<\/strong>);”<\/p><\/blockquote>\n
 <\/p>\n
<\/div>\n
However, there is still some problem after doing these steps – for example, you cannot enter the admin login page directly by using : ‘http:\/\/www.newurl\/admin’<\/div>\n
<\/div>\n
to solve this problem, I am still looking for solution. But you can still login directly<\/strong> through\u00a0http:\/\/www.newurl\/wp-login.php<\/strong><\/div>\n
<\/div>\n
Indeed, there are few reasons leading to the probelm:<\/div>\n
    \n
  1. After log onto admin page of your wordpress >> Setting >> Permalinks: there are various options, please make sure you have choose the correct setting, if you are not sure, try-and-errors method could help.. just click every one to try it.<\/li>\n
  2. You may need to set up the Virtual Host if you have various WordPress in your Server B<\/li>\n<\/ol>\n
    <\/div>\n
    To set up virtual host – link FYI:<\/div>\n
    https:\/\/www.cloudways.com\/blog\/configure-virtual-host-on-windows-10-for-wordpress\/<\/a><\/div>\n
    <\/div>\n
    One more important concept is that if you have more than one wordpress in your Server B, you need to set the virtual host as below:<\/div>\n
    <\/div>\n
    \n
    <VirtualHost *:80>
    \nDocumentRoot \"C:\/xampp\/htdocs\/\"
    \nServerName localhost<\/strong>
    \n<Directory \"\/\">
    \n<\/Directory>
    \n<\/VirtualHost><\/code><\/p>\n
    \n
    <VirtualHost *:80>
    \nDocumentRoot \"C:\/xampp\/htdocs\/host1<\/strong>\"
    \nServerName host1.localhost<\/strong>
    \n<Directory \"C:\/xampp\/htdocs\/host1<\/strong>\">
    \n<\/Directory>
    \n<\/VirtualHost><\/code><\/p>\n
    \n
    <VirtualHost *:80>
    \nDocumentRoot \"C:\/xampp\/htdocs\/host2<\/strong>\"
    \nServerName host2.localhost<\/strong>
    \n<Directory \"C:\/xampp\/htdocs\/host2<\/strong>\">
    \n<\/Directory>
    \n<\/VirtualHost><\/code><\/p>\n<\/div>\n<\/div>\n
    <VirtualHost *:80>
    \nDocumentRoot \"C:\/xampp\/htdocs\/host3<\/strong>\"
    \nServerName host3.localhost<\/strong>
    \n<Directory \"C:\/xampp\/htdocs\/host3<\/strong>\">
    \n<\/Directory>
    \n<\/VirtualHost><\/code><\/div>\n<\/div>\n
    <\/div>\n
    <\/div>\n
    Finally, I have done this trouble task<\/div>\n
    Good Luck!<\/div>\n
    <\/div>\n
    End of report @ Tommy.K<\/div>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    Today, I am trying to back up my WordPress on Server A to Server B. To assist my future operations, I would like to open a post to record the procedures briefly. Firstly, you need to backup all the wordpress folder as well as the SQL. If you can, just use the export function of Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1340","post","type-post","status-publish","format-standard","hentry","category-my-diaries"],"_links":{"self":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/1340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/comments?post=1340"}],"version-history":[{"count":11,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/1340\/revisions"}],"predecessor-version":[{"id":1351,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/1340\/revisions\/1351"}],"wp:attachment":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/media?parent=1340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/categories?post=1340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/tags?post=1340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}