RE: 2 questions about Replication
You could daisy chain the servers together, this would be ineffiecient and not robust, but it would work. shop1 master to shop2 | customers1 | V shop2 master to shop3 | customers1 customers2 | V shop3 master to office | customers1 customers2 customers2 | V head office Alternatively, if this is just for backup purposes I would write a script that dumps the customers table at each shop, compress it and then ftp it to head office every night. Cheers, chris -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 08:01 To: [EMAIL PROTECTED] Subject: Re: 2 questions about Replication Hello. MySQL only supports one master and many slaves. As I saw in comments at: http://dev.mysql.com/doc/mysql/en/Replication_Options.html You may use replicate-rewrite-db for tables: replicate-rewrite-db = RemoteTableName -LocalTableName i have 2 questions about Replication. 1) I managed to make one slave and one master. The replication works fine and it updates only one table from one database (cause of the replicate-do-table=db.table1). The first question is can I tell mysql that table1 from master to be named table2 on slave? I already have another table1 and I dont want to overwrite it. 2) As far as I read I can have as many slaves as I want and one master. Can I have the opposite? Imagine the follow scenario: I have 3 Shops with 3 Database (same structure) and they all contain a table CUSTOMERS. I want to put all those customers from 3 shops to a central database. So, I was thinking to inverse the master/slave logic and backup each shop to the slave computer. Thats why I need to change the name of table. Because i want to backup customers of first shop to CUSTOMERS1, customers of second shop to CUSTOMERS2 etc etc. Nikos [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Sequencial Replication
As I understand it... The SQL must be executed in sequence, otherwise you'll end up with incosistency between master and slave. an example: If thread 1 is inserting data, and thread 2 is running updates based on the inserted data then you could end up with different results on the slave than on the master. I'm sure someone else could explain it better.. or possibly correctly :) Chris -Original Message- From: Arvind Gangal [mailto:[EMAIL PROTECTED] Sent: 10 November 2004 10:28 To: 'Gleb Paharenko'; [EMAIL PROTECTED] Subject: RE: Sequencial Replication Hello, I understand that the slave executes the sqls from binlog in sequence, but are there any plans to make it multi-threaded so that it executes multiple sqls from binlog. Thanks Arvind. -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 08 November 2004 13:02 To: [EMAIL PROTECTED] Subject: Re: Sequencial Replication Hello. MySQL slave receives all updates, but executes them in queue. More about implementation of replication you can read at: http://dev.mysql.com/doc/mysql/en/Replication_Implementation_Details.htm l Arvind Gangal [EMAIL PROTECTED] wrote: Hi Gurus, As I understand the slave replicates with the master reading one query at a time from the binlog files. And at times the slave comes across a long update query and unless this has completed it will not pick up the next sql even though the other sql is on other table or may be another database. Is there a mechanism of running multiple sql slave threads in order to keep slave in sync to the master to the max. I reckon this would mean remembering multiple positions on the binlog. TIA Arvind Gangal http://www.lastminute.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk __ __ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: enum TRUE/FALSE
If you want an enum to have the possible values of NULL or 1 alter table `Associate` modify `Active` enum('1'); from the mysql manual http://dev.mysql.com/doc/mysql/en/ENUM.html If an ENUM column is declared to allow NULL, the NULL value is a legal value for the column, and the default value is NULL. If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values. If you simply want a column to hold boolean data I prefer to use tiyint(1) unsigned not null In my application I then treat 0 as False and 1 (or any other number) as True I do not believe you can make mysql evaluate NULL to be False, mysql will evaluate 1 = True and 0 = False, TRUE And FALSE are simply aliases for 1 and 0 you have two options 1) You could simply update your table alter table `Associate` modify `Active` enum('0','1'); (or 1 then 0 if you want true to be the default) then update `Associate` set `Active` = 0 where isNull(Active); 2) modify your queries select count(*) from Associate where Active!=1 OR isNull(Active); select count(*) from Associate where Active=1; Chris -Original Message- From: Scott Hamm [mailto:[EMAIL PROTECTED] Sent: 10 November 2004 14:25 To: 'Mysql ' (E-mail) Subject: enum TRUE/FALSE I'm trying to figure out how to make Active's null as FALSE and '1' as TRUE, in enum point of view Can anyone help me out here, trying to learn enum's phenomenon? I'm not sure I understood document quite clear -- as of yet :( mysql desc Associate; +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+-- --+ | ID | int(11) | | PRI | NULL| auto_increment | | LocationID | int(11) | YES | | NULL| | | NTLogon | varchar(8) | YES | | NULL| | | DomainID | int(11) | YES | | NULL| | | LastName | varchar(30) | YES | | NULL| | | FirstName| varchar(30) | YES | | NULL| | | Shift| int(11) | YES | | NULL| | | QADE | enum('','1') | YES | | NULL| | | DataEntry| enum('','1') | YES | | NULL| | | QAMR | enum('','1') | YES | | NULL| | | MailRoom | enum('','1') | YES | | NULL| | | QAT | enum('','1') | YES | | NULL| | | Taping | enum('','1') | YES | | NULL| | | QAF | enum('','1') | YES | | NULL| | | Filming | enum('','1') | YES | | NULL| | | CustomerContact | enum('','1') | YES | | NULL| | | Trainee | enum('','1') | YES | | NULL| | | Active | enum('','1') | YES | | NULL| | | Creator | varchar(8) | YES | | NULL| | | NewAssociateDate | date | YES | | NULL| | +--+--+--+-+-+-- --+ 20 rows in set (0.00 sec) mysql select count(*) from Associate where Active=FALSE; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.01 sec) mysql select count(*) from Associate where Active=TRUE; +--+ | count(*) | +--+ | 2611 | +--+ 1 row in set (0.01 sec) mysql select count(*) from Associate; +--+ | count(*) | +--+ | 3947 | +--+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PHP/MySQL Problem
when asking a question, it always helpful to post you code/queries so we can see what is happening. but tbh, this sounds like it's a php code problem. you have established that both queries work, on there own I'm don't know anything about php, but it sounds like you are not executing the first query you might have more luck if you post your php code to a php group chris -Original Message- From: Yahoo Default User [mailto:[EMAIL PROTECTED] Sent: 05 November 2004 08:52 To: [EMAIL PROTECTED] Subject: PHP/MySQL Problem Hi Guys, I have a problem with MySQL in conjunction with PHP so I also decided to post here: I have a PHP script that contains two consecutive MySQL queries, something like this: Query 1: Delete some rows from Table A Query 2: Insert some rows into Table A The problem is, only Query 2 seems to be executed. Query 1 is not executed at all. I tried running the script with only Query 1 and it worked. However, when I put back Query 2, then the problem comes back. What can be causing this problem? How do I solve this problem? Any help would be appreciated. Thanks! __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: True/False data type
I also use tinyint(1) unsigned and I provide a mysqlBooleanFormat() function in my application that will return 1 or 0 for storing the value in the DB -Original Message- From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED] Sent: 04 November 2004 20:44 To: [EMAIL PROTECTED] Subject: Re: True/False data type Personally I use a tinyint(1) unsigned. Scott Hamm wrote: What data type should I use to use True/False type when I create a table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimize query help
Hi, We log all sessions on our webserver to a table, and then periodically run a batch process to analyze the visitors ip addresses to determine the city/region/country of origin. we use MySQL 4.1.1-alpha-standard-log on Redhat AS, installed from the mysql RPM. The query below takes about 1 second to run, which is fine on its own, but it has to be run for 35+ locations. I *think* I've created all possible indexes to speed this up, but if anyone could help it would be much appreciated. cheers, chris QUERY -- /* The concat is required to stop Coldfusion seeing this column as binary data */ SELECT CONCAT(country.name, '') AS country, ipaddress.region, ipaddress.city, /* Calculate distance in miles of visitor to city they are visiting */ ROUND(3957 * 2 * ATAN2(SQRT(POW((SIN(0.0174*(ipaddress.latitude-56.847)/2)),2) + COS(0.0174*56.847) * COS(0.0174*ipaddress.latitude) * POW((SIN(0.0174*(ipaddress.longitude--2.477)/2)),2)),SQRT(1 -(POW((SIN(0.0174*(ipaddress.latitude-56.847)/2)),2) + COS(0.0174*56.847) * COS(0.0174*56.847) * POW((SIN(0.0174*(ipaddress.longitude--2.477)/2)),2) AS distance, COUNT(ipaddress.ipnumber) AS visits FROM (country INNER JOIN (ipaddress INNER JOIN sessionLog ON ipaddress.ipnumber = sessionLog.ipnumber) ON country.code = ipaddress.country) INNER JOIN userAgent ON sessionLog.browser_id = userAgent.id WHERE sessionLog.initialDirectory = 1 AND userAgent.searchEngine = 0 AND sessionLog.sessionStartTime BETWEEN {ts '2004-09-01 00:00:00'} AND {ts '2004-09-30 23:59:59'} GROUP BY country, region, city ORDER BY visits DESC EXPLAIN OUTPUT ++-+++-- --++-+-- --+--+-+ | id | select_type | table | type | possible_keys | key| key_len | ref| rows | Extra | ++-+++-- --++-+-- --+--+-+ | 1 | SIMPLE | country| ALL| [NULL] | [NULL] | [NULL] | [NULL] | 192 | Using temporary; Using filesort | | 1 | SIMPLE | userAgent | eq_ref | PRIMARY | PRIMARY| 4 | ukcd.sessionLog.browser_id |1 | Using where | | 1 | SIMPLE | sessionLog | ref| idx_sessionloginitdirid,idx_sessionlogstarttime,idx_sessionlogipnumber | idx_sessionlogipnumber | 4 | ukcd.ipaddress.ipnumber| 30 | Using where | | 1 | SIMPLE | ipaddress | ref| PRIMARY,idx_country | idx_country| 2 | ukcd.country.code | 52 | | ++-+++-- --++-+-- --+--+-+ TABLE DEFS --- # contains 192 rows CREATE TABLE `country` ( `id` int(11) NOT NULL default '0', `code` char(2) default NULL, `name` char(100) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1; # 10,000 rows CREATE TABLE `ipaddress` ( `ipnumber` int(10) unsigned NOT NULL default '0', `country` char(2) NOT NULL default '', `region` varchar(25) NOT NULL default '', `city` varchar(25) NOT NULL default '', `postalCode` varchar(8) NOT NULL default '', `latitude` double NOT NULL default '0', `longitude` double NOT NULL default '0', `dmacode` varchar(100) NOT NULL default '', `areacode` varchar(100) NOT NULL default '', `isp` varchar(100) NOT NULL default '', `errcode` varchar(100) NOT NULL default '', `organisation` varchar(100) NOT NULL default '', PRIMARY KEY (`ipnumber`), KEY `idx_country` (`country`), KEY `idx_city` (`city`) ) TYPE=MyISAM DEFAULT CHARSET=latin1; # 250,000 rows CREATE TABLE `sessionLog` ( `session_id` varchar(70) NOT NULL default '', `browser_id` int(11) NOT NULL default '0', `sessionStartTime` datetime NOT NULL default '-00-00 00:00:00', `initialDirectory` int(11) NOT NULL default '0', `ipnumber` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `idx_sessionloginitdirid` (`initialDirectory`), KEY `idx_sessionlogstarttime` (`sessionStartTime`), KEY `idx_sessionlogipnumber` (`ipnumber`) ) TYPE=MyISAM DEFAULT CHARSET=latin1; # 2,000 rows CREATE TABLE `userAgent` ( `id` int(11) NOT NULL auto_increment, `uaString` varchar(255) NOT NULL default '', `searchEngine` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_ua` (`uaString`) ) TYPE=MyISAM
RE: filed that does not contain text between symbols
not sure you can do this just with mysql, I think your gunna need to select the html from the db then send it to something like perl or php and use a regex parser on it. -Original Message- From: Bob Ramsey [mailto:[EMAIL PROTECTED] Sent: 03 October 2004 12:45 To: [EMAIL PROTECTED] Subject: filed that does not contain text between symbols Hi, I have some web pages in a database and I want to check to make sure that all of the images have alt tags in them. So what I need to do is ask something like this in psuedocode: select page_name from web_pages where page_body does not contain 'alt=' between 'img' and ''; But I just can't figure out the right syntax. Any ideas? Thanks, bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql and PHP
slightly off topic, but you can sort of build apache with mysql support. mod_auth_mysql allows you to authenticate users and groups against a DB http://sourceforge.net/projects/modauthmysql/ chris -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: 15 September 2004 16:22 To: Greg Donald Cc: [EMAIL PROTECTED] Subject: Re: Mysql and PHP On Wed, 15 Sep 2004, Greg Donald wrote: On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote: Did you build both php and apache with MySQL support? I wasn't aware you could build Apache with MySQL support. How is that done? Apologies - I should have said just php. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Storing foreign characters in DB
Not sure whether this is applicable to your version of mysql, or to PHP. I had the same problem using Macromedia's Coldfusion, and adding this: useUnicode=truecharacterEncoding=UTF-8 to the db connection string solved the problem chris -Original Message- From: MySQL [mailto:[EMAIL PROTECTED] Sent: 05 September 2004 07:06 To: MySQL Subject: Storing foreign characters in DB I'm having a problem figuring out how to deal with foreign characters in text that was copied from an MS Word document and pasted into a form field, then stored in a MySQL DB. (I have MySQL 3.23.58 running). I'm not how sure how these characters are being stored in the MySQL database, but, when I retrieve the text and run it through PHP's htmlentities() function, each foreign character is converted into 2 other foreign characters that don't at all represent the original. For example, a lowercase u with an umlat over it (ΓΌ) is somehow displayed as an uppercase A with an umlat over it followed by the 1/4 symbol after parsed by htmlentities(). A lowercase o with an ulmat displays as an uppercase A with an umlat over it followed by the paragraph symbol. It seems that the uppercase A w/umlat is a constant, and the next character changes. How are these foreign characters being stored in the DB? Do I need to do something in order to store these characters properly, or is this something I need to somehow do on the PHP side of things?? Thanks! Monty. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Escaped BLOB data in XML
If you base64 encode your binary, it will be valid inside the xml. As far as I know this is the accepted way to transfer binary objects using xml. chris -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: 13 August 2004 05:09 To: Keith Ivey; [EMAIL PROTECTED] Subject: Re: Escaped BLOB data in XML This leads me to another question. What are the valid ASCII characters that XML parser understands. Are they only a-1,A-Z,0-9,., etc or some other characters. Regards, Karam --- Karam Chand [EMAIL PROTECTED] wrote: Hello, Hmmm. I was figuring that out. mysql_escape_string() only escapes characters like \r, \n, \\, 0 etc. it still keep other non-character data same like it keep ascii 15 to ascii 15 that no parser is able to handle. Isnt there any better way then base64 to handle this. Just like replacin to lt; solves the problem in the data? Regards, Karam --- Keith Ivey [EMAIL PROTECTED] wrote: Karam Chand wrote: i have a table with a LONGBLOB column. We store some small images in it. I want to export them in XML format with schema like: cdata/c cdata/c ... ... Now the problem is even if I mysql_real_escape() and changing entities like , to lt; gt; the data some of the characters are of ascii value 12,13 etc. None of the XML parsers are able to recognise it and they throw up error? I googled but couldnt find a refernce on how to handle such characters in XML. This doesn't have anything to do with MySQL. XML isn't really designed for directly containing binary data, so people generally use Base64 encoding (or occasionally some other method of encoding binary data in ASCII). The XML parser isn't going to be able to return the raw binary data -- you'll have to decode it. -- Keith Ivey [EMAIL PROTECTED] Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL won't start... was runnnig fine
Hi, I have been running 4.1.3 on redhat9, installed from the mysql rpm package. It has been running great until the server crashed for an unknown reason 2 days ago. now when ever i try to start mysql i get the following error in log 040812 09:52:34 mysqld started040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976040812 9:52:34 InnoDB: Error: unable to create temporary file040812 9:52:34 InnoDB: Operating system error number 13 in a file operation.InnoDB: The error means mysqld does not have the access rights toInnoDB: the directory.InnoDB: File operation call: 'tmpfile'.InnoDB: Cannot continue operation.040812 09:52:34 mysqld ended i have chown -Rthe /var/lib/mysql directory -rw-rw 1 mysql mysql 0 Aug 12 09:59 innodb.status.4891drwx--x--x 2 mysql mysql 4096 Aug 11 09:57 mysqlsrwxrwxrwx 1 mysql mysql 0 Aug 12 09:59 mysql.sock-rw-rw 1 mysql root 442 Aug 12 09:59 slim.errdrwxr-xr-x 2 mysql mysql 4096 Aug 11 09:57 test I had changed nothing in the server, apart from the unexplained crash everything was normal now i'm stuck anyone seen this error before ? Regards Chris BlackwellLead Web DeveloperUK City Directory LtdTelephone: +44 (0)117 373 1465Email: [EMAIL PROTECTED]This email is intended for the use of the named recipient(s) only. Any information contained within this message or any of its attachments may be confidential and privileged information. Any unauthorized disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited.
RE: MySQL won't start... was runnnig fine
I have resolved this issue now, it was actually the permission on /tmp that had become corrupted as a result of the crash I can only assume chmod 777 /tmp chmod +t /tmp this fixed the problem but could have been fixed within minutes not days if the error message had told me which directory was causing the problem :/ chris -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 10:26 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine Chris Blackwell [EMAIL PROTECTED] wrote: now when ever i try to start mysql i get the following error in log 040812 09:52:34 mysqld started 040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976 040812 9:52:34 InnoDB: Error: unable to create temporary file 040812 9:52:34 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File operation call: 'tmpfile'. InnoDB: Cannot continue operation. 040812 09:52:34 mysqld ended [EMAIL PROTECTED] egor]$ perror 13 Error code 13: Permission denied i have chown -R the /var/lib/mysql directory So anyway permission denied. Check the rights on /var/lib/mysql itself -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL won't start... was runnnig fine
Nope, no idea why it crashed, and I don't know enough about redhat to bother investigating. It seemed to hang so it got a kick, when it came backup was bit screwy... so far this has been only problem. It's only a dev box so I'll keep my fingers crossed it's a freak occurrence :) chris -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 16:21 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine This line probably should have been a good hint: InnoDB: File operation call: 'tmpfile'. Any idea why the server crashed in the first place? That's not the sort of thing you want just randomly happening, I'd imagine. Although it might make life a bit more interesting... Cheers. --V Chris Blackwell wrote: I have resolved this issue now, it was actually the permission on /tmp that had become corrupted as a result of the crash I can only assume chmod 777 /tmp chmod +t /tmp this fixed the problem but could have been fixed within minutes not days if the error message had told me which directory was causing the problem :/ chris -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 10:26 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine Chris Blackwell [EMAIL PROTECTED] wrote: now when ever i try to start mysql i get the following error in log 040812 09:52:34 mysqld started 040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976 040812 9:52:34 InnoDB: Error: unable to create temporary file 040812 9:52:34 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File operation call: 'tmpfile'. InnoDB: Cannot continue operation. 040812 09:52:34 mysqld ended [EMAIL PROTECTED] egor]$ perror 13 Error code 13: Permission denied i have chown -R the /var/lib/mysql directory So anyway permission denied. Check the rights on /var/lib/mysql itself -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]