how to upload mysql database to my serverspace in programming

[neelsbr]

how to upload mysql database to my server space (hostgator,blue host) in programming method.any one can help me to do this.


Thanks in Advance

[code green]

Please supply the code you are trying

running test.php to execute a sql file

and the errors being returned that report an incorrect path

the path is not given correctly

[neelsbr]

<?php
 require_once('library/config.php');
 
$dbHost = 'localhost';
$dbUser = 'username';
$dbPass = 'password';
$dbName = 'dbname';
 
$today=date('Y/m/d');
 
$table=array('m_couponbook','m_discount','m_grade','m_kart','m_member','m_nonmember','m_publicholiday','m_rate','m_staff','t_billing','t_billingpenalty','t_cancelbilling','t_couponissue','t_duplicateaccesscard','t_groupbilling','t_groupbooking','t_memberattendance','t_memberpayment','t_raceallocation','t_raceevent','t_raceparticipation','t_performance','t_sponsorshipregistration','t_staffattendance');
 $count=count($table);
for($i=0;$i<$count;$i++)
{
 
$backupFile = "backup/$table[$i].sql";
$query      = "SELECT * INTO OUTFILE '$backupFile' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM `$table[$i]`";
$result = dbQuery($query);
 
}
 
/*$backupFile = $dbName . date("Y-m-d-H-i-s")  .'.gz';;
echo $command = "mysqldump --opt -h $dbHost -u $dbUser -p $dbPass $dbName | gzip > $backupFile";
system($command);*/
 
// hostname or ip of server
$servername='box.bluehost.com';
 
// username and password to log onto db server
$dbusername='username';
$dbpassword='password';
 
// name of database
$dbname='dbname';
 
////////////// Do not  edit below/////////
 
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
 
for($i=0;$i<$count;$i++)
{
$sql="TRUNCATE TABLE `$table[$i]`";
$res=mysql_query($sql);
 
//$file = fopen("../mysql/data/backup/$table[$i].sql","r")or exit("Unable to open file!");
 
//some code to be executed
//here i am getting sql files.this path has to be correct
echo $backupFile = "../backup/$table[$i].sql";
 
$load="LOAD DATA INFILE '$file' INTO TABLE `$table[$i]` FIELDS TERMINATED BY ','";
echo $result=mysql_query($load);
//fclose($file);
}
//passthru("nohup mysql -u $dbusername -p $dbpassword $dbname < $backupFile");
echo "success";
 
?>
 

this code i am using.i didn't get any error message for path not given correctly.i understood the path was not given correctly .so that only its not working .i already given the path,where my sql file stored.how can i access the files.

[code green]

I honestly don't understand your problem.

.i understood the path was not given correctly

If you know the path is wrong why don't correct it?

how can i access the files

Which files where?

I am guessing the SQL file is not being found, but then there would be an error message...
Try using full paths rather than relative