Re: LOAD - failure for a non-admin user

2008-10-01 Thread Werner D.
Reyna.Sabina schrieb: > Hi, > > I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). > > I created a new database called HYDRO (user: admin). I created a new user > called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. > User 'hydro' has given all provileges except the ' Gr

Re: Using Flush Hosts in cron

2008-09-09 Thread Werner D.
Hank schrieb: > On Tue, Sep 9, 2008 at 11:48 AM, Werner D. <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hank schrieb: > > I have the blocked connection problem between three of my servers, all > > behind two firewalls and on one switc

Re: Using Flush Hosts in cron

2008-09-09 Thread Werner D.
Hank schrieb: > I have the blocked connection problem between three of my servers, all > behind two firewalls and on one switch. > > Occaisionally the mysql servers start blocking the hosts. > > What's the downside to running a "Flush hosts" once per minute on these > mysql servers? better solut

Re: Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x

2008-09-05 Thread Werner D.
Shaun Adams schrieb: > When I perform a dump in mysql5 to mysql 4 DB, I get the error (below). > Does anyone know how I can resolve this? > > > > QUERY (windows server from the cmd prompt) > > mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME] > --password=[PASSWORD] --

Re: MySQL-Backup incremental Backups in a Master/Slave Environment

2008-08-08 Thread Werner D.
Hi, first thanks for your response Are you using InnoDb or MyISAM? If you are using Inno, I would add --single-transaction to your mysqldump command within the Perl script and flush the logs prior to doing the backup and not backup the new bin-log file until the next. No, there is a mixture b

MySQL-Backup incremental Backups in a Master/Slave Environment

2008-08-04 Thread Werner D.
Hello everybody, i have a Question concering MySQL-Backups in a Master/Slave Replication-Setup (MYISAM and InnoDB Tables) and incremental Backups using the Binary-Logs from the Slave. Well, in case something will go wrong (hopefully not) I'm currently trying to implement a recovery System. There