Hello.
What is the output of:
# /usr/local/mysql/bin/mysqlbinlog --database=backuptest
--start-datetime=2005-03-30 15:00:00 /data/mysql/logs/dbne1-bin.173
seth [EMAIL PROTECTED] wrote:
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
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]