By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

importing large amount of data does not work

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
"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.