Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Request update of Adminer from current 4.7.7 to 4.8.1 #1593

Closed
EdNett opened this issue Nov 1, 2021 · 1 comment
Closed

Request update of Adminer from current 4.7.7 to 4.8.1 #1593

EdNett opened this issue Nov 1, 2021 · 1 comment

Comments

@EdNett
Copy link

EdNett commented Nov 1, 2021

Request update of Adminer from current 4.7.7 to 4.8.1 - (We are stuck with MariaDB 10.4.x for the moment)

We are running latest 4.1.4-dev of BOA and mariadb 10.4.21 with php 7.4.25 on both fpm and cli

Adminer 4.8.1 contains the following bug fixes - see thier changelog at:
https://github.com/vrana/adminer/blob/master/changes.txt :

MySQL: Do not export names in quotes with sql_mode='ANSI_QUOTES' (bug #749)
Quote values with leading and trailing zeroes in CSV export (bug #777)
Support function default values in insert (bug #713)
Allow SQL pseudo-function in insert
Skip date columns for non-date values in search anywhere
Add DB version to comment in export

Version 4.8.1 is also ready for php8 and mysql 8.

We are getting lots of errors trying to move D9 sites manually from one vps to another, when using adminer to overwrite a newly created db.

Please see other new issue #1594 (which has us using adminer to update db .tar file over existing db of newly created site, since extracting tar of sql backup on d9 sites doesn't just give us 1 .sql file, but many.).

Lastly - should we drop all the tables of the newly created db on the new vps, BEFORE importing the old .tar db dump boa creates nightly? Or can we just import it over the newly created db?

This method which has us overwriting only the files directory in the newly created site on teh new vps with the old files directory - is guaranteed to work, isn't it?

Thanks,

Ed

@omega8cc
Copy link
Owner

Fixed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants