Move Blog To Another Hosting

I moved this site to another hosting server, and now it is online again. Finally, I have managed to get all the database back. Well, I made a mistake because I didn’t make a full backup process before. That was giving me some trouble.I never imagine that I will deal with some kind of SQL database code.man, that is really blowing my head off.Quite confusing one huh.

I try to re-install my application(wordpress) using Installatron, but still there is nothing to get my database back. Allthought I have imported SQL in a zip format, I keep redirecting every time I was logging in. Sometime it’s in and often can ‘t logged in.Almost 8 hours I’m doing this process and keep wondering why is causing the problem. The worst thing is that I didn’t make a XMR file to import to. I just count on My SQL database.

Then I decided to install it manually, with new user, password and database. So the process is done and my site is back online, but without previous database I have created.I don’t want to waste all my posts, comments, links, etc. in my site, so I try repeatedly to make things back to normal as I want to. After hours hours I made it, and my database recovered better than before.

You see, if you just created a new wordpress site, it will generate its own table prefix in database and usually wp_  by default. My SQL database backup was using a wp_ prefix too, so I let my new installation by default table prefix in order to get the same table prefix. It ‘s generated.
:
wp_comment
wp_comment _meta
wp_post
wp_post_meta
wp_options
wp_user
wp_user_meta
So I delete all the table except wp_user and wp_user _meta and i import my SQL backup then the table generated.You will get errors warning during this process because table wp_user and wp_user_meta have already made, but it’s fine, just continue. Guess what, it works! But with different user admin name and password of course because wp_user and wp_user_meta weren’t replaced. All you have to do now is upload all previous plugins and themes you are used before and that’s it, you get all your posts, comments, etc. back. However, if you are using a cache plugin before, DO NOT upload it again. Bettter to make a new installation for that plugin after your site up and running because that’s the thing which keeps redirecting me every time I am  logging in.

Now to improve performance of your site, do some cleanup for database. Remove unused tables and values. Specially you will find many unused values in wp_options table, which restore all of your behaviour in the previous site. After that your site will be much more lighter and speedy. This process cannot be done by some database plugin,you have to do it manually from your PHPMyAdmin. Just beware not to delete wrong table and value. If you are not sure with some tables or values, and you do not recognize them, just leave them as they are.

There you go! Your site is ready for rocks again!

Tagged as: how to move blog, how to move site, move site, other hosting, site in other hosting