i have a new apache2triad install, only used in localhost mode with no intention of setting it up as a internet connected web server with dns and such, purely so that i can learn more about the server side of things, and more about the config of apache, sql, and php etc, and develop scripts and test them away from my remote server. all is well as far as i can see and everything works apart from php mail not relaying on the server, but at the moment this is not a big issue.
what is giving me a headache is not being able to load my sql database using phpmyadmin. i have exported the sqldb on the live server, and have it on my local pc. i have increased the file upload size to cope with the db (5.7mb) and i have tried changing the max_execution_time = 600, but it still bombs at 300seconds. if i import a small db, everything seems fine and the import is a success.
the error i get is this [/color]Fatal error: Maximum execution time of 300 seconds exceeded in C:\apache2triad\htdocs\phpmyadmin\libraries\string.lib.php on line 91 [color=Red][color=Black] the db file im trying to import has some extra bits at the top of the file that are not in the file generated locally, and need to be removed before the local server will accept the file otherwise i get a [/color][/color] #1065 - Query was empty error. ....
[color=Black] this is the header from the remote server
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
by looking at the data contained in the tables i know that the db file is being processed correctly, but not to the end as it times out before it can finish.
anyone got any idea what i need to do to get myphpadmin to process the whole db file without having to split it into little bits, as i will be loading and dumping lots of db files of around the same size.
Users browsing this forum: No registered users and 1 guest
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
