Re: How can I export compressed databases in MySQL?

me.sql.gz If you ever want to reimport the dumped data you can then do:- gzip -dc $path/file_name.sql.gz | mysql -u'name_user' -p'pass' 'database_name' -- Best regards, Rob Hall - Red Hat Certified Engineer Senior Systems Administrator Newsquest Digital Media

Generating an Error in a Trigger

. Unfortunately the manual doesn't state how to generate an error (safely). -- Best regards,  Rob Hall - Red Hat Certified Engineer  Technical Team Leader  Newsquest Digital Media -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Browser 1.1.14

ate triggers happily in QB there's no indication that they exist on a table nor any facility to edit them? -- Best regards,  Rob Hall - Red Hat Certified Engineer  Technical Team Leader  Newsquest Digital Media -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Cursors in 5.0.13

On Wednesday 05 Oct 2005 15:29, Jeff Smelser wrote: > On Wednesday 05 October 2005 04:05 am, Rob Hall wrote: > > Having a few problems using cursors in 5.0.13 and I don't know wether > > it's an 'operator error' :) > > > > Should this work? > >

Cursors in 5.0.13

w! The above codes the result of trying to track this issue!). -- Best regards,  Rob Hall - Red Hat Certified Engineer  Technical Team Leader  Newsquest Digital Media -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Prepared Statements in Stored Procedures.

eated table would be unique when the SP was called. If you've multiple threads/users application side I didn't want to use a single table name and have the SP fall over itself. Obviously there are other (more elegant) solutions but as stated I was playing with SPs to see what I could get

Prepared Statements in Stored Procedures.

xecute_command__FP3THD + 16634 0x81771a9 mysql_parse__FP3THDPcUi + 249 0x816f8b4 dispatch_command__F19enum_server_commandP3THDPcUi + 1732 0x816f1e4 do_command__FP3THD + 196 0x816e7a4 handle_one_connection + 740 0x4ce341 (?) 0x1ddfee (?) -- Best regards,  Rob Hall - Red Hat Certified Engineer  Technical Team Leader  Newsquest Digital Media -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]