Importing Large size data into mysql

[shakim 0]

am new a MYSQL. I have been using Access. Now, I am converting to MYSQL. I got a tool that takes a Access file and converts it to a dump file call \"filename.sql\" Now how do I import that into MYSQL? After logging into mysql what should I do next and what is the command to import this file? Also, I tried using PHPMYadmin. Because this is a huge file (50,000 records) it times out. So is there a way I can adjust the time so it doesn\'t time out. I want to learn how to do this both ways. via the command line and via phpmyadmin. thanx. Am example of the command line would be great.

 

I log into mysql, I get this promt \"MYSQL>\" Now what do I type? My data file is located at \"c:/data.sql\"

[Barand 1,231]

Take a look at LOAD DATA

[shakim 0]

What is the difference between \"Load Data Infile\" and \"mysqlimport\"

[effigy 0]

from mysql.com:

 

mysqlimport provides a command-line interface to the LOAD DATA INFILE SQL statement. Most options to mysqlimport correspond directly to the same options to LOAD DATA INFILE.

 

http://www.mysql.com/doc/en/mysqlimport.html