请教PHP中调用mysqldump备份数据库 不是吧,在CSDN里提的问题,好像没有一个有回复的.难首描述不够清楚,或问题太低级.郁闷啊. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个列子很好找的. 搜 在win2003下MySQL数据库每天自动备份 好像几乎没有拿windows做mysql服务器的. 尽量把MYSQL的安装路径写到环境变量里去;还有你的格式不正确,后台运行的时候事不可能让你输入密码的。所以不要有空格。以下是我的机器:exec('mysqldump -uroot -p123456 --opt -B test2 > c:\\test2.sql');test2.sql内容:-- MySQL dump 10.12---- Host: localhost Database: test2-- -------------------------------------------------------- Server version 5.1.17-beta-community-nt-debug-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Current Database: `test2`--CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test2` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `test2`;---- Table structure for table `branches`--DROP TABLE IF EXISTS `branches`;CREATE TABLE `branches` ( `bid` int(11) NOT NULL, `cid` int(11) NOT NULL, `bdesc` varchar(1000) NOT NULL, `bloc` char(2) NOT NULL, PRIMARY KEY (`bid`), KEY `cid` (`cid`), CONSTRAINT `branches_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `clients` (`cid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `branches`--LOCK TABLES `branches` WRITE;/*!40000 ALTER TABLE `branches` DISABLE KEYS */;INSERT INTO `branches` VALUES (1011,101,'Corporate HQ','CA'),(1012,101,'Accounting Department','NY'),(1013,101,'Customer Grievances Department','KA'),(1031,103,'N Region HO','ME'),(1032,103,'NE Region HO','CT'),(1033,103,'NW Region HO','NY'),(1041,104,'Branch Office (East)','MA'),(1042,104,'Branch Office (West)','CA'),(1101,110,'Head Office','CA');/*!40000 ALTER TABLE `branches` ENABLE KEYS */;UNLOCK TABLES; 问题已解决才看到回复!原来是-uroot -ppassword中间不能有空格不过还是要谢谢yueliangdao0608((深圳PHPER,MSN:[email protected])) 已给分. 好像几乎没有拿windows做mysql服务器的.无论是不是几乎,现在LZ有需求,这种答案真的。。哎。。 将mysql安装文件bin目录下的mysqldump.exe可执行文件复制到与dbbak.php文件的同一级目录下。 高手帮我看下这个代码,请帮忙注释下,谢谢! 网站惊爆安全漏洞,请PHP安全高手进来帮忙测试…… 表单中多个按钮 怎么实现? 求救关于move_uploaded_file() 怎样用php输出尖括号 时隔多日,又要做起php来了,散分 php用socket发送邮件 checkbox的问题! 在线编辑器在smarty模板中的输出,求解? 如何从asp中向php中传递变量 php中调用文本编辑器 如何制定PHP学习计划
还有你的格式不正确,后台运行的时候事不可能让你输入密码的。所以不要有空格。
以下是我的机器:
exec('mysqldump -uroot -p123456 --opt -B test2 > c:\\test2.sql');test2.sql内容:-- MySQL dump 10.12
--
-- Host: localhost Database: test2
-- ------------------------------------------------------
-- Server version 5.1.17-beta-community-nt-debug-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;--
-- Current Database: `test2`
--CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test2` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `test2`;--
-- Table structure for table `branches`
--DROP TABLE IF EXISTS `branches`;
CREATE TABLE `branches` (
`bid` int(11) NOT NULL,
`cid` int(11) NOT NULL,
`bdesc` varchar(1000) NOT NULL,
`bloc` char(2) NOT NULL,
PRIMARY KEY (`bid`),
KEY `cid` (`cid`),
CONSTRAINT `branches_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `clients` (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
-- Dumping data for table `branches`
--LOCK TABLES `branches` WRITE;
/*!40000 ALTER TABLE `branches` DISABLE KEYS */;
INSERT INTO `branches` VALUES (1011,101,'Corporate HQ','CA'),(1012,101,'Accounting Department','NY'),(1013,101,'Customer Grievances Department','KA'),(1031,103,'N Region HO','ME'),(1032,103,'NE Region HO','CT'),(1033,103,'NW Region HO','NY'),(1041,104,'Branch Office (East)','MA'),(1042,104,'Branch Office (West)','CA'),(1101,110,'Head Office','CA');
/*!40000 ALTER TABLE `branches` ENABLE KEYS */;
UNLOCK TABLES;
原来是-uroot -ppassword中间不能有空格
不过还是要谢谢yueliangdao0608((深圳PHPER,MSN:[email protected]))
已给分.
无论是不是几乎,现在LZ有需求,这种答案真的。。哎。。