php程序备份mysql数据库,PHP脚本备份MySQL数据库

修复MySQL备份脚本错误

最新推荐文章于 2022-07-21 17:10:30 发布

转载最新推荐文章于 2022-07-21 17:10:30 发布 · 138 阅读

文章标签：

#php程序备份mysql数据库

本文介绍了一位开发者使用PHP脚本备份MySQL数据库时遇到的问题。当从shell终端运行脚本时，出现权限拒绝错误，并将密码误认为数据库名。通过调整mysqldump命令中密码标志的语法解决了该问题。

I'm trying to write a PHP script to backup a MySQL database:

if ( $db_resource = mysql_connect($db_server, $db_username, $db_password, $db_newlink) )

{

if ( mysql_select_db( $db_name, $db_resource ) )

{

$backupFile = $db_name."_".date( "Y-m-d-H-i-s" ).".gz";

$command = "mysqldump --opt -h ".$db_server." -u ".$db_username." -p ".$db_password." ".$db_name." | gzip > ".$db_save_dir."/".$backupFile;

system( $command );

}

mysql_close( $db_resource );

When I run it from the shell terminal, I get this:

[stingray]$ php /[ABSOLUTE

PATH]/db_backup.php

Enter password: [I INPUT PASSWORD]

mysqldump: Got error: 1044: Access

denied for user

'[USERNAME]'@'208.113.128.0/255.255.128.0'

to database '[PASSWORD]' when

selecting the database

Okay, now what I really don't understand is why it is calling the database as my password. If I point my web browser at the file, it runs just fine. Does anyone know what I should be doing? Personally, I really don't care if it's PHP, Python, CGI, etc., just so long as it can run on an Apache server.

Thanks.

解决方案

The syntax for the password flag is different. Remove the space after the -p flag and give it another shot.