I am using a free web hosting service named as 000a.biz. While uploading/importing text files in my database, I keep on receiving Error #1064. I want to ask that how to deal with this error. My text files contain HTML tags too.
The error 1064 occurs due to Mysql version mismatch,because differnt versions have differnt reserved words,which if used by a previous version causes the error to occur. Let me know how you upload/import text files to/from your database.
I just click the "import" button and guide the server towards the text file in my computer and then hit the "GO" button. That's it. I know the problem is due to the reserved words. That's what I am asking that how to make sure that MYSQL differentiates between the text file's material and the reserved words used in SQL query. Because its too impractical to replace all the words in the article which are similar to the MYSQL reserved words. I hope I am not making this too complicated.
Hi, Are you using PHPmyAdmin to manage your databases? Is your database is hosted in a Linux environment? If it is, ask your host to take a backup of your database using mysqldump command. And then upgrade your database.