The plan is to copy all the forum folders and files to the new host server. That's easy enough and already done.
But what's the best process from there? Should I create a new database and run setup.asp?
Or create a new database and then run SQLyog Enterprise to transfer the existing MySql tables to the new serve database - or how is that best done exactly?
SQLYog will do it all for you. If the Db isn't big, the copy DB option is the easiest. If it's rather big, exporting the db to a SQL script with SQLYog and then importing it to the new DB, again using SQLYog, is the fastest way.
yes you will need to have a new db ready and created, but you won't need to have Snitz create all the tables
Thanks HuwR. . .I had already set up a new Snitz complete with all the tables. With nothing to lose I elected to use the "Copy DB to new host" feature of SQLyog. I checked the "drop tables" option and tried it. Very easy. It worked perfectly. Thanks Rui and Huw.