Thursday, 8 August 2013

save mysql data to sql file using php, ready to import into sqlite

save mysql data to sql file using php, ready to import into sqlite

I have a script that generates a sql file from the data saved in a mysql
database. The data is stored in the mysql database without any added
slashes. This all works fine except for quotes. If there is a quote in the
mysql data then it stops the script from running. I have tried adding
slashes to the data that is extracted and put into the sql file, but this
doesn't work.. Is there a correct procedure to do this, or a better way to
get data from mysql into sqlite?

No comments:

Post a Comment