r_honey Posted March 22, 2008 Share Posted March 22, 2008 I backed-up my database from a Hosting server in the form of a Sql Script file. I want to analyze the DB on my local system. The script file is a bit large. When I try to import it using phpMyAdmin, the request times out after 300 seconds (but the import is still in progress). I am not sure whether Php is timing out the request, or it is MySql. Please help!!! (also which environment variable in Php or MySql ini file would I need to change)!!! Quote Link to comment https://forums.phpfreaks.com/topic/97337-backup-restore-time-out/ Share on other sites More sharing options...
mwasif Posted March 22, 2008 Share Posted March 22, 2008 You can use HeidiSQL or use MySQL's source command (the best option) or incease file size limit in PHP to support big sql files. Quote Link to comment https://forums.phpfreaks.com/topic/97337-backup-restore-time-out/#findComment-498271 Share on other sites More sharing options...
r_honey Posted March 23, 2008 Author Share Posted March 23, 2008 Thanx!!! I already googled & found SqlYoga, which did my job nicely. However, thanx for the reply. I have downloaded HeidiSql. It is small & fast. It might do my some other job some other time. And the Sql command line statement would also help. Quote Link to comment https://forums.phpfreaks.com/topic/97337-backup-restore-time-out/#findComment-498685 Share on other sites More sharing options...
mwasif Posted March 23, 2008 Share Posted March 23, 2008 I personally like HeidiSql and always recommend this. I always use command line statement when importing big (in GBs) sql files. Quote Link to comment https://forums.phpfreaks.com/topic/97337-backup-restore-time-out/#findComment-498697 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.