Both services have phpmyadmin. On one side I have exported a SQL download using phpmyadmin and imported it using phpmyadmin on Afrihost. Howver, it doesn't work.
The database as in a directory called /forums on the previous site and I have created the same directory on Afrihost.
But the first few lines of the SQL file read:
CREATE DATABASE IF NOT EXISTS `azapeo_forum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
where 'azapeo' was the FTP userid on the sending website. Should I change this to get the creation of the database on Afrihost to work?