maliary Posted August 26, 2008 Share Posted August 26, 2008 Hi guys, I just did an Import of a sql file about 350MB's in size, I used the command prompt for this. There was a reserved word that I placed back ticks on as I got an error in the process. I had to open up the sql file in note pad which took quite some time before searching and placing the back ticks which eventually corrected the situation. Now, If my db was 4GB's big this would have been extremely difficult to do. Is there a tool or some other way for making these corrections to .sql files with errors ? Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/ Share on other sites More sharing options...
Mchl Posted August 26, 2008 Share Posted August 26, 2008 Could you show an example of what the necessary corrections were? Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/#findComment-625778 Share on other sites More sharing options...
maliary Posted August 26, 2008 Author Share Posted August 26, 2008 The error was with the reserved word case, it did not have the back ticks to be `case`. So I opened the .sql file dump and made the change. Aside from opening files dumps in notepad. Is there another easier way for this ? Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/#findComment-625821 Share on other sites More sharing options...
PFMaBiSmAd Posted August 26, 2008 Share Posted August 26, 2008 Quote Is there another easier way for this Yes, alter your table and column names so that they are not reserved words. Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/#findComment-625866 Share on other sites More sharing options...
Mchl Posted August 26, 2008 Share Posted August 26, 2008 MySQL Administrator from MySQL GUI Tools package exports database with `ticks` all over the place. [edit] Now that I check, so does mysqldump... Anyways, avoiding reserved words is a good advice. Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/#findComment-625869 Share on other sites More sharing options...
fenway Posted August 26, 2008 Share Posted August 26, 2008 Quote Now, If my db was 4GB's big this would have been extremely difficult to do. Is there a tool or some other way for making these corrections to .sql files with errors ? You mean like sed? Link to comment https://forums.phpfreaks.com/topic/121367-accessing-sql-files-with-errors/#findComment-625992 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.