Re: Export from a spreadsheet to mysql

[Peter Lavin]

To export all the tables in a database as tab-separated files do this:

mysqldump -u username -p -T /directory_name db_name

Data for each table will be stored in a file named "table_name.txt" in the "directory_name" directory. The appropriate table file can be imported into a spreadsheet programme. Some programmes, like OpenOffice Calc, require that you first change the file extension to "csv" before importing.