Found what appears to be the answer to this over at phpwizard.net.
http://phpwizard.net/phorum/search.php?f=1&search=magic_quotes&match=1&date=30&fldauthor=1&fldsubject=1
Apparently, you need to upgrade to version 2.1.0 of phpmyadmin AND you have
to enable magic_quotes in php.ini or in .htaccess like this:
If site is running PHP4:
php_flag magic_quotes_gpc on
If site is running PHP3:
php3_magic_quotes_gpc on
Hope this helps others.
kind regards,
bill
bill wrote:
> Importing table data with PHPAdmin always fails wherever a \ character
> appears in the data values.
>
> I create the table dump with PHPAdmin, but when I try to insert the data
> into a new database, it keeps failing with the following error:
>
> You have an error in your SQL syntax near 't blah blah blah.
>
> The actual data reads 'Well, it doesn\'t blah blah blah...'
>
> Any ideas or help would be appreciated.
>
> bill hollett
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
