[RÉGLÉ] un newbie ne s'en sort pas avec l'import de la BDD via phpMyAdmin

[BZH33]

Bonjour

j'essaie désespérément de transférer la BDD Joomla3 créée en local sur mon PC vers le serveur qui héberge mon site. Voilà les premières lignes de la sauvegarde SQL effectuée sur le PC. Dans un premier temps ça a planté avec une erreur 1064 juste après la ligne ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ; semble-t-il.

Maintenant ça a l'air de coincer après la ligne INSERT INTO `qf8so_assets` ... au moment de l'enregistrement n°7 avec un message d'erreur #1062 - Duplicate entry '1' for key 'PRIMARY'

Quelqu'un voit-il l'origine du problème ?

Merci

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client : 127.0.0.1
-- Généré le : Sam 29 Août 2015 Ã* 21:43
-- Version du serveur : 5.6.17
-- Version de PHP : 5.5.12

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 */;

--
-- Base de données : `base-test1`
--

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

--
-- Structure de la table `qf8so_assets`
--

CREATE TABLE IF NOT EXISTS `qf8so_assets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
`lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
`name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n',
`title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
`rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_asset_name` (`name`),
KEY `idx_lft_rgt` (`lft`,`rgt`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

--
-- Contenu de la table `qf8so_assets`
--

INSERT INTO `qf8so_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES
(1, 0, 0, 131, 0, 'root.1', 'Root Asset', '{"core.login.site":{"6":1,"2":1},"core.login.admi n":{"6":1},"core.login.offline":{"6":1},"core.admi n":{"8":1},"core.manage":{"7":1},"core.create":{"6 ":1,"3":1},"core.delete":{"6":1},"core.edit":{"6": 1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edi t.own":{"6":1,"3":1}}'),
(2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'),
(3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
(5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
(6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'),
(7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(8, 1, 17, 36, 1, 'com_content', 'com_content', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"co re.edit.own":[]}'),
(9, 1, 37, 38, 1, 'com_cpanel', 'com_cpanel', '{}'),
(10, 1, 39, 40, 1, 'com_installer', 'com_installer', '{"core.admin":[],"core.manage":{"7":0},"core.delete":{"7":0},"core .edit.state":{"7":0}}'),
(11, 1, 41, 42, 1, 'com_languages', 'com_languages', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(12, 1, 43, 44, 1, 'com_login', 'com_login', '{}'),
(13, 1, 45, 46, 1, 'com_mailto', 'com_mailto', '{}'),
(14, 1, 47, 48, 1, 'com_massmail', 'com_massmail', '{}'),
(15, 1, 49, 50, 1, 'com_media', 'com_media', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":{"3":1},"core.delete":{"5":1}}'),
(16, 1, 51, 52, 1, 'com_menus', 'com_menus', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(17, 1, 53, 54, 1, 'com_messages', 'com_messages', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
(18, 1, 55, 96, 1, 'com_modules', 'com_modules', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(19, 1, 97, 100, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(20, 1, 101, 102, 1, 'com_plugins', 'com_plugins', '{"core.admin":{"7":1},"core.manage":[],"core.edit":[],"core.edit.state":[]}'),
(21, 1, 103, 104, 1, 'com_redirect', 'com_redirect', '{"core.admin":{"7":1},"core.manage":[]}'),
(22, 1, 105, 106, 1, 'com_search', 'com_search', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
(23, 1, 107, 108, 1, 'com_templates', 'com_templates', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(24, 1, 109, 112, 1, 'com_users', 'com_users', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(25, 1, 113, 116, 1, 'com_weblinks', 'com_weblinks', '{"core.admin":{"7":1},"core.manage":{"6":1},"core .create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"co re.edit.own":[]}'),
(26, 1, 117, 118, 1, 'com_wrapper', 'com_wrapper', '{}'),
(27, 8, 18, 19, 2, 'com_content.category.2', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(28, 3, 4, 5, 2, 'com_banners.category.3', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(29, 7, 14, 15, 2, 'com_contact.category.4', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(30, 19, 98, 99, 2, 'com_newsfeeds.category.5', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(31, 25, 114, 115, 2, 'com_weblinks.category.6', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
(32, 24, 110, 111, 1, 'com_users.category.7', 'Non catégorisé', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(33, 1, 119, 120, 1, 'com_finder', 'com_finder', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
(34, 1, 121, 122, 1, 'com_joomlaupdate', 'com_joomlaupdate', '{"core.admin":[],"core.manage":[],"core.delete":[],"core.edit.state":[]}'),
(35, 1, 123, 124, 1, 'com_tags', 'com_tags', '{"core.admin":[],"core.manage":[],"core.manage":[],"core.delete":[],"core.edit.state":[]}'),
(36, 1, 125, 126, 1, 'com_contenthistory', 'com_contenthistory', '{}'),
(37, 1, 127, 128, 1, 'com_ajax', 'com_ajax', '{}'),
(38, 1, 129, 130, 1, 'com_postinstall', 'com_postinstall', '{}'),
(39, 18, 56, 57, 2, 'com_modules.module.1', 'Main Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(40, 18, 58, 59, 2, 'com_modules.module.2', 'Login', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(41, 18, 60, 61, 2, 'com_modules.module.3', 'Popular Articles', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(42, 18, 62, 63, 2, 'com_modules.module.4', 'Recently Added Articles', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(43, 18, 64, 65, 2, 'com_modules.module.8', 'Toolbar', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(44, 18, 66, 67, 2, 'com_modules.module.9', 'Quick Icons', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(45, 18, 68, 69, 2, 'com_modules.module.10', 'Logged-in Users', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(46, 18, 70, 71, 2, 'com_modules.module.12', 'Admin Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(47, 18, 72, 73, 2, 'com_modules.module.13', 'Admin Submenu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(48, 18, 74, 75, 2, 'com_modules.module.14', 'User Status', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(49, 18, 76, 77, 2, 'com_modules.module.15', 'Title', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(50, 18, 78, 79, 2, 'com_modules.module.16', 'Connexion', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(51, 18, 80, 81, 2, 'com_modules.module.17', 'Breadcrumbs', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(52, 18, 82, 83, 2, 'com_modules.module.79', 'Multilanguage status', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(53, 18, 84, 85, 2, 'com_modules.module.86', 'Joomla Version', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(54, 18, 86, 87, 2, 'com_modules.module.87', 'Language Switcher', ''),
(55, 18, 88, 89, 2, 'com_modules.module.88', 'Main menu en-GB', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(56, 8, 20, 23, 2, 'com_content.category.8', 'Category (en-gb)', ''),
(57, 56, 21, 22, 3, 'com_content.article.1', 'Article (en-gb)', ''),
(58, 18, 90, 91, 2, 'com_modules.module.89', 'Main menu en-US', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(59, 8, 24, 27, 2, 'com_content.category.9', 'Category (en-us)', ''),
(60, 59, 25, 26, 3, 'com_content.article.2', 'Article (en-us)', ''),
(61, 18, 92, 93, 2, 'com_modules.module.90', 'Main menu fr-FR', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(62, 8, 28, 31, 2, 'com_content.category.10', 'Catégorie (fr-fr)', ''),
(63, 62, 29, 30, 3, 'com_content.article.3', 'Article (fr-fr)', ''),
(64, 18, 94, 95, 2, 'com_modules.module.91', 'Main menu de-DE', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
(65, 8, 32, 35, 2, 'com_content.category.11', 'Kategorie (de-de)', ''),
(66, 65, 33, 34, 3, 'com_content.article.4', 'Beiträge (de-de)', '');

[BZH33]

Re : un newbie ne s'en sort pas avec l'import de la BDD via phpMyAdmin

Bon, j'ai tout recommencé de zéro, refait le dump, l'import, etc...

... et maintenant ça marche.

J'avais sans doute juste besoin d'en parler pour trouver la solution

A+

[BZH33]

Re : un newbie ne s'en sort pas avec l'import de la BDD via phpMyAdmin

P.S. : je ne sais pas comment marquer ce sujet comme réglé. Merci aux admins de bien vouloir m'aider

[lesoutier]

Re : un newbie ne s'en sort pas avec l'import de la BDD via phpMyAdmin

Si c'est réglé merci de l'indiquer :

http://forum.joomla.fr/announcement.php?f=230

[BZH33]

Re : un newbie ne s'en sort pas avec l'import de la BDD via phpMyAdmin

Si c'est réglé merci de l'indiquer :
http://forum.joomla.fr/announcement.php?f=230

Oui, je n'oublie pas, mais je ne trouvais pas la manière de le faire (cf ci-dessous). Je crois avoir vu où le faire maintenant

P.S. : je ne sais pas comment marquer ce sujet comme réglé. Merci aux admins de bien vouloir m'aider