Why phpmyadmin doesn't notice me that it reaches the maxmium php execution time?

Question

I'm using phpmyadmin to export one of my database. And it was huge ( larger than 1 GiB ) And export procedure ended because of the PHP had run 360 seconds ( maxmium execution time ) and was killed while I thought that the backup file was correct and complete.

Later, I want a rollback. I drop the old database. And I import the backup sql file.

And

My data are partially lost.

Why phpmyadmin doesn't notice me??? I'm really ******* angry.

possible duplicate of [How to solve time out in phpmyadmin?](http://stackoverflow.com/questions/16707532/how-to-solve-time-out-in-phpmyadmin) — karel, Feb 27 '15 at 19:40
when uploading there do is an out of time error, but downloading has not. — march1993, Mar 04 '15 at 13:48

score 0 · Answer 1 · answered Feb 27 '15 at 20:39

0

For databases huge like that phpMyAdmin is not the best solution. Better use shell command to dump/import database. Under linux (most likely you are on linux)

mysqldump -u username -p database_name > dump_file_name.sql

Copy it, i.e. with FTP to other server and then import like:

mysql -u username -p  database_name < dump_file_name.sql

After "-p" you can immediately put your password, but you can also skip it and you'll be asked to enter it.

answered Feb 27 '15 at 20:39

MilanG

6,994
2
35
64

I know that. I swear I'll not use phpMyAdmin to backup huge databased any more. At least it should tell me that procedure is not finished! – march1993 Feb 28 '15 at 05:22

Why phpmyadmin doesn't notice me that it reaches the maxmium php execution time?

1 Answers1