CSV import & download XML file

Hi All,
I need to upload a very large business listing csv sheet but when i try using the current CSV import plugin i get this error: “The used command is not allowed with this MySQL version”.
Then i tried to use the “tools” tap to download the XML download file that is suggested in the video titled “Importing CSV Files” (https://www.youtube.com/watch?v=9mWID9hD4hI#t=190) ….but i cant find it on my theme and looked on the forum also couldn’t find it (my page is very different than the one on the video, i have images of the pages and i will upload if i can).
So I searched online for a csv importer and found this one: WP CSV to Database Plugin – Import Excel File Content into WordPress database (MySQL) URL: https://www.tipsandtricks-hq.com/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116/comment-page-1
so i was wondering if anyone has used this plugin already and can give me some feedback?
Also i have this question too: can i upload a whole csv sheet with many fields and thousands of business listing, to a single category? without setting up categories and subcategories?
i have also included a sample of my CSV sheet that i want to import.
Thanks!
Jay