Binary data dumps?

2002-10-08 Thread Robert Fox
space. A couple of them are over 500MB in size! If any one has any advice or information it would be appreciated. Thanks, Rob Robert Fox Sr. Programmer/Analyst University Libraries of Notre Dame (574)631-3353 [EMAIL PROTECTED

Apologies - Binary Log info found

2002-10-08 Thread Robert Fox
Apologies to the list. Apparently the question I asked regarding binary data dumps is an issue involving a MySQL startup parameter: log-bin. Apparently this is the redo-log facility of MySQL for all successful updates. This can be turned on or off. Question answered. Thanks, Rob Robert Fox

Re: Mysql vs. Oracle and concat ||

2002-09-26 Thread Robert Fox
Hi Frank- I'm new to the MySQL world, and I am also a DBA with an Oracle background. This was a surprise to me as well. However, the only solution that I know of is to encapsulate your SELECT elements in a Concat() function. So, your SQL statement would be: select concat(numer, text) from

'print' or '\p' from mysql prompt

2002-09-19 Thread Robert Fox
Hello- I've just started using MySQL so this is absolutely a 'newbie' question. I'm used to working with Oracle's SQL*Plus which is a very different tool. In SQL*Plus, I could type 'l' or 'list' at the SQL*Plus prompt and see a printout to STDOUT (the screen) of the current command in the