MySQL Forums
Forum List  »  Newbie

Re: escaped character problem
Posted by: Peter Brawley
Date: October 07, 2018 03:27PM

You said there is "something wrong with the settings of my MySql". I asked how you inferred that. In response you posted my.cnf file contents. Well, what in those files leads you to think there is something wrong with your MySQL settings?

> I applied double the quotes trick to the entries that gave problems

What is a "double the quotes trick"?

Please post a SELECT result for the table row containing the column value


I looked into the mysql error log and I found hundreds of entries like this:
[Sun Oct 07 18:40:46.234657 2018] [core:error] [pid 16752:tid 2856221504] [client] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.

That text appears to from a PHP or Apache error file.

To eliminate as many confounding variables as possible, please run this simple little test script through your mysql client ...

create schema if not exists testdump;
use testdump;
drop table if exists test;
create table test( str varchar(128) );
insert into test set str='\'s-Heerenberg';
select * from test;

... then exit the mysql client and run ...

mysqldump -uYUSERNAME -pPSWD testdump test

... (substituting your MySQL username & pswd) to ensure that mysqldump faithfully reproduces SQL for the test table. Then run the same script redirecting mysqldump to a file, and import that file to ensure that it's imported correctly. Let us know what happens.

Options: ReplyQuote

Written By
October 02, 2018 08:37AM
October 02, 2018 09:59AM
October 02, 2018 01:03PM
October 02, 2018 02:30PM
October 04, 2018 06:36AM
October 04, 2018 08:22AM
October 07, 2018 02:05PM
Re: escaped character problem
October 07, 2018 03:27PM
October 02, 2018 02:14PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.