Re: Site Attack/Failure Recovery

tements in MySQL's binary log to recover "from the time of the last BACKUP DATABASE statement", "to the time that the database loss occurred". In other words ... Careful Use of Online Backup will protect from database loss. Rob Wultsch wrote: On Wed, May 14, 2008

Re: Site Attack/Failure Recovery

ed, May 14, 2008 at 11:13 PM, John Comerford <[EMAIL PROTECTED]> wrote: Quickly scanning this page, it doesn't seem to give syntax for an incremental backup. I am hoping to be able to run something that dumps only data changed since the last backup. You could use diff and

Re: Site Attack/Failure Recovery

Quickly scanning this page, it doesn't seem to give syntax for an incremental backup. I am hoping to be able to run something that dumps only data changed since the last backup. Rob Wultsch wrote: On Wed, May 14, 2008 at 10:25 PM, John Comerford <[EMAIL PROTECTED]> w

Site Attack/Failure Recovery

Hi Folks, I am fairly new to MySQL and I am going to be setting up a web site on a third party hosting machine. I continuously hear horror stories about machines/sites being hacked and databases being destroyed. Despite my best efforts I am sure I have some security flaws in my site. What I

Re: Is there any workbench or development studio available for Linux?

http://dev.mysql.com/downloads/gui-tools/5.0.html http://dev.mysql.com/workbench/ legolas wrote: Hi thank you for reading my post Is there a development workbench or development/ administration studio available for linux? Whether from MySQL AB itself or other 3rd party companies? Thanks -

DB Schema Comparison Utility ?

Hi Folks, I am new to MySQL. We have a development environment where we have three systems 1) Developement Database on Machine A 2) Test Databasae on Machine B 3) Live Database on Machine C So we make changes to the Developement Database, then move them to test then to live. My question is

Lock is Always Free

Hi Folks, I am having problems trying to use the GET_LOCK and IS_FREE_LOCK commands. I am trying to put together a queue manager. The theory is that is would scan for queues, check for a lock and if the lock if free then start the queue. When the queue process starts it should use GET_LOCK

Unique Rowid

Hi Folks, I am in the process of putting together a web application. I have decided to add a 'RowId' field to all my tables and assign it a unique number so that I use it to retrieve data. In concept this number might be passed back to the server as part of an ajax request etc. My question

Re: Newbie Question connecting with windows named pipes (resolved)

rds, John Sebastian Mendel wrote: John Comerford schrieb: Hi Sebastian, I did read somewhere that sockets was not valid for windows, and '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have tried the following commands: $mysqli = new mysqli(".&qu

Re: Newbie Question connecting with windows named pipes (resolved)

s using "/tmp/mysql.sock" as the pipe name. I am going to do some testing this evening to see if my suspicion is correct. Thanks again, John Sebastian Mendel wrote: John Comerford schrieb: Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysq

Re: Newbie Question connecting with windows named pipes (resolved)

Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysqli(".", $username,$password, $database,null,"/tmp/mysql.sock"); Regards, JC Sebastian Mendel wrote: John Comerford schrieb: Hi Folks, I have a database running on Window XP, th

Newbie Question connecting with windows named pipes

Hi Folks, I have a database running on Window XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like... [client] #password= your_password port= 3306 socket= /tmp/mysql.sock [mysqld] #port= 33

Re: Millisecond time stamp

eyer wrote: John Comerford wrote: Thanks for the replies guys, banging my head against the wall for not thinking of using an auto increment integer to handle the sequence, I've got to cut back on those Friday night beers Okay, color me confused, but what exactly are you wanti

Re: Millisecond time stamp

Thanks for the replies guys, banging my head against the wall for not thinking of using an auto increment integer to handle the sequence, I've got to cut back on those Friday night beers On 4/17/07, John Comerford <[EMAIL PROTECTED]> wrote: Hi Folks, A) One character str

Millisecond time stamp

Hi Folks, I am putting together a table to hold log entries. I was going to index it on a field with a type of TimeStamp. Unfortunately this will not suit my needs because I could have more than one log entry per second. As far as my (limited) knowledge goes I have two options to get around