importing mysql data from text file format [Please help me urgent need]

#1 (**permalink**) 02-28-2008, 10:49 AM

hi to all
i am having one data.sql which occupied 50 MB when i trying to upload
it on my website .
i am getting a error message Timed out.the data.sql has 3,00,000
records. please help me
explain how i can upload

#2 (**permalink**) 02-28-2008, 10:49 AM

On 14 May 2007 06:14:38 -0700, mohamed.musammil@gmail.com wrote:

>hi to all
>i am having one data.sql which occupied 50 MB when i trying to upload
>it on my website .
>i am getting a error message Timed out.the data.sql has 3,00,000
>records. please help me
>explain how i can upload

Are you sure the problem comes from MySQL ?
What tools do you use ?
Exactly what error code do you get ? (can you copy/paste it ?)

#3 (**permalink**) 02-28-2008, 10:49 AM

mohamed.musammil@gmail.com wrote:
> hi to all
> i am having one data.sql which occupied 50 MB when i trying to upload
> it on my website .
> i am getting a error message Timed out.the data.sql has 3,00,000
> records. please help me
> explain how i can upload
>

if you're on the command line trying to import records from a file,
try this:

in my.ini or my.cnf file
Add something like somewhere inside off it :

max_allowed_packet=16M (or a larger number if need be)

and restart your server.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode