RE: backup scripts

2005-03-04 Thread Kelly . Brace
Tim, Thanks, that did the trick. One thing, I tried to zip the files up and I get permission denied when I attempt to do that with the command below. All of the files are there, but they don't get zipped up. I also notice that the txt files and the sql files have slightly different ownership

backup scripts

2005-03-03 Thread Kelly . Brace
Hello, When I attempt to try and run the backup: shell> mysqldump --tab=/path/to/some/dir --opt db_name I get the following errors: ./mysqldump: Got error: 1: Can't create/write to file '/usr/local/mysql/bakups/config.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Or: shell> mysqlho

Remote Connection via Toad for MySQL

2005-02-24 Thread Kelly . Brace
Good good. On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote: BINGO!!! Thanks Dan! Kelly Daniel Walker <[EMAIL PROTECTED]> What version of MySQL are you using? 4.1.1 uses an enhanced password hashing system that isn't compatible with clients built for older versions. This page on MyS

Remote Connection via Toad for MySQL

2005-02-24 Thread Kelly . Brace
Hello, I have downloaded Toad for MySQL to give it a test run. MySQL 4.1.10 is on Redhat AS 2.1 and Toad for MySQL is on Win XP. Everytime I attempt to connect via Toad, I get the following error: Unable to connect to the database. Host 'XX.XX.XX.XX' is not allowed to connect to this MySQL s

Re: Difficulty starting mysql

2005-02-24 Thread Kelly . Brace
Thanks guys! I did follow the procedure, but somewhere during the first and second attempt I mucked it up. Followed the directions slowly and carefully a third time and we are up and running. Thanks for your help! Kelly Kelly S. Brace Information Technology Exchange Center Twin Rise 200 1300

Difficulty starting mysql

2005-02-23 Thread Kelly . Brace
Hello, I'm attempting to start mysql 4.1.10 compiled source code on Red Hat Advanced Server 2.1 with apache 2.0.49. ./configure, make and make install went successfully. But when I attempt to start mysql using this command: sudo mysqld_safe --user=mysql I get the following errors: Starting