changing server

Please confirm your procedures here:
Moving_WordPress#Moving_WordPress_to_a_New_Server

Yes I have followed all the procedures mentioned there. My blog is at https://mutt.in/~prash/blog <– as you can see doesnt load.

When I logged into mysql and did select * from wp_options the screen started filling with -‘s and +’s, it did not show me the contents. would that be the reason?

Maybe try using character set of file to latin1 when restoring sql database.

check again. the database values are OK

i used to have the DB on mysql 4.1 on the previous server which had CHARSET=latin1, but the new server runs mysql 4.0.x which does not support CHARSET, so i removed the CHARSETs as per a link google gave me. is there no work around without using CHARSETs?

Check Podz’ advice here:
https://www.ads-software.com/support/topic/55643?replies=4#post-302889

that was the very link that i referred to before. I have replaced DEFAULT CHARSET = latin1 with nothing and then imported the script into mysql. Still the problem exists.