Cancelled

Simple database installation help needed

****

$10 pay

****

I have a search engine database (all of the info to build the database is in a file called [url removed, login to view])

In order to install and build the database, I need to visit [url removed, login to view] on my web browser. The problem is because the [url removed, login to view] is so big and my hosting company does not let me increase the memory usage for webdata.php.

Can someone help me install [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] I'll pay you $10 via paypal).

(The error I get when trying to install [url removed, login to view] is:

" Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 79691776 bytes) "

Here is php code for [url removed, login to view]:

<HTML><HEAD>

<TITLE>Search Engine Builder Professional - Install Database</TITLE>

</HEAD>

<BODY>

<?php

include("[url removed, login to view]");

include("[url removed, login to view]");

$mysql=mysql_connect($host,$user,$password) or die("Can't connect to MySQL! <br>Error ".mysql_errno().": ".mysql_error());

$result=mysql_query("CREATE DATABASE IF NOT EXISTS $databasename",$mysql) or die("Can't create database "".$databasename.""! <br>Error ".mysql_errno().": ".mysql_error());

$result=mysql_select_db($databasename,$mysql) or die("Can't open database "".$databasename.""! <br>Error ".mysql_errno().": ".mysql_error());

printf("Create tables...<br>");

printf("... ...<br>");

$result=mysql_query("DROP TABLE IF EXISTS $tablewordname",$mysql) or die("Can't drop old table "".$tablewordname.""! <br>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.""! <br>Error ".mysql_errno().": ".mysql_error());

$result=mysql_query("DROP TABLE IF EXISTS $tabledataname",$mysql) or die("Can't drop old table "".$tabledataname.""! <br>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.""! <br>Error ".mysql_errno().": ".mysql_error());

printf("Add records to WordList...<br>");

printf("... ...<br>");

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<br>",$strWord);

printf("Error %d: %s<br>",mysql_errno(),mysql_error());

}

}

}

printf("Add records to IndexData...<br>");

printf("... ...<br>");

$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<br>",$arrFiles[$i][1]);

printf("Error %d: %s<br>",mysql_errno(),mysql_error());

}

}

mysql_close();

Skills: MySQL, PHP

See more: unsigned integer, simple file database, old database, need sql help, mysql memory engine, sql create database, memory engine, int size, integer word search, build php search engine, big w, pay someone paypal, web die, install database, import database, get sql help, fatal, database info, database html sql, database build, build database sql, fatal error paypal, mysql create database engine, simple continue, html webdata

About the Employer:
( 5 reviews ) Reno, United States

Project ID: #1163341

3 freelancers are bidding on average $30 for this job

webmagics

ready to start

$30 USD in 1 day
(47 Reviews)
6.2
chrisbg

Hello, please check your PMB.

$30 USD in 1 day
(21 Reviews)
4.3
MoonLightCdr

I can help you out

$30 USD in 0 days
(6 Reviews)
3.6