Forum

Restore database er...
 
Notifications
Retirer tout

Restore database error

7 Posts
2 Utilisateurs
0 Reactions
6,440 Vu
(@bassem)
Posts: 27
Active Member
Début du sujet
 
[#5595]

Hello,

I tried for a while to restore my ProjeQtor database but without success.
And every time I receive this error message:

Erreur
Requête SQL :

--
-- Dumping data for table `accessprofile`
--

INSERT INTO `accessprofile` (`id`, `name`, `description`, `idAccessScopeRead`, `idAccessScopeCreate`, `idAccessScopeUpdate`, `idAccessScopeDelete`, `sortOrder`, `idle`) VALUES
(1, 'accessProfileRestrictedReader', 'Read only his projects', 3, 1, 1, 1, 100, 0),
(2, 'accessProfileGlobalReader', 'Read all projects', 4, 1, 1, 1, 150, 0),
(3, 'accessProfileRestrictedUpdater', 'Read and Update only his projects', 3, 1, 3, 1, 200, 0),
(4, 'accessProfileGlobalUpdater', 'Read and Update all projects', 4, 1, 4, 1, 250, 0),
(5, 'accessProfileRestrictedCreator', 'Read only his projectsnCan createnUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projectsnCan createnUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projectsnCan createnUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all pro[...]
MySQL a répondu :

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'

P.S: I am using ProjeQt0r 7.2.5

Thank you for your help.


 
Posté : 04/12/2018 11:50 am
(@babynus)
Posts: 14952
Membre Admin
 

You must clean (empy) DB before restoring.
NB : better rename DB, so you keep existing version as backup


 
Posté : 04/12/2018 11:51 am
(@bassem)
Posts: 27
Active Member
Début du sujet
 

I did it, but I still received this error message:
Erreur
Requête SQL :

--
-- Dumping data for table `accessprofile`
--

INSERT INTO `accessprofile` (`id`, `name`, `description`, `idAccessScopeRead`, `idAccessScopeCreate`, `idAccessScopeUpdate`, `idAccessScopeDelete`, `sortOrder`, `idle`) VALUES
(1, 'accessProfileRestrictedReader', 'Read only his projects', 3, 1, 1, 1, 100, 0),
(2, 'accessProfileGlobalReader', 'Read all projects', 4, 1, 1, 1, 150, 0),
(3, 'accessProfileRestrictedUpdater', 'Read and Update only his projects', 3, 1, 3, 1, 200, 0),
(4, 'accessProfileGlobalUpdater', 'Read and Update all projects', 4, 1, 4, 1, 250, 0),
(5, 'accessProfileRestrictedCreator', 'Read only his projectsnCan createnUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projectsnCan createnUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projectsnCan createnUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all pro[...]
MySQL a répondu :

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'


 
Posté : 04/12/2018 11:58 am
(@babynus)
Posts: 14952
Membre Admin
 

#1062 - Duplicata du champ '1' pour la clef 'PRIMARY'

sure your db is not empty.


 
Posté : 04/12/2018 12:07 pm
(@bassem)
Posts: 27
Active Member
Début du sujet
 

please find the attached file


 
Posté : 04/12/2018 12:14 pm
(@bassem)
Posts: 27
Active Member
Début du sujet
 

P.S : I use mysqlbackupandftp tool to backup my database
Maybe the settings are incorrect (please find attached file)


 
Posté : 04/12/2018 12:22 pm
(@babynus)
Posts: 14952
Membre Admin
 

check your dump.
Possible it starts with "use dbName" that positions on another db.


 
Posté : 04/12/2018 3:35 pm
Share:
Retour en haut