cannot import mysql databse in phpadmin

[solobrian]

I go to SQL, Import, select the file, and after it uploads this message appears:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- [phpmyadmin.net...]
--
-- Host:
-- Generation Time: Mar 26, 2006 at 01:47 PM
-- Server version: 4.0.23
-- PHP Version: 4.4.2
--
-- Database: `solobri_dating`
--
CREATE DATABASE `solobri_dating`

MySQL said:

#1044 - Access denied for user 'brianb'@'localhost' to database 'solobri_dating'

[dreamcatcher]

Hi,

Its a permissions issue. You have permission to run a query, but not to create a database. Usually this is done in your Control Panel.

So, create the database, then remove the create query in your file and import the data and structure only and you should be fine.

dc

[Vastio]

I second what dreamcatcher said. I had the same issue two days ago and couldn't figure out what was going on.

I manually created the database in phpMyAdmin, then imported the file without the "CREATE" line and it worked fine.

[solobrian]

should I also delete the "USE" command? It has the same database listed as the "CREATE" line.

[Vastio]

Yes. Everything up until you create the tables can be deleted. Most of it is just comments.

[solobrian]

It worked! Thanks for the help guys.