FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


got this error..





deluxetrade
i wanted to upload my database SQL file..
got this
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91

any help please....
foggy
That error is caused by the .sql file that you are trying to upload and execute is taking too long. The server has a maximum execution time of 300 seconds, as you can see from the error message. What I usually do is open the .sql file with a text editor and spit it into several parts. You must split it between the queries, so a very basic knowledge of SQL is required.
deluxetrade
how do you know where to split though....

please get back to me as i need this up and running
foggy
Here's an example. My comments are the ones surrounded by *****s
Code:
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 01, 2005 at 10:05 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `c30info_smf`
--

-- --------------------------------------------------------

--
-- Table structure for table `backup_smf_board_permissions`
--

*****As long as you don't split in the middle of a line, or in the middle of a create table function, you should be fine****

CREATE TABLE `backup_smf_board_permissions` (
  `ID_GROUP` smallint(5) NOT NULL default '0',
  `ID_BOARD` smallint(5) unsigned NOT NULL default '0',
  `permission` varchar(30) NOT NULL default '',
  `addDeny` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`ID_GROUP`,`ID_BOARD`,`permission`)
) TYPE=MyISAM;

--
-- Dumping data for table `backup_smf_board_permissions`
--

INSERT INTO `backup_smf_board_permissions` VALUES (-1, 0, 'poll_view', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'delete_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'lock_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'mark_any_notify', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'mark_notify', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'modify_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_add_own', 1);
******In between here there would be no problem. Again, just make sure you aren't splitting a line*****
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_edit_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_lock_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_post', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_view', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'poll_vote', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'post_attachment', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'post_new', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'post_reply_any', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'post_reply_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'remove_own', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'report_any', 1);
INSERT INTO `backup_smf_board_permissions` VALUES (0, 0, 'send_topic', 1);
.........etc........
deluxetrade
ill give it a try
thanks for the help

so i just need to upload the sql and then what else to create a backup of an old site...
Related topics
mysql base error please help
SQL error notification in my forum
SQL error on my site
Error 127 from PHPbb
Error on parsing smily pack, PhpBB
phpBB Critical Error when viewing and posting in forums
I suggest...
Admin: Please check my account. I have no more space
Hobbit
no confirmation
Need help with php script
Where is the WEB/STAT
URGENT! (fixed) (same problem again! not fixed)
Server 2 problem
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.