Hi team,
As seen on Stackoverflow[1], there's a bit of a syntax problem when importing from MySQL to MariaDB in that MariaDB doesn't seem to accept \''
Just checking, this doesn't seem to me like anything we can control nor like anything we should check for, but what do you think?
~Isaac
1 - http://stackoverflow.com/questions/33742398/website-migration-phpmyadmin-exp...
Le 2015-11-17 08:54, Isaac Bennetch a écrit :
Hi team,
As seen on Stackoverflow[1], there's a bit of a syntax problem when importing from MySQL to MariaDB in that MariaDB doesn't seem to accept \''
Just checking, this doesn't seem to me like anything we can control nor like anything we should check for, but what do you think?
~Isaac
1 - http://stackoverflow.com/questions/33742398/website-migration-phpmyadmin-exp...
Note that the problem is confirmed on MariaDB 5.5.44. I will try on a more recent MariaDB server as soon as possible.
Le 2015-11-17 11:29, Marc Delisle a écrit :
Le 2015-11-17 08:54, Isaac Bennetch a écrit :
Hi team,
As seen on Stackoverflow[1], there's a bit of a syntax problem when importing from MySQL to MariaDB in that MariaDB doesn't seem to accept \''
Just checking, this doesn't seem to me like anything we can control nor like anything we should check for, but what do you think?
~Isaac
1 - http://stackoverflow.com/questions/33742398/website-migration-phpmyadmin-exp...
Note that the problem is confirmed on MariaDB 5.5.44. I will try on a more recent MariaDB server as soon as possible.
On the demo server running MariaDB 10.0.21, this works:
INSERT INTO `t1`(`c1`) VALUES ('<a href=\''http://domain.com/wp-login.php%5C%5C'' >Please login to download</a>');
On 11/17/15 3:28 PM, Marc Delisle wrote:
Le 2015-11-17 11:29, Marc Delisle a écrit :
Le 2015-11-17 08:54, Isaac Bennetch a écrit :
Hi team,
As seen on Stackoverflow[1], there's a bit of a syntax problem when importing from MySQL to MariaDB in that MariaDB doesn't seem to accept \''
Just checking, this doesn't seem to me like anything we can control nor like anything we should check for, but what do you think?
~Isaac
1 - http://stackoverflow.com/questions/33742398/website-migration-phpmyadmin-exp...
Note that the problem is confirmed on MariaDB 5.5.44. I will try on a more recent MariaDB server as soon as possible.
On the demo server running MariaDB 10.0.21, this works:
INSERT INTO `t1`(`c1`) VALUES ('<a href=\''http://domain.com/wp-login.php%5C%5C'' >Please login to download</a>');
Thanks, Marc.
-
Isaac Bennetch -
Marc Delisle