PHP List, MySQL List
In my PHP environment, I have "Magic Quotes" turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in it.
Particularly, double and single quotes don't have slashes in front of them.
This seems to work fine so long as I'm reading data into and out of the
database from within my scripts.
However, when I backup and import databases - I use the phpMyAdmin
interface - they have escape slashes in front of every double and single
quote characters. I'm not sure if it's on the export or import where
they get added in.
I've looked through the phpMyAdmin online documentation, and I can't see
any option to control the presence of escape slashes. It seems to me
that if it adds them in when exporting, it should take them out when
importing. Or vice versa, but in either case be consistent.
I just want my database to be exactly as it is before any export or
import options.
I'm a little muddled as to where I'm making the mistake. Can anyone
advice on the best practice for preserving my database as is when
backing up and restoring?
Thanks for any advice.
--
Dave M G
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
