jjk2 Posted January 13, 2009 Share Posted January 13, 2009 so i have one large 30mb .sql it has html codes in teh database. my mistake was that i didn't mysql_escape() the html codes before creating teh whole .sql the .sql is something like INSERT into "foods" VALUES ('1', '<html></something.....'), a long line of that. so how can i stick the 30mb into an array, and then parse, and replace the html with the mysql escaped html version ? this is a big file so, im not sure if my approach is teh best. Link to comment https://forums.phpfreaks.com/topic/140600-solved-i-have-a-large-sql-database-dump-that-needs-to-be-cleaned-up/ Share on other sites More sharing options...
trq Posted January 13, 2009 Share Posted January 13, 2009 How exactly was this file created and can we see an example of data that actually needs escaping? Link to comment https://forums.phpfreaks.com/topic/140600-solved-i-have-a-large-sql-database-dump-that-needs-to-be-cleaned-up/#findComment-735778 Share on other sites More sharing options...
jjk2 Posted January 14, 2009 Author Share Posted January 14, 2009 figured it out. one of the descriptions had 'Bob's new car' the 's was unescaped. did a simple replace with wordpad. solved. Link to comment https://forums.phpfreaks.com/topic/140600-solved-i-have-a-large-sql-database-dump-that-needs-to-be-cleaned-up/#findComment-737317 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.