备份:
C:\Documents and Settings\Administrator>mysqldump -u root -p --no-create-info em
is6_1 > d:a.sql(--no-create-info不导出创建表的信息)
恢复:
mysql -u root -p -f (-f遇到错误不停下来, 继续往下)
mysql> use database_name;
mysql> set names utf8; (或其他需要的编码)
mysql> source d:/a.sql (sql文件存放路径)
window下mysql install.bat
cd /d %~dp0
set MYSQL_HOME=%cd%
cd /d "%MYSQL_HOME%\bin"
mysqld --install mysql-all --defaults-file=%MYSQL_HOME%\mysql.conf
net start mysql-all
pause
uninstall.bat
net stop mysql
sc delete mysql
pause
如果需要启动两个mysql,需要在mysql.conf中配置不同的端口:
[mysqld]
...
port=3307
[client]
port=3307
...