Jump to content

Archived

This topic is now archived and is closed to further replies.

shakim

Importing Large size data into mysql

Recommended Posts

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\"

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.