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 Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/ Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 Shouldn't matter... how are you exporting? Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-575061 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 Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-578884 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"? Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-579921 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 Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-579965 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? Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-580031 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 Link to comment https://forums.phpfreaks.com/topic/112018-solved-exporting-database/#findComment-580141 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.