Posted by apostolosl on 05/08/06 16:02

//DUMP DATA IN FILE
$command="mysqldump backcatalogue table_products > table_products.sql";
system($command);

//CONNECT TO REMOTE DATABASE
$command="mysql --host=$ohost --user=$ouser --password=$opass
--database=$odb;";
system($command);

//UPDATE REMOTE DATABASE FROM FILE
$command ="mysql source table_products.sql;";
system("command ") ;

END PHP CODE -->

• Next in forum: unique_key vs multiple_key
• Prev in forum: Re: Run mysql shell commands from PHP
• Thread view: Re: Run mysql shell commands from PHP

[Reply to this message]