- Impact
- 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"
I log into mysql, I get this promt "MYSQL>" Now what do I type? My data file is located at "c:/data.sql"