469,602 Members | 1,798 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

importing large amount of data does not work

Hi, I have researched but have not found a good solution to this
problem.

I am importing large amounts of data (over 50 Meg) into a new mysql db
that I set up. I use
mysql dbname < importfile.txt

But I keep getting timeouts and errors due to the data being too
large. I know that since if I break the imported data into multiple
chuncks (by importing a few tables at a time) then everything works.

Any advice is appreciated. Running on Linux.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-import...ict139853.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=467833
Jul 20 '05 #1
2 2416
I can import files larger than that without any problems on linux. How
does it time out and what errors are you getting?

steve <Us************@dbForumz.com> wrote in message news:<41********@news.athenanews.com>...
Hi, I have researched but have not found a good solution to this
problem.

I am importing large amounts of data (over 50 Meg) into a new mysql db
that I set up. I use
mysql dbname < importfile.txt

But I keep getting timeouts and errors due to the data being too
large. I know that since if I break the imported data into multiple
chuncks (by importing a few tables at a time) then everything works.

Any advice is appreciated. Running on Linux.

Jul 20 '05 #2
"Jay Donnell" wrote:
I can import files larger than that without any problems on linux. How does it time out and what errors are you getting?

steve <Us************@dbForumz.com> wrote in message
news:<41********@news.athenanews.com>...
Hi, I have researched but have not found a good solution to this
problem.

I am importing large amounts of data (over 50 Meg) into a new

mysql db
that I set up. I use
mysql dbname < importfile.txt

But I keep getting timeouts and errors due to the data being too
large. I know that since if I break the imported data into

multiple
chuncks (by importing a few tables at a time) then everything

works.

Any advice is appreciated. Running on Linux.</font>


Thanks. Next time I do an import, I will report the error. But
generally it says something like scripted timed out.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-import...ict139853.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=470402
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by rodchar | last post: by
5 posts views Thread by hharriel | last post: by
7 posts views Thread by =?Utf-8?B?TW9iaWxlTWFu?= | last post: by
16 posts views Thread by Jack | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.