flandercan

I tried a few things and this worked, I split the file into 500k chunks by line although it takes some time to import them it does work the command i used was split --line-bytes=500k backup.sql file_.sql thanks paul

The guy has dropped his old server so we no longer have access to the db other than the huge backup...... thanks paul

Hi folks, I have made a backup of a freinds sql database from the phpmyadmin console. He doesnt have a shell access at all as its a hosted server, when i try to upload or restore the data i get the following error Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php From what i have read its because the backup.sql file is to big and some articles have advised to chop the file up and upload in chinks, well my question is, can i just chop the file up or does the file need header information at the top of each file..... or is there a better way??? thanks Paul

Its been a while since i solved this so ill jot it down if someone else has the same problem, I installed red hat 8 and the sql and php from the package manager. What i needed to do to get them talking was install the phpsql bit but had to boot from the cd and perform an upgrade, then find the module in the detailed software list and install that. Then it worked perfect. Paul

thanks i understand but im still not sure ? i have installed the RPM from the package list in RH8 should i remove the php and download source, compile it and then install it?? it seems long winded for somthing that should really be there as standard? thanks

Hello folks, I have installed apache and sql server, when i use an sql command from the php script i get an error Fatal error: Call to undefined function: mysql_connect() in /var/www/html/sqltest/sql.php on line 5 line five reads $link = mysql_connect( \"localhost\", $user, $pass); I am using RH8 and have installed all parts from the cd for apache and sql but it still seems as though mysql_connect is an undefined function, what have i missed out?? thanks Paul