hello,
I'm trying to restore a table from a full back up and then a binlog. this is a test table setup specifically for this. I have 34 rows in the full backup, another 5 in the binlog. I find the date of the last insert and use this as the --start-datetime for mysqlbinlog. The problem is that I always get the same error "error: table foo already exists". Shouldn't it just be updating from the start-datetime and not trying to create/drop the already existing table? Sorry if this is a simple one, been searching for this for awhile now.
# /usr/local/mysql/bin/mysqlbinlog --database=backuptest --start-datetime="2005-03-30 15:00:00" /data/mysql/logs/dbne1-bin.173 | /usr/local/mysql/bin/mysql -u seth -p backuptest
Enter password:
ERROR 1050 at line 10046: Table 'foo' already exists
thanks.
-seth
--
Seth Itschner
SparkNotes
[EMAIL PROTECTED]
V: (212) 633-3555
F: (212) 727-4827
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
