Portal Home > Knowledgebase > Articles Database > SQL Upload Issue
SQL Upload Issue
| Posted by MarkioE, 04-08-2008, 04:20 PM |
| I'm trying to upload a 15mb SQL file via PHPMYADMIN, and each time I try it takes ages loading and then I get the following error:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 118
Not really sure what's wrong, any ideas anyone?
|
| Posted by Steve_Arm, 04-08-2008, 04:23 PM |
| Yes it's too big and the script times out. Do you have shell access?
You can break it to smaller files too.
|
| Posted by MarkioE, 04-08-2008, 04:29 PM |
| Yes I do have shell access. I'm trying to think of a way to break it into smaller files, but nothing springs to mind.
|
| Posted by Steve_Arm, 04-08-2008, 04:40 PM |
| cd to mysql installation directory
bin/mysql -u username_here -p < path/to/sql.file
Don't forget, the script should have these statements before other queries start:
CREATE DATABASE IF NOT EXISTS database_name_here;
USE database_name_here;
|
| Posted by RBBOT, 04-08-2008, 04:59 PM |
| gzip it, upload the zip file, unzip it through shell access then run it.
|
| Posted by MarkioE, 04-08-2008, 05:20 PM |
| Thanks, this worked a dream!
|
Add to Favourites 
Print this Article
Also Read
