Recently i upgraded from share hosting to vps host, but it seem like i having problem to move my site to new server .... anyone can help ?? i use big dump to import db but post just don't show ,,,,
All you'd need to do is transfer the files and import the database, then change the config file to the right MySQL user/pass/database. Is your new VPS using a control panel? And if so, the same one as your shared host?
yes same both also direct admin .... but problem is i have huge DB ... u means i just import the db to new hosting and move all files from old host to new host ? what i did now, is create new wp installation, then install db (i can see post and other table in phpmyadmin) but post don't show ...
Why do a new install? Just copy all of your old WP files over, reconfigure the mysql database. Then go into phpmyadmin, and import the database. Simple.
If everything is working fine but only posts are not showing up then I think you missed the .htaccess file to be transferred from old host to new server. It happened with me too few times when I changed host. Just get the .htaccess file from old server and upload it to new server then see if the posts are showing up or not. This should solve your issue I think.
Since you are using VPS, I believe you have SSH access? So, you can transfer the database directly server to server using SSH.
Next time you run into this, there's a tool called BigDump that allows you to import large databases without using command line.
Okay, you said that the database was imported? I hope. Now go to your old blog and on the admin panel click export then select WordPress export. This will export all your articles/comments/design/whatever to a .XML file. This is what I did a few months back. It works like a charm. For an in depth overview read my article here. Hope this information helps skabt