There are several ways to do it. How did you create the backup in the first place? Did you do a sql dump or did you just use the option in the admincp?
Hi Neptune, I seem to know how to restore or backup using the dump function but I never restored anything backed up from the ACP. Would you be able to crack an egg of wisdom on me regarding that?
Restoring from a backup in the ACP is the same as restoring using the dump fucntion. You would upload the db to the source(or destination) server and mysql -u root -p databasename -h localhost < filename.sql