Import data into MySQL on my Mac.

Report · Jan 30, 2011

I have a list of books in an Excel spreadsheet (so I can export it as CSV etc.) and I would like to import them into a MySQL database, on my Mac (running Snow leopard 10.6.6).

In case it is important, the fields are:

Author, Title, Weight, Signed, Hardback, Condition, Genre

I am assuming that I will use terminal, type "mysql" and the go from there.

Can anyone help me? Do I have to create the table first and then load it in?

On my Windows machine I had a tool SQLite3.exe which was front end to MySQL. Is there anything like this for the Mac?

Report · Jan 31, 2011

Try Sequel Pro... that has an import option for CSV

Report · Jan 31, 2011

Actually, if you have a DB on a PC already, just export it from your MySQL administrator and then reimport it on your mac using MySQL administrator on the mac