views:

25

answers:

3

how can I remove the time limit for the import operation in phpmyadmin ?

I'm not able to upload a big database because of the limit and I have to login again in the database.

Thanks

+1  A: 

you shouldn't use phpmyadmin to upload big databases... use console mysql/mysqldump.

but you can chenge max_execution_time parameter in your php.ini if you really want to

kgb
A: 

Try out mysqldumper

Roland Soós
A: 

I use MySQL BigDump

Worked well for me yesterday!

Liam Spencer
I think it worked great. I'm only a bit scared about 1 thing: I've exported (downloaded) the new database to see if it has the same size of the original one. Well, it is 15.4 instead of 15.5 (I think it is ok, but shouldn't it be exactly the same number ? (On the same operating system and size field) ?
Patrick
Did you get any error messages using BigDump when you executed the script? If you didn't, it should not be a problem.
Liam Spencer
ok cool, thanks!
Patrick
No problem, post here if you have any problems with it!
Liam Spencer