MySQL Basics In Pictures
Sort results
  1. Right-click this link (Mac users, press the CTRL key while pressing the mouse button.):


    Save new_us_presidents.sql in your home directory on the computer:

  2. Open a terminal window and type:

    mysql -u root -p us_presidents < ./new_us_presidents.sql

    then press ENTER.

    This command string pipes the data from the file you just downloaded (new_us_presidents.sql) into the database us_presidents.