Simple database installation help needed

$30-250 USD

Dibatalkan

Disiarkan

lebih dari 12 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran

**** $10 pay **** I have a search engine database (all of the info to build the database is in a file called [login to view URL]) In order to install and build the database, I need to visit [login to view URL] on my web browser. The problem is because the [login to view URL] is so big and my hosting company does not let me increase the memory usage for webdata.php. Can someone help me install [login to view URL] successfully so I can run the search engine on my site? I'll pay $10 via paypal. This job is simple but I do not know anything about databases/ php so I need your help. I CAN import databases via phpMyAdmin , but however since it is [login to view URL] I do not know how what to do after that (so if you tell me what steps to do, and we are successful in installing [login to view URL] I'll pay you $10 via paypal). (The error I get when trying to install [login to view URL] is: " Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 79691776 bytes) " Here is php code for [login to view URL]: <HTML><HEAD> <TITLE>Search Engine Builder Professional - Install Database</TITLE> </HEAD> <BODY> <?php include("[login to view URL]"); include("[login to view URL]"); $mysql=mysql_connect($host,$user,$password) or die("Can't connect to MySQL! Error ".mysql_errno().": ".mysql_error()); $result=mysql_query("CREATE DATABASE IF NOT EXISTS $databasename",$mysql) or die("Can't create database "".$databasename.""! Error ".mysql_errno().": ".mysql_error()); $result=mysql_select_db($databasename,$mysql) or die("Can't open database "".$databasename.""! Error ".mysql_errno().": ".mysql_error()); printf("Create tables... "); printf("... ... "); $result=mysql_query("DROP TABLE IF EXISTS $tablewordname",$mysql) or die("Can't drop old table "".$tablewordname.""! Error ".mysql_errno().": ".mysql_error()); $result=mysql_query("CREATE TABLE $tablewordname (Word varchar(50) NOT NULL, FileID int(10) NOT NULL, Count INTEGER UNSIGNED, INDEX (Word,FileID))",$mysql) or die("Can't create table "".$tablewordname.""! Error ".mysql_errno().": ".mysql_error()); $result=mysql_query("DROP TABLE IF EXISTS $tabledataname",$mysql) or die("Can't drop old table "".$tabledataname.""! Error ".mysql_errno().": ".mysql_error()); $result=mysql_query("CREATE TABLE $tabledataname (FileID int(10) NOT NULL AUTO_INCREMENT, FileName varchar(255), LastModified varchar(50), Title varchar(255), Keywords varchar(255), Description varchar(255), Text longtext, Size int(10), PRIMARY KEY (FileID), UNIQUE INDEX (FileID))",$mysql) or die("Can't create table "".$tabledataname.""! Error ".mysql_errno().": ".mysql_error()); printf("Add records to WordList... "); printf("... ... "); ini_set('max_execution_time',0); $iArrCount=count($arrHitInfo); for($w=0;$w<$iArrCount;$w++) { $iPos=strpos($arrHitInfo[$w],','); if($iPos==-1)continue; $strWord=substr($arrHitInfo[$w],0,$iPos); $strHitInfo=substr($arrHitInfo[$w],$iPos+1); $arrTmpPages=explode(",",$strHitInfo); if(count($arrTmpPages)%2!=0)continue; $iHalfCount=count($arrTmpPages)/2; for($k=0;$k<$iHalfCount;$k++) { $sql="INSERT INTO $tablewordname VALUES ("".$strWord."",".$arrTmpPages[$k*2].",".$arrTmpPages[$k*2+1].")"; $result=mysql_query($sql,$mysql); if(!$result) { printf("$w. %s ",$strWord); printf("Error %d: %s ",mysql_errno(),mysql_error()); } } } printf("Add records to IndexData... "); printf("... ... "); $iArrCount=count($arrFiles); for($i=0;$i<$iArrCount;$i++) { $sql="INSERT INTO $tabledataname VALUES (".$arrFiles[$i][0].","".$arrFiles[$i][1]."","".$arrFiles[$i][2]."","".$arrFiles[$i][3]."","".$arrFiles[$i][4]."","".$arrFiles[$i][5]."","".$arrFiles[$i][6]."",".$arrFiles[$i][7].")"; $result=mysql_query($sql,$mysql); if(!$result) { printf("$i. %s ",$arrFiles[$i][1]); printf("Error %d: %s ",mysql_errno(),mysql_error()); } } mysql_close();

Simple database installation help needed

$30-250 USD

$30-250 USD

Tentang projek

Ingin menjana wang?

Faedah membida di Freelancer

Tentang klien

Pengesahan Klien

Pekerjaan lain daripada klien ini

Pekerjaan serupa