Before restoring, try removing the "DEFAULT CHARSET=latin1" from your sql file.

personman wrote:

Before restoring, try removing the "DEFAULT CHARSET=latin1" from your sql file.

Thanks Personman!
I did as u said n it work! Just not sure if that affects the overall site of not.
Anyway, thanks again, Im testing it now.

I think that mysql 4.1 gets its default charset somewhere else, so you may not have any problem . . . I think.

I found all the blogs except the default one can not be found. Now Iv replaced all the files as the oringinal files but still no luck. dont know why.. :(

Do you mean that the entire blog is missing, along with all of its categories and posts? Or do you mean that there isn't a default blog set?

all post is there on index page but cant not be found in the oringinal location.

here is the [url=http://gislee.com/]new site[/url]. u may take a look at it.

What was the original location?

any links listed are the oringinals

likes the links from different blogs on the top, comments and permanent link etc.

Go into admin > settings and untick "use extra path info" near the bottom ;)

¥

Done!! :>

Cool u mate!

Thanks a lot!