使用Mysqlbinlog工具,利用二进制文件恢复数据库时,出现下面错误:
mysqlbinlog MYSQL_LOG.00001 | mysql -uroot -proot first
错误为:mysqlbinlog: File 'MYSQL_LOG.OOOO1' not found (Errcode: 2)
我的MY.ini配置如下:
[mysqld]
log-bin=LOG/MYSQL_LOG
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/"
希望牛人指教。
mysqlbinlog MYSQL_LOG.00001 | mysql -uroot -proot first
错误为:mysqlbinlog: File 'MYSQL_LOG.OOOO1' not found (Errcode: 2)
我的MY.ini配置如下:
[mysqld]
log-bin=LOG/MYSQL_LOG
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/"
希望牛人指教。
我把MY.INI 中log-bin设置成log-bin=C:/LOG/MYSQL_LOG
然后mysqlbinlog c:/LOG/MYSQL_LOG.00001 | mysql -uroot -proot first
同样出现:mysqlbinlog: File 'c:/LOG/MYSQL_LOG.OOOO1' not found (Errcode: 2)
去这个目录执行你的语句