Is it possible to make a php file that would run a bunch of sql queres from your database backed up text file. so like it runs one line of it at a time every 1/4 of a second. Im sick of the MyPhpAdmin ... they have that 2.1mb file limit.

That's not a limitation of phpMyAdmin, that is a serverwide PHP setting and you will hit that limit with any PHP script.

How is the file generated? Try compressing the file or gzipping the file when it is created. This should make the file a bit smaller.


Another option would be to manually FTP the file to the server and have a PHP script that processes the file at that point. The txt file is nothing more then a bunch of SQL statements, you can write a script that reads in the file and then executes the statements.

My database is 30MB. And I dont like copy and pasteing chunks of code at a time, i want a php script to do this for me, and it is generated as a normal text file.

Originally Posted by Anacrusis

That's not a limitation of phpMyAdmin, that is a serverwide PHP setting and you will hit that limit with any PHP script.

How is the file generated? Try compressing the file or gzipping the file when it is created. This should make the file a bit smaller.


Another option would be to manually FTP the file to the server and have a PHP script that processes the file at that point. The txt file is nothing more then a bunch of SQL statements, you can write a script that reads in the file and then executes the statements.

thats wat i want to do, but im having problems doing it, how do i pull one line at a time.

I had to do this myself recently and found this:
http://lars.targetit.ro/index.php?pa...try&post_id=36

Let me know if it helps... it helped me.

so theres nothing like this out there, like a quick fix.