this script wont running.

[zgkhoo]

 <?php
include 'config.php';
include 'opendb.php';

$tableName  = 'person';
$backupFile = 'backup/person.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

there is no *.sql file appear in my folder after i running this script,why?

thanks..

 

[wildteen88]

That script will basically export all the data from the person table and put into the person.sql file within the backup folder

 

What is happening when you run the script?

[ignace]

shouldn't the file already exist before you can execute such queries? or maybe the file is created but instead in the sql folder

[zgkhoo]

That script will basically export all the data from the person table and put into the person.sql file within the backup folder

 

What is happening when you run the script?

 

just the file wont appear ....i cant find it at all in my /htdoc folder

[zgkhoo]

shouldn't the file already exist before you can execute such queries? or maybe the file is created but instead in the sql folder

 

backup//person.sql

should be inside a folder called backup rite?

i cant see any "backup" folder after running this script.

 

[zgkhoo]

*bump*

[rlindauer]

The directory has to exist first.

 

I would also try using the full path to the file, not a relative path.

[rajivgonsalves]

does it have the right path

[zgkhoo]

 <?php
include 'config.php';
include 'opendb.php';

$tableName  = 'person';
$backupFile = '/backup/person.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

i change to this also cant,

wat right path u meant?

 

[zgkhoo]

*bump*

[teng84]

try a plain and siple query to check where is the default destination of your file

 

try to use static value and dont use folder or dir just a text name to see how it work and where it goes

[zgkhoo]

try a plain and siple query to check where is the default destination of your file

 

try to use static value and dont use folder or dir just a text name to see how it work and where it goes

 

plain and siple query ?? how?

static value and dont use folder??how?

 

sorry i m a newbie