Jump to content

Impossible importer ma base de donnée


Recommended Posts

Bonjour,

ça faisait un moment que je n'avais pas actualisé mon site, donc je récupère une sauvegarde réscente, 

et quand j'essaie d'importer ma BDD par php mon admin PMA, impossible 

au premier essai j'ai ce message:

/*!40000 ALTER TABLE `ps_address_format` ENABLE KEYS */UNLOCK TABLES

puis quand je renvoi le même fichier pour continuer l'importation j'ai ce message :

-- -- Vidage des routines pour la base de données '154655_base' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */

MySQL a répondu : 

#1231 - La variable 'time_zone' ne peut pas être définie sur la valeur 'NULL'

voilà je comprends ça ne m'a jamais fait ça, et je n'ai rien changer de spécial dans mon site...

merci de votre aide

Edited by tsoful (see edit history)
Link to comment
Share on other sites

Bonjour,

voilà en faisant mysqldump en SSH j'ai ce message... je comprends pas il y aurait un problème avec ma table ps_access ????
 

LOCK TABLES `ps_access` WRITE;
/*!40000 ALTER TABLE `ps_access` DISABLE KEYS */;
INSERT INTO `dp_access` VALUES (1,1,1,1,1,1),(1,5,1,1,1,1),(1,7,1,1,1,1),(1,9,1,1,1,1),(1,10,1,1,1,1),(1,11,1,1,1,1),(1,13,1,1,1,1),(1,14,1,1,1,1),(1,15,1,1,1,1),(1,16,1,1,1,1),(1,19,1,1,1,1),(1,20,1,1,1,1),(1,21,1,1,1,1),(1,22,1,1,1,1),(1,23,1,1,1,1),(1,24,1,1,1,1),(1,25,1,1,1,1),(1,26,1,1,1,1),(1,27,1,1,1,1),(1,28,1,1,1,1),(1,29,1,1,1,1),(1,30,1,1,1,1),(1,32,1,1,1,1),(1,33,1,1,1,1),(1,34,1,1,1,1),(1,35,1,1,1,1),(1,36,1,1,1,1),(1,37,1,1,1,1),(1,39,1,1,1,1),(1,40,1,1,1,1),(1,41,1,1,1,1),(1,42,1,1,1,1),(1,43,1,1,1,1),(1,45,1,1,1,1),(1,46,1,1,1,1),(1,49,1,1,1,1),(1,53,1,1,1,1),(1,54,1,1,1,1),(1,55,1,1,1,1),(1,56,1,1,1,1),(1,57,1,1,1,1),(1,58,1,1,1,1),(1,59,1,1,1,1),(1,60,1,1,1,1),(1,62,1,1,1,1),(1,63,1,1,1,1),(1,64,1,1,1,1),(1,67,1,1,1,1),(1,68,1,1,1,1),(1,69,1,1,1,1),(1,70,1,1,1,1),(1,71,1,1,1,1),(1,72,1,1,1,1),(1,74,1,1,1,1),(1,75,1,1,1,1),(1,76,1,1,1,1),(1,77,1,1,1,1),(1,78,1,1,1,1),(1,79,1,1,1,1),(1,81,1,1,1,1),(1,82,1,1,1,1),(1,83,1,1,1,1),(1,84,1,1,1,1),(1,85,1,1,1,1),(1,87,1,1,1,1),(1,88,1,1,1,1),(1,89,1,1,1,1),(1,90,1,1,1,1),(1,93,1,1,1,1),(1,94,1,1,1,1),(1,95,1,1,1,1),(1,96,1,1,1,1),(1,97,1,1,1,1),(1,100,1,1,1,1),(1,101,1,1,1,1),(1,109,1,1,1,1),(1,118,1,1,1,1),(1,127,1,1,1,1),(1,128,1,1,1,1),(1,131,1,1,1,1),(1,146,1,1,1,1),(1,149,1,1,1,1),(1,156,1,1,1,1),(1,160,1,1,1,1),(1,161,1,1,1,1),(1,162,1,1,1,1),(1,163,1,1,1,1),(1,164,1,1,1,1),(1,165,1,1,1,1),(1,166,1,1,1,1),(1,169,1,1,1,1),(1,170,1,1,1,1),(1,171,1,1,1,1),(1,172,1,1,1,1),(1,173,1,1,1,1),(1,174,1,1,1,1),(1,175,1,1,1,1),(2,1,1,1,0,0),(2,2,1,1,0,0),(2,3,1,1,0,0),(2,4,1,1,0,0),(2,5,1,1,0,0),(2,6,0,0,0,0),(2,7,1,1,0,0),(2,8,1,1,0,0),(2,9,1,1,0,0),(2,10,1,1,0,0),(2,11,1,1,0,0),(2,12,1,1,0,0),(2,13,1,1,0,0),(2,14,1,1,0,0),(2,15,1,0,0,0),(2,16,0,0,0,0),(2,17,1,0,0,0),(2,18,0,0,0,0),(2,19,1,1,0,0),(2,20,1,1,0,0),(2,21,1,1,0,0),(2,22,1,1,0,0),(2,23,1,1,0,0),(2,24,1,1,0,0),(2,25,1,1,0,0),(2,26,1,1,0,0),(2,27,1,1,0,0),(2,28,1,1,0,0),(2,29,1,1,0,0),(2,30,1,1,0,0),(2,31,1,1,0,0),(2,32,1,1,0,0),(2,33,1,1,0,0),(2,34,1,1,0,0),(2,35,1,1,0,0),(2,36,1,1,0,0),(2,37,1,1,0,0),(2,38,1,1,0,0),(2,39,1,1,0,0),(2,40,1,1,0,0),(2,41,1,1,0,0),(2,42,1,1,0,0),(2,43,1,1,0,0),(2,44,1,1,0,0),(2,45,1,1,0,0),(2,46,1,1,0,0),(2,47,1,1,0,0),(2,48,1,1,0,0),(2,49,1,1,0,0),(2,52,1,1,0,0),(2,53,1,1,0,0),(2,54,1,1,0,0),(2,55,1,1,0,0),(2,56,1,1,0,0),(2,57,1,1,0,0),(2,58,1,1,0,0),(2,59,1,1,0,0),(2,60,1,1,0,0),(2,61,0,0,0,0),(2,62,0,0,0,0),(2,63,0,0,0,0),(2,64,0,0,0,0),(2,65,0,0,0,0),(2,66,0,0,0,0),(2,67,0,0,0,0),(2,68,0,0,0,0),(2,69,0,0,0,0),(2,70,0,0,0,0),(2,71,0,0,0,0),(2,72,0,0,0,0),(2,73,0,0,0,0),(2,74,0,0,0,0),(2,75,0,0,0,0),(2,76,0,0,0,0),(2,77,0,0,0,0),(2,78,1,1,1,1),(2,79,0,0,0,0),(2,80,0,0,0,0),(2,81,0,0,0,0),(2,82,0,0,0,0),(2,83,0,0,0,0),(2,84,0,0,0,0),(2,85,0,0,0,0),(2,86,0,0,0,0),(2,87,0,0,0,0),(2,88,0,0,0,0),(2,89,0,0,0,0),(2,90,0,0,0,0),(2,91,0,0,0,0),(2,92,1,1,0,0),(2,93,1,1,0,0),(2,94,1,1,0,0),(2,95,1,1,0,0),(2,96,1,1,0,0),(2,97,1,1,0,0),(2,98,1,1,0,0),(2,99,1,1,0,0),(2,100,1,1,0,0),(2,101,1,1,0,0),(2,109,1,1,0,0),(2,118,1,1,1,0),(2,127,0,0,0,0),(2,128,1,1,0,0),(2,131,0,0,0,0),(2,146,0,0,0,0),(2,149,0,0,0,0),(2,156,0,0,0,0),(2,160,0,0,0,0),(2,161,0,0,0,0),(2,162,0,0,0,0),(2,163,0,0,0,0),(2,164,0,0,0,0),(2,165,0,0,0,0),(2,166,0,0,0,0),(2,169,0,0,0,0),(2,170,0,0,0,0),(2,171,0,0,0,0),(2,172,0,0,0,0),(2,173,0,0,0,0),(2,174,0,0,0,0),(2,175,0,0,0,0);
/*!40000 ALTER TABLE `ps_access` ENABLE KEYS */;
UNLOCK TABLES;
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = '154655_base' AND TABLE_NAME = 'ps_access';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...