How to move MySql forum database from Hetzner to Afrihost.

0 votes
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;
USE `azapeo_forum`;

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?
asked Sep 1, 2018 in Shared Hosting by JimAttrill (120 points)

1 Answer

0 votes

Good Day,

When importing a database using phpmyadmin, please note that database prefix will be different, and the cPanel account username will be different.

You will need to change the prefix from azapeo_forum to your new database prefix eg newUserID_forum.

If you require further assistance please 
send a message to our whatsapp help line: https://whatsapp.afrihost.com
or visit our Help Centre: https://help.afrihost.com/
​​​​or see our FAQ page: http://faq.afrihost.com

Thank you

 

answered Sep 11, 2018 by AfriClaire (20,950 points)
...