下面是自动备份的代码:
@ECHO OFF
for /f "Tokens=1 Delims=/ " %%i in ('date /t') do set dt=%%i
for /f "Tokens=1" %%i in ('time /t') do set tm=%%i
set tm=%dt%_%tm::=时%分SET bkupdir=E:\...
SET mysqldir=E:\...SET dbname=dbname
SET dbuser=root
SET dbpassword=root
SET CharacterSet=gb2312
SET host=127.0.0.1
@ECHO Beginning backup of %dbname%...mysqldump -B %dbname% -h%host% -u%dbuser% -p%dbpassword% --default_character-set=%CharacterSet% --opt>%bkupdir%\dbBkup_%dbname%_%tm%.sql
@ECHO Done! New File: %bkupdir%\dbBkup_%dbname%_%tm%.sql
rem dbBkup_ddd_2005-11-11_14时28分.sql pause这段代码可以实现备份,但是我有下面的问题:
现在备份的文件的例子如下
DROP TABLE IF EXISTS table1;
CREATE TABLE table1 ( ...如果用mysql自己的导出按钮进行备份的话,导出的文件在表名称的两侧都加了符号"`",也就是
DROP TABLE IF EXISTS `table1`;
CREATE TABLE `table1` ( ...如果让自动备份代码导出的表名称两侧也加上符号"`",怎么修改可以实现?
@ECHO OFF
for /f "Tokens=1 Delims=/ " %%i in ('date /t') do set dt=%%i
for /f "Tokens=1" %%i in ('time /t') do set tm=%%i
set tm=%dt%_%tm::=时%分SET bkupdir=E:\...
SET mysqldir=E:\...SET dbname=dbname
SET dbuser=root
SET dbpassword=root
SET CharacterSet=gb2312
SET host=127.0.0.1
@ECHO Beginning backup of %dbname%...mysqldump -B %dbname% -h%host% -u%dbuser% -p%dbpassword% --default_character-set=%CharacterSet% --opt>%bkupdir%\dbBkup_%dbname%_%tm%.sql
@ECHO Done! New File: %bkupdir%\dbBkup_%dbname%_%tm%.sql
rem dbBkup_ddd_2005-11-11_14时28分.sql pause这段代码可以实现备份,但是我有下面的问题:
现在备份的文件的例子如下
DROP TABLE IF EXISTS table1;
CREATE TABLE table1 ( ...如果用mysql自己的导出按钮进行备份的话,导出的文件在表名称的两侧都加了符号"`",也就是
DROP TABLE IF EXISTS `table1`;
CREATE TABLE `table1` ( ...如果让自动备份代码导出的表名称两侧也加上符号"`",怎么修改可以实现?
哎!!MYSQL如何自动备份啊,楼主你的这段代码怎么运行啊?这属于什么代码呀?