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]