Cannot import Databases

[toad78]

I have five databases that I need to import under one host server.

I have tried different methods of importing, but I still get the same error message:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custl-19
-- Generation Time: May 10, 2012 at 02:52 PM
-- Server version: 5.0.91
-- PHP Version: 4.4.9
--
-- Database: `ccart_sira`
--
CREATE DATABASE `ccart_sira` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'thisusername'@'%' to database 'ccart_sira'

Any thoughts?

[kpepiton]

With PHPmyadmin you can create an empty db with the name you're importing
then create a user with the username and password,
then import without the create database lines in the sql file or phrase it so the db is only created if it does not exist

If the db is bigger than 8meg, download bigdump and use it to upload the big db.

[kpepiton]

create an empty db with the name you're importing then create a user with the username

I have five databases that I need to import under one host server.

I have tried different methods of importing, but I still get the same error message:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custl-19
-- Generation Time: May 10, 2012 at 02:52 PM
-- Server version: 5.0.91
-- PHP Version: 4.4.9
--
-- Database: `ccart_sira`
--
CREATE DATABASE `ccart_sira` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'thisusername'@'%' to database 'ccart_sira'

Any thoughts?