Incremental DB backups

2001-03-20 Thread Shane Gentry
I am trying to figure out how to use the binary log for incremental backups. I have read the section for this in the manaul but I have not been able to get it to work. My main problem is I don't know the exact command to use or exactly how the process works. Any suggestoins on how to set this u

How do you rerun updates in the binary/update log?

2001-03-21 Thread Shane Gentry
I am trying to figure out how to do this so I can do incremental backups. Any ideas would be appreciated. Thanks, Shane __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

Need help with restoring DB with binary log?

2001-03-23 Thread Shane Gentry
I am trying to restore my database using the binary log. I have restored the last full backup and want to rerun the updates from that point. I have tried running this command (mysqlbinlog log-file | mysql -h server_name), which is shown in the manual but it doesn't seem to work. Any suggestions

Database Index Question

2001-04-26 Thread Shane Gentry
Does it help to put an Index on a column when you use a LIKE query. ex. SELECT * FROM users WHERE name LIKE '%tom%' Thanks in Advance! __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/