Backups

2006-01-16 Thread Rick Dwyer
Hello all. I am looking into the different back up methods available for safeguarding my MySQL databases. Ideally, I would like to have dedicated machine on our network which all data is dumped to periodically. The tool I would like to use is MySQL Administrator although I could also use N

Experienced MySQL Admin Needed

2006-01-11 Thread Rick Dwyer
be as well as your work history/experience. Thanks. Rick Rick Dwyer Computer Operations Manager Quick Link Information Services --- [EMAIL PROTECTED] ph: 203-483-2922 fx: 203-483-2920 -- MySQL General Mailing List For list archives: http

Dropped table. . . Help Please

2005-12-13 Thread Rick Dwyer
I made a major mistake with MySQL 4.1.x. While using Navicatt I dropped my database when I meant to drop a table. Other than backups which are not that up to date, is there an undo? Help here is greatly appreciated. Thanks, I'm desperate. Rick -- MySQL General Mailing List For list archive

Re: A bit of SQL help for a MySQL novice.

2005-11-17 Thread Rick Dwyer
will be entered in an unclean manner. Therefore I must deal with it on the backend. Thanks for the pointers. Rick On Nov 17, 2005, at 11:15 AM, Rhino wrote: - Original Message - From: "Rick Dwyer" <[EMAIL PROTECTED] link.com> To: Sent: Thursday, November 17, 2005

A bit of SQL help for a MySQL novice.

2005-11-17 Thread Rick Dwyer
Hello All. I am hoping for a bit of help with some code that has really given me some trouble. If this is not he correct forum for this any help in pointing me to a more suited list would be appreciated. I have a MySQL 4.1.x database containing records with phone numbers. Most of the phon

Re: ODBC Initial Setup Problems

2004-11-05 Thread Rick Dwyer
On 5 Nov 2004 at 10:01, Rick Dwyer wrote: Hello All: I am trying to configure ODBC for MySQL but have been unable to make a connection. Hi, I have no experience of Mac OS X, but I believe it is linux-ish which means case- sensetive path names. The line below shows library with a lower case L

ODBC Initial Setup Problems

2004-11-05 Thread Rick Dwyer
Hello All: I am trying to configure ODBC for MySQL but have been unable to make a connection. We are running MySQL 4.0.15 supplied by Server Logistics on OS X 10.3.5. I have installed their ODBC Driver and 4 files show up in the library/MyODBC/Lib/ directory: libmyodbc3_r-3.51.06.bundle libmyodb

RE: SQL command timeout

2004-10-22 Thread Rick Dwyer
Check your mysql system variables for timeout variables (SHOW VARIABLES;) Thanks Jay. After I do this I see there are a number of timeout values, none which refer to a sql command timeout. Are you able to pinpont which value I need to manipulate? Also, if I increase this value, what are the

SQL command timeout

2004-10-22 Thread Rick Dwyer
Hi all. I have a lasso page with various Inlines to execute, updates, searches, deletes and SQL commands to summarize data from a database with several tables that have grown large and the query to the database lasts for several minutes during this process. I have just started noticing that it

RE: Setting up MySQL on Raid Mirror

2004-07-28 Thread Rick Dwyer
Assuming its not a super-high performance situation, I would put everything on the RAID 1 volume. Richard, what would you define as super-high performance? This MySQL database server will serve as the backend for a Lasso/ OS X Apache webserver handling thousands of hits per day. Will installing

MySQL over Raid Mirror

2004-07-28 Thread Rick Dwyer
Hello all. I want to install MySQL on a RAID mirror drive using two ATA 125GB for the mirror. I know in a webserver config, it's best to put the boot OS on one drive and the shared serving folder on the RAID mirror drive. Under a MySQL server, if I install the OS and MySQL all on the mirror d

Setting up MySQL on Raid Mirror

2004-07-28 Thread Rick Dwyer
Hello all. I want to install MySQL on a RAID mirror drive using two ATA 125GB for the mirror. I know in a webserver config, it's best to put the boot OS on one drive and the shared serving folder on the RAID mirror drive. Under a MySQL server, if I install the OS and MySQL all on the mirror d

Importing special characters via text file

2004-01-16 Thread Rick Dwyer
Hello all. Any help on the following matter is greatly appreciated. I tried to import a text file containing numerous special characters (À, Æ, Ç , etc.) but they convert to incorrect characters. I can paste them and write them correctly using a form submission created with LP6. However, an