Importazione database PhpMyAdmin

[drezzer]

Buongiorno,
Io ho costruito un forum in phpbb3 per conto di un amico...ora vorrei trasferirlo; Ho fatto il backup completo seguendo questa guida sviluppo-e-manutenzione-f192/settaggi-c ... t3704.html

Il mio problema nasce al momento dell'importazione del mio database tramite PhpMyAdmin.
il messaggio di errore è il seguente:
--------------------------------------------------------------------------------------------------------------------------------------------
Errore
Query SQL:
--
-- Database: `clxvqqba_bb1`
--
CREATE DATABASE `clxvqqba_bb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Messaggio di MySQL: Documentazione
#1044 - Access denied for user 'lmxmwfyr'@'srv-hp2.netsons.net' to database 'clxvqqba_bb1'
--------------------------------------------------------------------------------------------------------------------------------------------
Il database database 'clxvqqba_bb1' è il mio, mentre il database 'lmxmwfyr_qiwn1' è quello dell'utente destinatario...

Non so come risolvere, qualcuno può darmi qualche dritta?

[Angolo]

1 - Posta le prime 40 righe del database
2 - Lo stai importando su netson?

[drezzer]

Si lo sto importando su Netsons...



-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: mysql.netsons.com
-- Generato il: Lug 11, 2012 alle 16:35
-- Versione del server: 5.1.61
-- Versione PHP: 5.2.17

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: `clxvqqba_bb1`
--
CREATE DATABASE `clxvqqba_bb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE clxvqqba_bb1;

-- --------------------------------------------------------

--
-- Struttura della tabella `bb_acl_groups`
--

DROP TABLE IF EXISTS `bb_acl_groups`;
CREATE TABLE IF NOT EXISTS `bb_acl_groups` (
`group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_setting` tinyint(2) NOT NULL DEFAULT '0',
KEY `group_id` (`group_id`),
KEY `auth_opt_id` (`auth_option_id`),
KEY `auth_role_id` (`auth_role_id`)
) TYPE=MyISAM;

--
-- Dump dei dati per la tabella `bb_acl_groups`
--

INSERT INTO `bb_acl_groups` VALUES(8, 2, 0, 21, 0);
INSERT INTO `bb_acl_groups` VALUES(8, 1, 0, 21, 0);
INSERT INTO `bb_acl_groups` VALUES(8, 0, 0, 6, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 0, 0, 5, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 0, 0, 2, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 0, 0, 6, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 0, 0, 6, 0);
INSERT INTO `bb_acl_groups` VALUES(4, 0, 0, 5, 0);
INSERT INTO `bb_acl_groups` VALUES(4, 0, 0, 10, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 1, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 1, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 1, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 1, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 2, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 1, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 2, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 1, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 2, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 2, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 2, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 0, 88, 0, 1);
INSERT INTO `bb_acl_groups` VALUES(1, 2, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 3, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 3, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 3, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 3, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 3, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 3, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 5, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 5, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 5, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 5, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 5, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 5, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 6, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 6, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 6, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 6, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 6, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 6, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 7, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 7, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 7, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 7, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 7, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 7, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 8, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 8, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 8, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 8, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 8, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 8, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 9, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 9, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 9, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 9, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 9, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 9, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 10, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 10, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 10, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 10, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 10, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 10, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 11, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 11, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 11, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 11, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 11, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 11, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 12, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 12, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 12, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 12, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 12, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 12, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 13, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 13, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 13, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 13, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 13, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(5, 13, 0, 14, 0);
INSERT INTO `bb_acl_groups` VALUES(1, 14, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(2, 14, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(3, 14, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(6, 14, 0, 17, 0);
INSERT INTO `bb_acl_groups` VALUES(7, 14, 0, 17, 0);

[Angolo]

Bastavano le prime 40...


L'unica diversità che si evince, è la mancanza di questa stringa:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

Che dovrebbe essere presente al posto o in aggiunta di:
SET time_zone = "+00:00";


Sembrerebbe un problema dell'Host... verifica importando il database in locale o su altro host.
Se in locale o su altro host, è tutto regolare, segnala la cosa a Netson.