Create backup mySQL SQL 2005
Good day for all Techyv users.
I am about to receive a lot of data out mysql SQL 2005 with my new contract in my online based job. I was advised to use backup but it cannot create valid csv. I cannot deal with any row that has a string with comma in it since strings do not express the essentials of csv and csv does not tell anything about data types.. My head bangs for this. Is there a tool that can connect both SQL and mysql server and then execute the copy? Will I find it hard to simulate a table from one database to another?
Let's say the mysql SQL 2005? I hope anybody knows such tool. It doesn’t matter what simplifications will occur as long as it will support integer and string. I need the set of data to be faster that would limit pruning and normalizing.