toad78 — 2012-05-10T15:10:14-04:00 — #1
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:
-- phpMyAdmin SQL Dump
-- version 126.96.36.199
-- Host: custl-19
-- Generation Time: May 10, 2012 at 02:52 PM
-- Server version: 5.0.91
-- PHP Version: 4.4.9
ccart_sira DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
1044 - Access denied for user 'thisusername'@'%' to database 'ccart_sira'
kpepiton — 2012-05-19T14:13:29-04:00 — #2
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 — 2012-05-19T14:14:55-04:00 — #3
create an empty db with the name you're importing then create a user with the username