Peter, sorry to say, but I guess your data have gone to Nirvana.
> Is there any logs of the database commmands There is. It's called binlog (binäre update log), and you can turn it on by starting the server like mysqld --log-bin (or put log-bin in the [myslqd] section of your my.cnf / my.ini). This will log every command that changes data, and if you have an initial backup of your databases, you can restore your data with the backup file plus reissuing the commands in the binlog file (except for the last one, of course ;). > I was pretty stupid a accidently deleted a little too much from a table, > and I now I regret doing so.. if it's lost, it's lost, but if it isn't > that would be better... You can avoid this problem for the future by starting your mysql client with the --safe-updates option (or put this in your my.cnf/my.ini, in the [client] section). This will prevent problems arising from commands like 'update tbl set col=val' and 'delete from tbl' with no WHERE clause. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "peter a" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 9:28 AM Subject: restoring lost data > > > this may seem as a desperate questions, but is there anway to restore > deleted data from a table? Is there any logs of the database commmands > that for example sql-servere has, that can be used to rollback to the a > specific time and in that way restore the old content of a database. > > I was pretty stupid a accidently deleted a little too much from a table, > and I now I regret doing so.. if it's lost, it's lost, but if it isn't > that would be better... > > thanks. /peter a > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
