PerfectVisualHost Support Forum

WEBSITE DEVELOPMENT SUPPORT => DOMAIN/WEB ADDRESS SUPPORT => Topic started by: chijindu joseph on

Title: Difficulty uploading my .sql
Post by: chijindu joseph on

Error

SQL query:

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

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

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

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

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

You should attach it as file in this thread here.

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

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.

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

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.

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

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.

Title: Re: Difficulty uploading my .sql
Post by: Perfect Visual on

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!