From Xampp to 1and1 UK - Joomla! Forum - community, help and support

hi all,

i trying upload site xampp/localhost 1and1 uk , domain.

so far have successfully:

uploaded files from:

c:\xampp\htdocs\bagsfulofcolour

to:

domain\public_html

using filezilla

exported sql database in phpmyadmin

export --> custom --> database --> go

created sql database , user in 1and1 admin.

when upload localhost.sql file phpmyadmin in 1and1's admin page, "#1044 - access denied user" message, when tries create database.

i'm stuck, please me! want website live!

my first few lines of sql are:

code: select all

-- phpmyadmin sql dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- host: localhost
-- generation time: nov 11, 2012 @ 02:23 pm
-- server version: 5.5.25a
-- php version: 5.4.4

set sql_mode="no_auto_value_on_zero";
set time_zone = "+00:00";


/*!40101 set @old_character_set_client=@@character_set_client */;
/*!40101 set @old_character_set_results=@@character_set_results */;
/*!40101 set @old_collation_connection=@@collation_connection */;
/*!40101 set names utf8 */;

--
-- database: `bagsfulofcolour_db`
--
create database `bagsfulofcolour_db` default character set utf8 collate utf8_general_ci;
use `bagsfulofcolour_db`;


bertles86 wrote:when upload localhost.sql file phpmyadmin in 1and1's admin page, "#1044 - access denied user" message, when tries create database.

why want create new database?
you need open mysql db created first , use import function import sql file backup!