Importing datebase from a local mambo install

[carlosolares]

when importing a datebase from a local site i get a phpmyadmin error

MySQL said:

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 14, 2005 at 06:19 PM
-- Server version: 4.1.10
-- PHP Version: 5.0.3
--
-- Database: `futbol`
--
CREATE DATABASE `futbol` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci
MySQL said:

#1044 - Access denied for user 'alza'@'localhost' to database 'futbol'

if anyone has a clue a would thankfu

[Bill]

Hello,

This error appears because you are trying to import the database dump directly from the phpMyAdmin, expecting that it will create the database needed.

Unfortunately, this does not work quite so. You will first need to go to the cPanel - MySQL Databases and to create a database there. Then you need to create an user and add it to the database. Once you do that, you can launch the phpMyAdmin tool and you need to select the database you want from the dropdown menu.

Importing the dump will work this way, provided that the dump is not corrupted.

Regards,

Bill
SiteGround Support Team

[copycatz]

Hello

I have developed my website with Joomla on my local PC, and now I try to export it to SiteGround
For the moment, it doesn't work!
It says: "This site is temporarily unavailable. Please notify the System Administrator"
Ideas of what is going wrong? configuration.php? SQL Database?

- Configuration.php:
Could you please tell me what are the followings in configuration.php:
config_host = siteground5.com ?
config_db = Do the databases all look like "name_name"?

so in configuration.php, for config_db, do I have to put "name" or "name_name"?

- SQL Database:
I have the following error message:
INSERT INTO `jos_gm_groupe` ( `id_groupe` , `nom_groupe` , `description_groupe` , `access_groupe` )
VALUES ( 1, '**Membre**', 'Tous les utilisateurs membres = Groupe Joomla "Registered".', 1 )
#1062 - Duplicate entry '1' for key 1

Do you know what is going wrong?

Thank you a lot for your help, I have turned the problem all around without any solution...
Joachim

[Tom]

config_host = siteground5.com ?

config_host = 'localhost';

config_db = Do the databases all look like "name_name"?

It is alwayw like 'name_name' where name1 = your username and name2 = your db name cPanel works that way

INSERT INTO `jos_gm_groupe` ( `id_groupe` , `nom_groupe` , `description_groupe` , `access_groupe` )
VALUES ( 1, '**Membre**', 'Tous les utilisateurs membres = Groupe Joomla "Registered".', 1 )
#1062 - Duplicate entry '1' for key 1

I suppose something is wrong with teh SQL exported db file. It can be imported (most probably) but some raw should be escaped. Here is what I can say for sure:

When exporting a DB, click on the preferences that escape all the characters, also add the drop table if exists variables.

You can contact our tech support too, they will most probably be able to import the DB for you server side

[copycatz]

Thanks for your help
It still doesn't work
I'll contact tech support