mySQL Imports stopped working
Posted by: kiernan7 (---.socal.res.rr.com)
Date: April 11, 2019 02:04AM

I have always been able to grab a snapshot of various websites (mostly Joomla websites) and drop them down onto my localhost WAMP. Now, however, the importing via PHPMyAdmin on the WAMP side always chokes on any line with an escaped apostrophe or quote mark. If I have a five records and only one of them has -- for example "O\'Rourke', I can only get it to work by replacing the \' with a backtick. But this isn't how it should work.

Is there a setting I need to change? I've looked all over for something and I can't find it.

This has ALWAYS worked in the past!

TIA.

-- John Kiernan

Options: ReplyQuote
Re: mySQL Imports stopped working
Posted by: RiggsFolly (Moderator)
Date: April 11, 2019 10:41AM

Hi John

We dont write phpMyAdmin, we dont maintain phpMyAdmin, we just distribute it.

See my signature block for links to all the relevant documentation. phpMyAdmin is in that set


Are you using the same version of MySQL locally as was used on the remote site?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.7 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 04/11/2019 10:46AM by RiggsFolly.

Options: ReplyQuote


Sorry, only registered users may post in this forum.