export the database using the following command
php cli/joomla.php database:export --folder=tmp/
the import the database with the following command
php cli/joomla.php database:import --folder=tmp/
Import completed
[ERROR] Error merging the structure for xvchc_contentitem_tag_map: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT_GENERATED,
type_idmediumint NOT NULL, UNIQUE KEY
uc_ItemnameTagid(' at line 1
Labels |
Added:
No Code Attached Yet
|
It works on my mariadb server (10.5.13) but fails on my mysql server (8.0.19)
please test joomla-framework/database#253 .
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-06-01 15:33:21 |
Closed_By | ⇒ | alikon |
Until there is a pull request to this repo I don't consider this even remotely resolved
up to you
I consider this issue closed as there is a PR, even if is it in a upstream repo
i'll re-invite you to test it
I was unable to reproduce issue. I got [OK] Import completed in 141 seconds.
System information
Windows 10
Joomla 4.1