We have downloaded it, currently working it, including your SMF setting, will update you when we are through.

You left your settings.php with local host information we have edited it to incorporate your real hosting settings then it looks like this now:

########## Directories/Files ########### Note: These directories do not have to be changed unless you move things.$boarddir = '/home/techlord/public_html'; # The absolute path to the forum's folder. (not just '.'!)$sourcedir = '/home/techlord/public_html/Sources'; # Path to the Sources directory.$cachedir = '/home/techlord/public_html/cache'; # Path to the cache directory.

The error that you experienced was caused by commands in the database import file that are incompatible with cPanel and PHPMyAdmin on your hosting account:DROP DATABASE `chijindu joseph`;CREATE DATABASE `chijindu joseph` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;USE `chijindu joseph`;

These directives most likely weren't added by the option you mentioned, but most likely by another option somewhere in your PHPMyAdmin. The option you mentioned adds directives like &quot;DROP TABLE IF EXISTS&quot; which are compatible, but weren't added to the dump.

We have copied the database dump to your hosting account, removed the offending directives and imported the rest of the data without error.Your website is up and running now. Thank you for chosen PerfectVisualHost.com. if you have any other questions please don't hesitate to let us know and we would be glad to help!