Transfer to New Server With Fantastico & Upgrade WP version

I would do (a)

Oh … Fantastico …… if you use that be sure to change your config file. Also, in wp-config.php, place this line BEFORE you run the new install:
define('DISABLE_CACHE', true);
or you may see cached information

Thanks Podz.

& is Fantastico OK, or should I install Wp manually on the new server?

Heh – some people really like it. I don’t.
So there is no balance in this response ??

The only thing is that the db details will be different.

I’ve just backed up my database and it’s 70meg!?!?

I’m thinking this is down to the plug ins I’m running: Bad Behaviour, Spam Karma 2 and Wp Short Stats?

Can I just backup the 9 tables specifically related to WP & transfer them to the new server, then install those plug ins afresh, or do I need to transfer the databse tables for those plug ins as is?

Cheers

yes.
Lose the stats tables.
To save hassles, just Empty them.
Select them then choose Empty from the dropdown
The next screen will ask to to confirm that each table will be ‘truncated’

(Biggest db I’ve seen? 210meg. Largest I’ve moved was over 70meg. All posts/comments. no spam, no stats)

Thanks again.

Which tables do I actually want to keep for v 1.5.2, v 2.0 and v 2.0.2?

Cheers

3rd screenshot down is default 1.5.2
https://www.tamba2.org.uk/wordpress/backup/

1st screenshot 2.0.2 (same as 2.0)
https://www.tamba2.org.uk/wordpress/admin/

Good news & bad news:

Good news – the upgrade to wp 2.0.2, on the old server went totally smoothly.

Bad news – I have copied everything across to the new server and restored the database (which looks intact). Howeverm although the blog displays, it shows no posts, instead saying “Error 404 – Not Found”

Help!

wp-content/cache
If that exists, delete all inside it?

Have tried that, doesn’t make any difference.

The only thing I can think of is that I haven’t yet changed the DNS over. Right now, if you click on a categories link, it takes you to the content on the old server (which is currently the live one). Could that be it?

It may well be the case.
Track the dns movement across the net with this site once you have repointed:
https://www.mob.net/~ted/tools/dns.php3

Thanks. I don’t think it’s that after all – I have finished moving my other blog across to the new server and uploading the database and it does not give me the same error. All posts display, however they are full of extra characters where apostrophes should be???????

Everything has been repointed but not completed.

Any suggestions?

Cheers.

Good News: It was a DNS issue after all & the first blog is now fine.

Bad News: There is still a problem with the second blog. It is up and running on the server with the DNS repointed successfully, but every post is displaying extra characters. It seems that apostrophes and … are being replaced with nonsense character strings.

The URI is: https://www.thetechnofile.com

Looking at the database on the original server, the posts seem to have the extra characters as well. However, they displayed fine on that server.

Help please!

Make sure that every setting (language, encoding etc.) in the two MySQL databases are the same!
On the other hand it seems to be a MySQL bug in certain versions: even in this forum I can show you lots of weird characters in posts made before the last big upgrade ??