Why wont this code work??

[miles_rich]

why wont this code work.??

			echo "<center><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='000000'>Backup Databases.</font></center>";
			echo "<br><hr><br>";

			$today = date("YmdHis");      
			echo $today;      

			$query = "mysqldump aq_dbinfo > aq_dbinfo.$today";
			$result = mysql_query( $query) or die( "<center><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='FF0000'>Query failed</font></center>"); 
			echo "<center><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='000000'>Table - aq_retp </font><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='00FF00'>Created successfully.</font></center>"; 

[liljim]

It might help if you commented on the actual error you're receiving. You should put this into your code:

$result = mysql_query($query)
 or die("<center>
<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='FF0000'>
 Query failed. Mysql said: " . mysql_error() . "
 </font></center>");

and then come back and give us something useful to work off. 🙂

[miles_rich]

Query failed Mysql said: You have an error in your SQL syntax near 'mysqldump aq_dbinfo > aq_dbinfo.20020919112855' at line 1

[liljim]

Well, that's because mysqldump is a command line tool through shell. What you want to use is probably:

"select into dumpfile 'filename' [options]"

Start here >