Re: Securing MySQL on Mac OSX

It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. it means that they can do whatever they want to the mysql db's without being prompted for a password. This does not mean th

Re: mysql binlogs and their expiry times

According to the doc for this parameter, "Possible removals happen at startup and at binary log rotation." This implies that removal is not automatic - you have to either flush logs or bounce the server. We use "Purge Master" periodically. i do this from cron mysql -e "PURGE MASTER LOGS

Re: mysql-server-4.1.20-2.RHEL4.1 - master/master error after crash

I run 4.1.20 in master/master for nagios clustering. Everything was working fine until both machines went down due to power failure in the IDC. On powering back up one of the machines has come back fine but on the 'secondary' bearing in mind this is master/master but actually the 01 machin

mysql-server-4.1.20-2.RHEL4.1 - master/master error after crash

Hi I run 4.1.20 in master/master for nagios clustering. Everything was working fine until both machines went down due to power failure in the IDC. On powering back up one of the machines has come back fine but on the 'secondary' bearing in mind this is master/master but actually the 01 machi

Re: master master replication - hostname change - slaves fails

I don't think you need to flush your bin logs. CHANGE MASTER TO MASTER HOST = 'hostname'; Look at this for more info at http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html There is a lot more you can add to the statement. thanks but this gave me a very similar error - I forget

Re: master master replication - hostname change - slaves fails

Hi I had master-master working fin in dev - i move them to prd now and so change the hostnames, on starting i see this error 080522 11:53:40 mysqld started 080522 11:53:40 InnoDB: Started; log sequence number 0 213274351 080522 11:53:40 [ERROR] Failed to open the relay log './devnagios01-

master master replication - hostname change - slaves fails

Hi I had master-master working fin in dev - i move them to prd now and so change the hostnames, on starting i see this error 080522 11:53:40 mysqld started 080522 11:53:40 InnoDB: Started; log sequence number 0 213274351 080522 11:53:40 [ERROR] Failed to open the relay log './devnagios01-re

Re: master - slave replication - slave not updating

Yes thanks - i have done that and restarted the slave and _some_ tables now appear to update but others dont eg master: mysql> select count(*) from tbl_checkcommand; +--+ | count(*) | +--+ | 30 | +--+ 1 row in set (0.00 sec) slave: mysql> select count(*) from

Re: master - slave replication - slave not updating

The error 1062 you could skipped in the slave modifying your my.cnf ( slave side) using : slave-skip-errors=1062 This error on duplicated records, normally is problem in binarylogs transfer data. But, anyway, please confer that the data exist in the slave. Yes thanks - i have done tha

master - slave replication - slave not updating

Hi I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have setup a master/slave combination. Updates at first appeared to work as creating and inserting into the master created the db's on the slave etc. I have noticed however that data in the master is not making its way to t

Re: Storing Larger MySQL Backups

I'm curious if anyone has any thoughts on how I can handle a data retention issue I've been facing with a larger dataset. My process, roughtly is run mysqldump against the DB and gzip the output. Then I transfer it off to a different machine for archival onto optical media (yes I know the

Re: Load Balancer for mysql

Is there a hardware/software loadbalancer for multiple mysql servers servicing read transactions? linux lvs project http://www.linuxvirtualserver.org/ as mysql network connections are tcp then this would work fine for reads -- MySQL General Mailing List For list archives: http://lists.m

CentOS 4.3 - MySQL - NIS user issue

Hi I have what i think is a strange issue - All my users are NIS users and they can access this box fine. I have a MySQL server running on this box that is running fine. The OS 'root' user can authenticate and use MySQL fine as this is not a NIS user e.g. [EMAIL PROTECTED] mysql -u bugs -pxx

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. thanks both - that did t

MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from ser

Re: MYSQL not starting

I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MYSQL not starting

Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm="mysqld" scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing Lis

Re: dump to more than 1 file

The output of mysqldump is standard output, not a file. You can pipe it into another program, or redirect the output to a file, but mysqldump does not make a file. Therefore, there is no option in mysqldump to make more than 1 file. How is your database stored on disk? The documentation Edwi

Re: dump to more than 1 file

The output of mysqldump is standard output, not a file. You can pipe it into another program, or redirect the output to a file, but mysqldump does not make a file. Therefore, there is no option in mysqldump to make more than 1 file. How is your database stored on disk? The documentation Edwi

Re: Installation help ...!

Hello. I am a complete newbie here and to the world of Linux & MySQL. I am trying to create a LAMP server I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and it seems to work ok. I downloaded MySQL 5.0 and now want to install that I read somewhere that I need to r

dump to more than 1 file

is it possible to do a mysql dump to more than 1 file? We will shortly be needing to dump a db that will be in excess of 50gb so will encounter file size issues This is on 4.1.x and rhel 4 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Mysqldump accessing a remote shared folder.

Hi, I am trying to run mysqldump on a bugzilla database that is stored on a remote server. I have access to that shared folder and I have no problem backing up with MySQL Admin. With mysqldump using a batch file (Windows) I get the following: mysqldump: Got error: 1045: Access denied for use

Re: 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux

The short answer: no. http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states: " The autoextend attribute and those following can be used only for the last data file in the innodb_data_file_path line. autoextend is available starting from MySQL 3.23.50 and 4.0.2. " You could us

Re: MySQL 4.1.15 on Red Hat 7.3?

how are you trying to install this? actually # mysql -u root -pxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> exit Bye [EMAIL PROTECTED] data]#

Re: MySQL 4.1.15 on Red Hat 7.3?

Has anyone here successfully managed to install mysql 4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be using the glibc 2.2.5 libraries and mysql seems to insist on using glibc 2.3. Am I out of luck? how are you trying to install this? -- MySQL General Mailing List For list archives: h

'Autoextend' datafile - Mysql-Max-4.1.14 - Linux

Hi I need to have a single db that will have in excess of 100gb of data in it - For this i will need to create more that 1 datafile as the max file size of linux would be exceeded in this scenerio. On Oracle you can say that a datafile is x mb in size and it can autoextend to be x mb - Is th

Re: Create table results in (errno: 121)

> Is it indexed? > > And don't forget you can use the command > SHOW INNODB STATUS\G > > to show the last FK related error. ahh yes - i did not know about this command LATEST FOREIGN KEY ERROR 040422 14:39:09 Error in foreign key constraint creati

Create table results in (errno: 121)

Hi, I'm trying to create a table with the following syntax CREATE TABLE TNSession ( SessionID int(11) NOT NULL auto_increment, IPAddress varchar(50) default NULL, Created datetime default NULL, Expired tinyint(4) default '0', AccountID int(11) default '0', PRIMARY KEY (SessionID), KEY FK_AccountI