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
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
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
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] --
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
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