User has exceeded the 'max_updates' resource (current value: 50000)

[uetac]

hello,

i’m updating my database : i have an sql file with something like 8000 lines like ‘INSERT INTO xxxx’.

I have done some tests in my database, it works fine until i have this message :
User has exceeded the ‘max_updates’ resource (current value: 50000)

well, is someone can explain me how to reset this limit or how to import sql insert lines properly with 000webhost ? The only way is using phpmyadmin to import csv data ?

thx for your answer

[anon36420230]

use 1-click database restore.

[000webhost]

Or import by phpmyadmin, it will not apply for imported by phpmyadmin

[sparnauskis]

It would be great to use phpMyAdmin, but …

Fatal error: Maximum execution time of 300 seconds exceeded in /home/mainhost/public_html/phpMyAdmin/libraries/import/sql.php on line 104

So folk has to workarround it using db updating scripts.

I faced the same problem - time limit using phpMyAdmin, or update limit using script.