Difficulty uploading my .sql

[chijindu joseph]

Error

SQL query:

--
-- Database: `chijindu joseph`
--
DROP DATABASE `chijindu joseph` ;

MySQL said: Documentation
#1044 - Access denied for user 'techlord'@'localhost' to database 'chijindu joseph'

[Perfect Visual]

Upload the database here let me look into it and upload it for you in your website

[Perfect Visual]

You should attach it as file in this thread here.

[Perfect Visual]

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.

[Perfect Visual]

In exporting your database under "Structure" tick this field "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT" and attach it in this thread. Please no open new thread.

[Perfect Visual]

Ok, better way use our email to forward the database, but will give you other support here. After the necessary support is given and your site is up never upload such here.

[Perfect Visual]

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 "DROP TABLE IF EXISTS" 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!