MySQLcheck-scramble vulerability info

2004-07-28 Thread Ben Ricker
vuneralibility (the latter only had 7 hits). Has anyone seen better information on how to patch 4.0.18 to fix this bug? Check out http://securitytracker.com/alerts/2004/Jul/1010645.html for more information. Ben Ricker

Re: Server optimization issue

2004-06-11 Thread Ben Ricker
your system worry about the swap and RAM allocation. Looks like you are using a Unix type OS, try top, a great little tool that will show you listings of processes real time with the heap info. But I would worry more about what the queries are doing. Good luck. Ben Ricker -- Ben Ricker Web

Copying BLOBs

2004-05-20 Thread Ben Ricker
had a number of escaped character designations; looked like some sort of ASCII code or something to that effect. Any ideas? Thanks, Ben Ricker - CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended

Doing MySQl DB File backups

2004-05-18 Thread Ben Ricker
enlighten me on this? Thanks, Ben Ricker - CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable

RE: Doing MySQl DB File backups

2004-05-18 Thread Ben Ricker
will have MORE then 24 hours data missing because the DB may not (or may) write the data that has changed to the data files. Do you knif the mysqladmin refresh will force a write to the DB data files? Thanks, Ben Ricker

Re: Running more than one level of MySQL

2004-05-18 Thread Ben Ricker
. Good luck. Ben Ricker -- Ben Ricker Web Administrator Mastercard International, Inc. 904 North Third (636) 722-4697 Robert

Backup methodology?

2003-10-08 Thread Ben Ricker
of all the data for that day B. Use the update-log (or binary-log) and back that up. Which is the best way? I am looking for small size and ease of restoration. I am leaning towards the update-log, since this database has so many record additions. Any ideas? Ben Ricker Wellinx, Inc

Problem with deleting records

2003-10-08 Thread Ben Ricker
so many changes? Should I run the -r or -o on the file before I delete? Thanks, Ben Ricker Wellinx, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Maintenace Query corrupting indexes + perf question

2003-09-30 Thread Ben Ricker
for increasing the key_buffers? Thanks, Ben Ricker Wellinx.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Table crashes after optimize

2003-09-25 Thread Ben Ricker
parts Should be: 5203 parts MyISAM-table '/usr/local/mysql/data/test/MESSAGES.MYI' is corrupted Fix it using switch -r or -o Anyone have any ideas what is going on? I need help ASAP on this, if you can! Thanks, Ben Ricker -- MySQL General

Table corruption w/ Optimize

2003-09-23 Thread Ben Ricker
why the optimize function of MySQL would continually corrupt the database? Ben Ricker Wellinx.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with optimizing table

2003-09-22 Thread Ben Ricker
optimize writes out to the OS? I cannot find any information on this. Thanks, Ben Ricker Wellinx.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]