.csv files are simply comma separated values. It's a popular export method for a lot of Windows-based programs like Excel, Access, and MySQL.
I've gone through the work before of exporting entire tables from MySQL into .csv, opening them in Excel, adding a blank column before all the information, and then using it to write queries. From there, I just copy the whole deal into a text file, save it as a .sql file, and source it in. So for most tables that are just simple integers or text, that would work for you, though it'd take some work. I have no idea how you'd handle anything like the player profile or blobs.
|