Suppose you take hourly backups and you loose data in between backups. You can restore the most recent backup, but you will still miss data... in this article I'll explain how you can use the binlogs to restore what you lost.
I'm in a sharing mood today, so let me post a link I discovered while looking for some informix sysmaster queries.
timestamp, data types, database
The TIMESTAMP datatype in MySQL has some nice features which aren't well known. It's a datatype used to store a date-and-time value.
If you try to use dbaccess on the command line, it might not work properly if your TERM is configured badly.
I recently encountered a problem where we had accidentally created a new database in the root dataspace. We only found out about this after receiving a lot of out-of-space errors. Here is how we moved it to the proper dbspace.
Jeroen Keppens - Amazium bvba
Mgr. Bermijnstraat 12, 9170 Sint-Gillis-Waas, Belgium
jkeppens
+32 475 62.42.64