Skip to main content
P
Peter_A__Forkes
Participating Frequently
January 30, 2011
Question

Import data into MySQL on my Mac.

  • January 30, 2011
  • 1 reply
  • 542 views

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?

This topic has been closed for replies.

1 reply

M
matthew stuart
Inspiring
January 31, 2011

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

M
matthew stuart
Inspiring
January 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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices