Jump to content


Photo

Importing Large size data into mysql


  • Please log in to reply
3 replies to this topic

#1 shakim

shakim
  • Members
  • Pip
  • Newbie
  • 7 posts
  • LocationMetro Detroit,MI,USA

Posted 01 August 2003 - 03:07 AM

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\"
"Knowledge Speaks but, Wisdom Listens"
www.shumonhakim.com

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 01 August 2003 - 06:37 AM

Take a look at LOAD DATA
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 shakim

shakim
  • Members
  • Pip
  • Newbie
  • 7 posts
  • LocationMetro Detroit,MI,USA

Posted 02 August 2003 - 11:04 PM

What is the difference between \"Load Data Infile\" and \"mysqlimport\"
"Knowledge Speaks but, Wisdom Listens"
www.shumonhakim.com

#4 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 03 August 2003 - 01:03 AM

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...ysqlimport.html
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users