MySQL...is getting me

[Porte]

Hi guys, I'm trying to import a file to mysql database..and this is what I get after 30minutes

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/sqlparser.lib.php on line 307

 

[shakez]

How 'big' is the file? (both file size and possibly rows)

 

[Porte]

5mb

 

[shakez]

I've had troubles before like that ... is there any way to split the file into 2 or 3 files?

 

[J_Ronaldo_19]

i think i could get some use out of this question, but how do you do that ?

 

[shakez]

Well it all really depends on what you are 'inserting' into the database ... i tried inserting a CSV file that was about 25k rows and ... well ... lets say MySQL hated me So then I just opened it up in Excel, split it into 5 5k row CSV files and it worked fine.

 

[Porte]

I don't know how to split this file though.

 

[shakez]

Hmm ... that would be a problem ... its tough to know exactly what to say ... is it split into rows? so each row is a new entry?

 

[Porte]

Yes, exactly..

 

[shakez]

Is the data already in CSV format (comma delmited?)? If so, all you need to do is import it into Excel and then copy x amount of rows onto a new spreadsheet, etc. and then just import them all individually ... make sense?

 

[labrocca]

Can you get ssh access? If so you can simply import with mysqladmin in about 30 seconds. phpmyadmin blows

 

[Porte]

It makes sense..but I don't use Excel..any free splitter out there?

No, I don't have ssh

 

[dgaussin]

Very bad because it's really the best way to import large mysql database backup. If you can, ask SSH access to your host, even temporary. Or ask your host to do the import for you. It's quick to do...

 

[Porte]

My host cannot do this, so?

I'll try to split it manually

 

[labrocca]

Can you send them the sql and ask that they execute it into your database? It takes like 10 seconds!

Or you can ask them to change the timeout from 300 seconds to 1800. 1800=15 minutes. I hate hosts.

 

[Porte]

Well, I found a free software called filesplitter, gonna use it to split this db..

 

[gamex]

Try this:

http://www.ozerov.de/bigdump.php

 

[Porte]

Thanks gamex!

Thanks guys, I uploaded the file successfully..