Importing and Exporting MySQL Databases Using PHP on easyphp -

Importing and Exporting MySQL Databases Using PHP on easyphp -

i want importing , exporting mysql databases using php

i on localhost , utilize easyphp

i have seek code

<?php //enter relevant info below $mysqldatabasename ='naql'; $mysqlusername ='root'; $mysqlpassword =''; $mysqlexportpath ='choosefilenameforbackup.sql'; //do not edit below line $mysqlhostname ='localhost'; //export database , output status page $command='mysqldump -u' .$mysqlusername .' -s /kunden/tmp/mysql5.sock -p' .$mysqlpassword .' ' .$mysqldatabasename .' > ~/' .$mysqlexportpath; exec($command,$output=array(),$worked); switch($worked){ case 0: echo 'database <b>' .$mysqldatabasename .'</b> exported <b>~/' .$mysqlexportpath .'</b>'; break; case 1: echo 'there warning during export of <b>' .$mysqldatabasename .'</b> <b>~/' .$mysqlexportpath .'</b>'; break; case 2: echo 'there error during export. please check values:<br/><br/><table><tr><td>mysql database name:</td><td><b>' .$mysqldatabasename .'</b></td></tr><tr><td>mysql user name:</td><td><b>' .$mysqlusername .'</b></td></tr><tr><td>mysql password:</td><td><b>notshown</b></td></tr><tr><td>mysql host name:</td><td><b>' .$mysqlhostname .'</b></td></tr></table>'; break; } ?>

but it's not working @ all. error

strict standards: variables should passed reference in c:\program files\easyphp-devserver-14.1vc9\data\localweb\projects\1na9liyat\admin lab rtl template\databasephp.php on line 13 there warning during export of naql ~/choosefilenameforbackup.sql

welcome so.

this problem more php question mysql-problem. have run dump-command php? might want run mysqldump straight command-line.

if have myisam tables can re-create 3 files of table (.frm, .myd, .myi) create backup of table.

php mysql