shakim Posted August 1, 2003 Share Posted August 1, 2003 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\" Quote Link to comment Share on other sites More sharing options...
Barand Posted August 1, 2003 Share Posted August 1, 2003 Take a look at LOAD DATA Quote Link to comment Share on other sites More sharing options...
shakim Posted August 2, 2003 Author Share Posted August 2, 2003 What is the difference between \"Load Data Infile\" and \"mysqlimport\" Quote Link to comment Share on other sites More sharing options...
effigy Posted August 3, 2003 Share Posted August 3, 2003 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.