mysql < text.sql import no worky via php

[Anon]

Hi, i\'m using a system call to mysqldump to create my_bak.sql which works great. then as the mysql manual dictates..

msyql --user --pass mydb < /fullpath/my_bak.sql;

also works great to import the data into the database, FROM THE COMMAND LINE (linux).. but when i wrap the command in a system(``) and try it via php.. it fails miserably.. (incedentally, can\'t get system to output error\'s either, guh) anybody else had this problem? I tried implicitly specifying --host, tried it with the -e source method.. everything. i\'m stumped. please sniff somebody help me. (raises gun to head)

[[deleted]]

When you use mysqldump in PHP, make sure you also tell it where to find mysqldump:

system('/path/to/mysqldump bladebla');

PS and those are quotes, not backticks.

[Anon]

mysqldump does work. reading the file back in is the problem.

tried: $error = system('/usr/local/bin/mysql --user= --password= db2 < $dir', $damn);

still doesn't work. changed backticks to quotes, still no luck. the only output i get is $damn = 1; database still empty.

is there another way to read a mysql dump into a database? I tried doing file($mysqlfile), and then while ( list( $line_num, $line ) = each( $sql_file ) ) {
$sqlquery .= $line;
}
$myQuery = $sqlquery;
$result = php_query($myQuery);

that didn't work either, lost connect to db everytime.

i would use mysqlimport, but that wants to import each table one at a time, not the whole db, and there's no coresponding mysql dump to output each table one at a time.

i know this must work all over the place, i've tried permissions, owners, everything. but nothing seems to work. any other suggestions? I even tried LOAD DATA INFILE but that too, wants table names.

d

[Anon]

woo hoo.. tried it with the path to mysql, and changed the single quotes back into backticks and success...

thanks vincent! KISS!