7.9 -> 7.8 importing dataonly via myPHPadmin

💬 General Discussion
1

HI
I’ve been trying to get my updated database content back into 7.8 format db so I can get back to work.

I read you can transfer data via mySQL - using data and not tables.

In myPHPadmin, I exported the 7.9 as data only, the tried to import the data only into a 7.8 database (without any data in it)

Go the the following error: (Anyone have any suggestions on achieving this?)

MySQL said: Documentation

#1062 - Duplicate entry ‘9cd0f61d-a84c-130c-49ba-5907b5590278’ for key ‘PRIMARY’

SQL query:

–
– Database: upgraded-database-name

–
– Dumping data for table acl_actions

INSERT INTO acl_actions (id, date_entered, date_modified, modified_user_id, created_by, name, category, acltype, aclaccess, deleted) VALUES
(‘9cd0f61d-a84c-130c-49ba-5907b5590278’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’, ‘access’, ‘Leads’, ‘module’, 89, 0),
(‘9d2d0ca1-f1d8-77dd-7daf-5907b5a177d2’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’, ‘view’, ‘Leads’, ‘module’, 90, 0),
(‘a1439573-7406-28e7-8d0d-5907b5906896’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’, ‘list’, ‘Leads’, ‘module’, 90, 0),
(‘a19f70d7-c790-2af6-b887-5907b5aed7c1’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’, ‘edit’, ‘Leads’, ‘module’, 90, 0),
(‘a20137a1-c877-1544-a506-5907b5e20dc6’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’, ‘delete’, ‘Leads’, ‘module’, 90, 0),
(‘a25864f9-7023-d49f-2f3e-5907b5ca900c’, ‘2017-05-01 22:23:29’, ‘2017-05-01 22:23:29’, ‘1’, ‘’[…]

2

I guess a blank database is not 100% blank - it gets populated at install-time with some basic data. That seems to be the case for this table acl_actions.

Since it has the “id” field marked as a primary key it cannot allow repeated “ids”. My guess is that the data you’re trying to import is essentially the same as the data that is already there.

If I were you I’d just try leaving that table out of your import. At the end you can always go back if necessary and try to import the rows by deleting any previous rows with identical “ids”.

1 Like