wplib-box icon indicating copy to clipboard operation
wplib-box copied to clipboard

Add MySQL incompatibility scanner before import

Open mikeschinkel opened this issue 7 years ago • 0 comments

We should write a MySQL compatibility scanner to use before attempting to import .SQL files based on the current DB server in use, and then provide feedback to user so they can get their solution resolved, sooner than later.

https://mariadb.com/kb/en/library/system-variable-differences-between-mariadb-and-mysql/ https://www.percona.com/sites/default/files/presentations/Differences-between-MariaDB-MySQL.pdf

https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ http://www.thecompletelistoffeatures.com/ http://blog.sqlyog.com/mysql-8-0-v-s-mariadb-comparison-database-roles/ https://modern-sql.com/blog/2018-04/mysql-8.0 https://www.slideshare.net/bytebot/mysql-features-missing-in-mariadb-server

https://github.com/xwb1989/sqlparser https://github.com/percona/go-mysql https://github.com/ruiaylin/sqlparser https://golanglibs.com/search?q=sqlparser&sort=top

mikeschinkel avatar Jul 31 '18 02:07 mikeschinkel