Author Topic: Difficulty uploading my .sql  (Read 7561 times)

0 Members and 1 Guest are viewing this topic.

chijindu joseph

  • Newbie
  • *
  • Posts: 7
Error

SQL query:

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

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

PerfectVisualHost Support Forum


Perfect Visual

  • Administrator
  • *****
  • Posts: 143
Upload the database here let me look into it and upload it for you in your website
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

Perfect Visual

  • Administrator
  • *****
  • Posts: 143
You should attach it as file in this thread here.
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

Perfect Visual

  • Administrator
  • *****
  • Posts: 143
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.
« Last Edit: by Perfect Visual »
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

Perfect Visual

  • Administrator
  • *****
  • Posts: 143
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.
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

Perfect Visual

  • Administrator
  • *****
  • Posts: 143
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.
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

Perfect Visual

  • Administrator
  • *****
  • Posts: 143
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!
« Last Edit: by Perfect Visual »
For promotion of your site see Online Forum Marketing Guide
List your service at African Classifieds ads website

PerfectVisualHost Support Forum