importing large amount of data does not work

[steve]

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

[Jay Donnell]

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.

[steve]

"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