Jump to content

Importing Large size data into mysql


shakim

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

Link to comment
https://forums.phpfreaks.com/topic/809-importing-large-size-data-into-mysql/
Share on other sites

Archived

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

×
×
  • Create New...

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.