Below is my program that should upload a text file into my database. the File I am trying to upload to the database is about 308MB. When I try to run this program it seems to run fully through but when I look into the database I don't see anything added. so I added in the $db-> stuff to see what errors it will give and to make sure it connect to the database. 

```
<?php

set_time_limit(0); // unlimited max execution time

$username = "root";
$auth = 'i-have-removed-it';
$db = $db = new mysqli("localhost", $username, $auth, 'testdb');
if(mysqli_connect_errno())
{
    die("Connection could not be established");
}

print_r([
    "db->connect_errno1"        => $db->connect_errno,
    "db->connect_error1"        => $db->connect_error,
    "db->errno1"                => $db->errno,
    "db->error1"                => $db->error,
    "db->sqlstate1"            => $db->sqlstate,
    "db->info1"                => $db->info,
    "db->get_warnings1"        => $db->get_warnings(),
]);
$file = "./datafile_worldmap.txt";

$query = "load data infile '$file'
into table `World_Map`
character set ascii
fields terminated by '|'
lines terminated by '\r\n'
ignore 1 lines

(`GeoID`, `X`, `Y`, `Wood`, `Clay`, `Iron`, `Stone`, `Food`, `TerrainSpecificTypeID`, `TerrainCombatTypeID`, `RegionID`)
";

$result = $db->query($query);
print_r([
    "db->connect_errno2"        => $db->connect_errno,
    "db->connect_error2"        => $db->connect_error,
    "db->errno2"                => $db->errno,
    "db->error2"                => $db->error,
    "db->sqlstate2"            => $db->sqlstate,
    "db->info2"                => $db->info,
    "db->get_warnings2"        => $db->get_warnings(),
]);

$total_num_rows = $result->num_rows;

echo "The Results Are : <br>";

?>

```

**Output**

```
Array
(
    [db->connect_errno1] => 0
    [db->connect_error1] =>
    [db->errno1] => 0
    [db->error1] =>
    [db->sqlstate1] => 00000
    [db->info1] =>
    [db->get_warnings1] =>
)
Array
(
    [db->connect_errno2] => 0
    [db->connect_error2] =>
    [db->errno2] => 1045
    [db->error2] => Access denied for user 'User'@'%%%.%%%.%%%.%%%' (using password: YES)
    [db->sqlstate2] => 28000
    [db->info2] =>
    [db->get_warnings2] =>
)

```

**news error**

```
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator,
 <<email>> and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
<p>Additionally, a 500 Internal Server Error
error was encountered while trying to use an ErrorDocument to handle the request.</p>
</body></html>

```