An update & resolution: I asked the web host for help and they found that I had a piece of code in .htaccess limiting the access to wp-config.php. Once the code was removed, all worked as it should.
Two possible easy ways to replace Old website URL to New Website URL: 1/ Directly replace in SQL file: Export the database and open SQL file. Manually find and replace old website URL with new website URL. Once replace is done, save and import database again. 2/ Use Migrate DB plugin: Use the third-party WordPress … Read more
There is extensive question/answers for moving from development to produciton in general Easily Move a WordPress Install from Development to Production? However for your specific question best plugin that I know is commercial BackupBuddy. It packs whole site (including WP itself) and can restore it to different URL.
There might be hardcoded links in the theme; download it and do a multifile search with a text editor. Editing the text dump destroys serialized data; see another Q/A here: Why is my database import losing text widget data? Update 4/19/2015 To correctly change URLs in the database, the SQL queries below will work when … Read more
Note: This is more a comment than an answer, but I wanted to format it nicely. I don’t know about recording, but I imagine something like the following in SQL could work. INSERT INTO DB1.Tbl1 ( id, x, y ) SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y FROM DB2.Tbl1 ON DUPLICATE KEY UPDATE x=x, y=y; Beware, this is … Read more
I don’t think you will find any comprehensive or easy answer for this. I think the way you already broke down the various aspects of your installation is the key – i.e., thinking of changes to files as different from changes to the database. Most of the changes I make are at the file level … Read more
It would appear that as of today, there is no easy automated way to do the migration. Closing this out.
Turn off commenting in your old blog using the following Plugin http://wordpress.org/extend/plugins/disable-comments/ Then turn off the new user registration from Settings->General by unchecking “Anyone can register” Hope it will help 🙂
Try using the 10up/MU-Migration command: https://github.com/10up/MU-Migration
If you have access to your mysql you can update the wp-options table. Before modification… $ mysql -u <db_user> –password=<db_pwd> -D <db_name> <<<“select * from wp_options where option_name in (‘siteurl’, ‘home’);” +———–+—————–+—————————————————————————————————+———-+ | option_id | option_name | option_value | autoload | +———–+—————–+—————————————————————————————————+———-+ | 1 | siteurl | http://172.17.0.2/wordpress | yes | | 2 | home … Read more