Database issues

[delboy]

Hello,
1) Open the .sql dump into TextPad/NotePad++, And remove all the junk like the below..

-- Dump by Phpmyadmin
/*!40101 SET NAMES 'utf8' */;
SET FOREIGN_KEY_CHECKS=0;

2) once its tidyed up, just import my mysqldumper or bigdump using latin1. (depending on your db size you may be able to use phpmyadmin)