jkkenzie Posted June 26, 2008 Share Posted June 26, 2008 Hi! when i export a database with text field that contain html codes like <p> , it causes my mysql to get errors when running the SQL to create tables. How can i export a database successfully without errors caused by html contents in the fields.? Thanks in advance. Joseph Quote Link to comment Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 Shouldn't matter... how are you exporting? Quote Link to comment Share on other sites More sharing options...
jkkenzie Posted July 1, 2008 Author Share Posted July 1, 2008 Sorry for replying late Am exporting as SQL file on notepad. then ill run SQL after pasting what is on the notepad. Regards, Joseph Quote Link to comment Share on other sites More sharing options...
fenway Posted July 2, 2008 Share Posted July 2, 2008 Am exporting as SQL file on notepad. Yes, but "how"? Quote Link to comment Share on other sites More sharing options...
jkkenzie Posted July 2, 2008 Author Share Posted July 2, 2008 -I open phpadmin of WAMP. -i select my database . - I click Export. -I Select SQL on the EXPORT PANE. - SQL options has below selected: SQL compatibility mode NONE -The Structure pane has below selected: Structure Add AUTO_INCREMENT value Enclose table and field names with backquotes - The Data pane has the blow selected: data Complete inserts Extended inserts Maximal length of created query Use hexadecimal for binary fields Export type INSERT -Compression = none -THEN i click "GO" _then i copy the result and save as notepad. _then i create new database with same name as source or alter the result as above to be same as the new database. _then i open my new database. _then i click SQL. _then i paste my notepad result to the (Run SQL query/queries on database mydatabasename) and click "Go" That is it. If there were html codes in my fileds , they would result in errors. thanks in advance. Regards, Joseph Quote Link to comment Share on other sites More sharing options...
fenway Posted July 2, 2008 Share Posted July 2, 2008 Could you post a few lines from the output? Quote Link to comment Share on other sites More sharing options...
jkkenzie Posted July 2, 2008 Author Share Posted July 2, 2008 Well, I guess i found a way out. I first of all i exported the structure then the structure plus data. It created my database quickly. Thanks for being there. Joseph Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.