Unable to restart after crash

2008-01-12 Thread Ross Crawford
Hi, My mysql server crashed last night, and when it rebooted, was unable to restart. Here is the error log: Jan 13 00:12:54 localhost mysqld_safe[1324]: started Jan 13 00:12:55 localhost mysqld[1327]: 080113 0:12:55 InnoDB: Database was not shut down normally! Jan 13 00:12:55 localhost

adress stored as an array

2007-09-14 Thread Ross Hulford
Hi, I have an address stored as a serialized array address[0] = my street; address[1] = Edinburgh; address[2] = Scotland; This is what I have. I want if it is possible to extract all the UNIQUE towns from my database. This is what the on of the entires looks like in my database.

ordering dates

2007-09-12 Thread Ross Hulford
$result= mysql_query(SELECT date_format(date, '%d/%m/%Y') as date, title, id, display FROM news ORDER BY date DESC ); I have the query above the problem is oders them like so 30/05/2007 29/07/2007 25/0/2007 The order is taken by the first number. Is there any way to order them properly

selecting everyting from 2 non-identical tables.

2007-06-19 Thread ross
I have two non-identical tables. They are pretty similar except a few fields. I want to select everything from both for example table1 id name age table2 id name height I want id name height age even if it returns null values. select * from table1, table2 seems to give repeat rows for

Re: selecting everyting from 2 non-identical tables.

2007-06-19 Thread ross
to display all the attributes of all the people even if they are null my final table should be 1 - 176cm - John - 25-null-lakers 2 - 180cm - Rob - 40-null-yankies 3 - 166cm - mary - 22 - 2-null 4 - 175cm - betty - 48 - 4-null Ross - Original Message - From: Jay Blanchard [EMAIL

selecting second last row

2007-05-30 Thread ross
I have a table of publications. -- Table structure for news -- CREATE TABLE `news` ( `id` int(100) NOT NULL auto_increment, `content` longblob, `title` varchar(100) default NULL, `date` date default NULL, `display` varchar(10) default 'no', PRIMARY KEY

using tinymce and inserting the contents in a database

2007-05-29 Thread ross
Hi, I am using tinymce to save news articles with very basic html styling in a database. This works well upto a point but when I get over a certain number of characters and then the 'you have an error in your SQL syntax' error. I am saving in as a LONGBLOB so it should not be a data type

selecting the last and second last id's

2007-05-28 Thread ross
My primary id is an auto incrementing table and I want to return the highest and second highest id. Any ideas?

a function to convert a uk date to and from mysql date

2007-05-22 Thread ross
Hi, My UK dates are this format DD/MM/ I want it reversed and then the seperator changed so it becomes -MM-DD I use this PHP at the moment $available_from = implode('/', array_reverse(explode('-', $available_from))); Ta, R.

adding 3 values

2007-05-10 Thread ross
Hi, I have 3 integer values in the table single_rooms, double_rooms, twin _ooms but want to add them all up to do a comparison to see if the combined number of rooms is less than ten. Ta, R.

Re: adding 3 values

2007-05-10 Thread ross
Ok, I have this so far $query = SELECT * FROM properties where single_rooms+double_rooms+twin_rooms10 and rent 100; This is fine but what I really want to do it this $query = SELECT * FROM properties WHERE single_rooms+double_rooms+twin_rooms10 AND

Query problem

2007-05-09 Thread ross
I have a table of properties that is linked to a table f images with a one property to many images relationship. I have manged this with nested queries but want to try and do it on one line. My current query $query = SELECT * FROM images, properties WHERE images.property_id =

Re: Query problem

2007-05-09 Thread ross
No I want all the properties only one regardless of how many images are attached to them. Think I need a distinct in there somewhere, - Original Message - From: Jon Ribbens [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, May 09, 2007 6:56 PM Subject: Re: Query problem On

Re: Replication performance questions

2007-03-05 Thread Ross Vandegrift
to have created the slow query file, so I'm guessing this means a restart? -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians have made a covenant with the devil

Replication performance questions

2007-03-01 Thread Ross Vandegrift
that the engine is going to have to do some linear searching. Thanks for any input! -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians have made a covenant with the devil to darken

Re: Replication performance questions

2007-03-01 Thread Ross Vandegrift
can get slow on updates. The table is MyISAM. I searched on google a bit for info on slow updates with MyISAM and didn't really hit it on the nose. Can I ask you to elaborate? -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty

Re: Replication performance questions

2007-03-01 Thread Ross Vandegrift
the inserts/updates. There are no joins, subqueries, transactions, or any of the usual muck that complicates a performance issue. -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists

mysql problem

2007-02-21 Thread ross
? $total_rows = mysql_num_rows(mysql_query(SELECT * FROM $table_name)); It just seems to ignore them on the remote one as I am in under ross and ross2 and only one when I search for me. R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Questions on BDB storage engine

2006-11-28 Thread Ross Vandegrift
. The access to the BDB file would be strictly read-only. There are no transactions anywhere. Is it possible replicate a table that is using the BDB engine? Many thanks in advance! -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty

returning unique value

2006-11-01 Thread Ross Hulford
I have two tables galleries which contains the number and name of the photo galleries and 'thumnails' the images that are conenected to the galleries. I am trying to create a 'pick a gallery' screen where it selects all the galleries and then output the first thumbnail image associated with

Fw: returning unique value

2006-11-01 Thread Ross Hulford
I have atable which contains the number and name of the photo galleries and 'thumnails' the images that are conenected to the galleries. I am trying to create a 'pick a gallery' screen where it selects all the galleries and then output the first thumbnail image associated with that gallery.

Re: displaying a sing thumbnail

2006-08-28 Thread ross
$query = SELECT distinct gallery FROM thumbnails; that only returns the numbers 7 8. I need the all the info from the rows - id, binary data etcsomething like (although it doesn't work) $query = SELECT * FROM DISTINCT gallery FROM thumbnails; any ideas? - Original Message -

displaying a sing thumbnail

2006-08-26 Thread ross
) will change. I have the code to display the thubnail but am stuck with the query. I want to use mysql and php to (i) determine how many unique galleries there are. (ii) Retrieve display a single thumbnail from each gallery to act as the link to that gallery Ross

returning username/pass from 2 tables

2006-08-15 Thread ross
How do I check two tables is it? Username and userpass are submitted through a from and are unique $sql = SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND userpass = '$userpass'; Ta, Ross

maximum files size for longblob - what is bigger?

2006-08-07 Thread ross
what us the maximum filesize for longblobs in kb? Is there anything bigger? Ross

Getting the previous months documents

2006-05-02 Thread ross
I have a database that stores documents relating to meetings. They have all the usual stuff agenda, minutes etc. There are 3 paper types for each date agenda (1 only), minutes (1 only), and a bunch of general documents titled 'papers'. I need to display all the documents for a specific date

Re: Getting the previous months documents

2006-05-02 Thread ross
to change the field to DATE? Ross - Original Message - From: Peter Lauri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, May 02, 2006 9:06 AM Subject: RE: Getting the previous months documents You should start by using MySQL date as the standard for date: -MM-DD After

sorting with php/mysql

2006-05-02 Thread ross
This is my database...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. Say I delete item 2 how can I delted the gap and 'promote item_id 3 to item_id 2

download link to file

2006-04-30 Thread ross
I have a pdfs/documents saved in a field called 'content' on my db and I want to create an active hyperlink so users can download. any ideas how I can achive this. I am sure it is simple but cannot find an easy example posted. thanks, Ross

mysql query browser- editing resultsets

2006-04-24 Thread ross
Can someone explain to me how to edit this...I click on the cells and nothing From the manual If the query resultset is editable, you can click the Edit button below the resultset view. Double clicking cells in the resultset will allow you to edit their contents. Changes are commited to the

Re: mysql query browser- editing resultsets

2006-04-24 Thread ross
The edit button is 'greyed out' Ross - Original Message - From: J.R. Bullington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 24, 2006 4:20 PM Subject: RE: mysql query browser- editing resultsets There is an EDIT button on the bottom of the Query Browser. You have

Re: mysql query browser- editing resultsets

2006-04-24 Thread ross
I think the most likely case is the table is read-only. How do I change this? Ross - Original Message - From: J.R. Bullington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 24, 2006 4:46 PM Subject: RE: mysql query browser- editing resultsets

exporting a mysql database via mysql query browser

2006-04-24 Thread ross
I am a phpmyadmin user and have never really used mysql query browser before. I have a database sitting on my localhost and I want to export the whole thing via mysql query browser to the host. What is the easiest way to do it? Ross

getting unique results

2006-04-20 Thread ross
SELECT `Service type` FROM `service_providers` How do I get only unique results from this query. There are many services called 'cafe' for example but I only want one. R.

adding a field and settign the value

2006-04-19 Thread ross
of a This is fine when I create the field and add new entries but the old ones have a nothing in them. Thanks, Ross

Re: setting up phpmyadmin problem

2006-04-10 Thread ross
I did. The server is windows could this be the problem? The config.inc.php is in the main phpmyadmin folder not in the config folder. Is this ok? Ross - Original Message - From: Dominik Klein [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 10, 2006 11:25 AM Subject

query problem

2006-03-08 Thread ross
). $query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND area='area' AND interest='interest' ORDER BY fname $type; but what if nether is chosen, or only one? Is there an AND/OR operator or similar in mysql? Thanks, Ross -- MySQL General Mailing List For list archives

query problem

2006-03-08 Thread ross
). $query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND area='area' AND interest='interest' ORDER BY fname $type; but what if nether is chosen, or only one? Is there an AND/OR operator or similar in mysql? Thanks, Ross

Optimization suggestions when only using Innodb

2005-12-01 Thread Ross Anderson
of connections also. Some are repeated queries to static tables and others are dynamic read write to large tables. Thanks in advance! Ross Anderson mysql 4.0.25 linux-2.6.14 key_buffer = 128M table_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 16M thread_cache = 8

setting expiry date

2005-09-12 Thread ross
dd/mm/. thanks, Ross www.blue-fly.co.uk | [EMAIL PROTECTED] | 07816 996 930 | 0131 553 3935

Re: Migrating MySQL users

2005-09-05 Thread ross
On Mon, Sep 05, 2005 at 12:41:50PM +0300, Gleb Paharenko wrote: Hello. Have you run 'FLUSH PRIVILEGES'? Doh! I got everything else find, but forgot something stupid. Murphy's law, I suppose. Thanks for the prompt! Ross -- MySQL General Mailing List For list archives: http

Re: Migrating MySQL users

2005-09-05 Thread ross
the user authentication system has changed between 4.0 and 4.1 so old passwords from 4.0 wont work. Its given in the docs. Re-read my email: I'm moving from 4.1 - 4.1. Re-read the docs: 4.1 can authenticate against both hash formats. I just forgot to flush privileges, that's all! -- Ross

Migrating MySQL users

2005-09-04 Thread ross
. Both DB servers are 4.1 servers, one happens to be Debian and the other RedHat. Both servers have the wide password field and use old_password in my.cnf. Any reason why these moved accounts are unable to authenticate? -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware

Re: Migrating MySQL users

2005-09-04 Thread ross
: # mysql -u testing -psomepassword testing ERROR 1045 (28000): Access denied for user 'testing'@'localhost' (using password : YES) Thanks a ton for any suggestions! -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies

timestamp and php

2005-08-30 Thread ross
Hi, I have a row in myslq database called time and is just a simple timestamp column When I echo it out echo $row['time']; echo $row['content']; I get the following 2005-08-30 13:50.05 this is the text content Now I am not worried about the time but I would like to know how to (i) sort

newbee question

2005-08-27 Thread ross
Using mysql with php I have a database that has a unique value for the user id. when people get delete off the list I want the unique numbers to compact down so. user id 1 user id 4 user id 5 user id 7 user id 9 user id 10 becomes user id 1 user id 2 user id 3 user id 4 user id 5 user id 6

Re: MySQL and HIPAA Compliance?

2005-08-05 Thread ross
a clever encoding scheme to map a name and address to a very large integer, but that seems... not much better. How did you handle that issue? -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists

Fw: table export problem

2005-07-19 Thread ross
- Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, July 19, 2005 10:08 PM Subject: table export problem Hi all, I am trying to create a table on the remote server from a table I created on my local sever but it never seems to work CREATE TABLE

table export problem

2005-07-19 Thread ross
Hi all, I am trying to create a table on the remote server from a table I created on my local sever but it never seems to work CREATE TABLE `sheet1` ( `id` int(10) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `fname` varchar(255) NOT NULL default '', `sname`

Re: error: 'Can't create a new thread (errno 12).

2005-07-18 Thread ross
- I am using the stock Debian builds. Since it refers to general errors, I may persue it with them as well. Thanks! -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians

error: 'Can't create a new thread (errno 12).

2005-07-17 Thread ross
| +--++ -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians have made a covenant with the devil to darken the spirit and to confine man in the bonds of Hell. --St

Comments on hot databases migration

2005-07-11 Thread Anderson, Ross
, Ross Anderson __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __

InnoDB race condition inserting into a table with a unique constraint

2005-01-15 Thread Philip Ross
MySQL 4.1.8 I have an InnoDB table with a unique constraint: CREATE TABLE TEST ( ID bigint NOT NULL auto_increment, NAME varchar(100) NOT NULL, VALUE varchar(100), PRIMARY KEY (ID), UNIQUE KEY IX_NAME (NAME)) ENGINE=InnoDB Given a particular unique name, I need to either find the

compiling mysql and mysql crashing

2004-04-04 Thread Christine Ross
I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS=03 -felide-constructors -fno-exceptions -fno-rtti because of some instances of mysql crashing. When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). Im

Deleting records using the 'LIMIT' clause

2004-04-03 Thread Ross Honniball
identify it using it's key fields as the table has no primary key. Help greatly appreciated. Regards ... Ross . Ross Honniball JCU Bookshop Cairns Supervisor . James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia . Ph:07.4042.1157 Fx:07.4042.1158 Em:[EMAIL PROTECTED

How do I determine the row number or key when table has no key fields

2004-04-02 Thread Ross Honniball
against I'm new to this mailing list. Apologies if I am asking this question of an inappropriate email address. Regards ... Ross . Ross Honniball JCU Bookshop Cairns Supervisor . James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia . Ph:07.4042.1157 Fx:07.4042.1158 Em

RE: Newbie - dependencies Same problem --Plz giv the solution !!

2004-03-24 Thread Robert Ross
-Original Message- From: rajesh k [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 14:36 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Newbie - dependencies Same problem --Plz giv the solution !! Robb + ( ME TOO )- still in jail :-( Plz get me out of the jail

Newbie - dependencies

2004-03-11 Thread Robert Ross
Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL database function. I tried and failed using up2date (following instructions from RH), so downloaded the rpms and began to install by myself. My input and the output is shown below: # rpm -i

RE: Newbie - dependencies

2004-03-11 Thread Robert Ross
Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL database function. I tried and failed using up2date (following instructions from RH), so downloaded the rpms and began to install by myself. My input and the output is shown below: # rpm -i

RE: Newbie - dependencies

2004-03-11 Thread Robert Ross
Medina [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 13:31 To: Robert Ross Cc: [EMAIL PROTECTED] Subject: RE: Newbie - dependencies Hi! anyway, why dont you use the graphic install utility redhat uses to install mysql?? it will resolve the dependencies for you =) PS: i think it's called redhat

RE: Newbie - dependencies

2004-03-11 Thread Robert Ross
You have a previous version of MySQL installed, from the mysql.com RPM's. To get rid of it, do: rpm -e 'MySQL*' first, then: rpm -ivh perl-DBD-MySQL-2.1021-3.i386.rpm mysql-server-3.23.58-1.i386.rpm mysql-3.23.58-1.i386.rpm I tried 'locate' but could not find either file, so then tried

Upgrading from 3.23 to 4.0 Problem

2004-02-19 Thread Ross O
Im trying to upgrade 3.23 on my redhat 9 machine. I have one lone perl-dbd-mysql libmysqlclient dependency that is throwing me off. when i try to upgrade it wont go. so i try to uninstall that perl rpm and it says its mysql 3.23 needs it and when i try to uninstall mysql 3.23 it says the perl

Installation Confusion in Linux

2004-02-17 Thread Ross O
I was able to successfully install MySQL server 4 under windows, but am a little confused about doing it through linux. My main confusion is where the install goes? Im using the rpm, and from my personal directory where i downloaded the rpm to, i issue a rpm -i MySQL-server-...rpm command and

Re: Installation Confusion in Linux

2004-02-17 Thread Ross O
by running rpm -qlp package and dont find mysqladmin or some other important files. did something go wrong during the install? ive tried uninstalling/reinstalling many times. using the find command on mysqladmin yields no results. --- walt [EMAIL PROTECTED] wrote: Ross, rpm -qlp

Re: Installation Question - RedHat 9.0

2003-12-16 Thread Nicolas Ross
For RedHat, just download the rpms and install it, it's far much simpler... Nicolas - Original Message - From: Ryan Sinnwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:21 PM Subject: Installation Question - RedHat 9.0 I am trying to setup Jabberd2 as a

Innodb in production

2003-12-15 Thread Nicolas Ross
Hi ! Our db server has about 140+ db's for a total of about 1.5 gigs of data. Some while ago, for a specific DB, I did testing using transaction tables with bdb. This was a bad experience. I ran into some problems and I had to convert back to myisam. One thing I don't like about innobd and bdb

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-15 Thread Nicolas Ross
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs.

MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table :

Unusual Date Query

2003-10-10 Thread Ross Davis - DataAnywhere.net
versions yet due to incompatibilties with the timestamp formats that were changed. TIA Ross -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Unusual Date Query

2003-10-10 Thread Ross Davis - DataAnywhere.net
That will only return the number of rows in Table1 What I want to return 1 to n rows based on the number of days between date1 and daten with each row having the date filled in. Ross Davis DataAnywhere.net 250-470-9192 ChaletsOnline.com is coming soon Don't you deserve a vacation

RE: table copying/replication

2003-06-05 Thread Ross Simpson
of these (rename and copy) preserve indexes? Each table has ~5 indexes, and I don't want to reindex. Thanks for the ideas Ross On Wed, 2003-06-04 at 02:43, Martin Waite wrote: Run a MySQL replication chain from stage to prod to replicas. On stage, prepare the data on shadow tables with different

RE: table copying/replication

2003-06-05 Thread Ross Simpson
, mysql caches indexes.. what happens when a table's datafile is changed, and hasn't been re-read yet (i.e., the index no longer corresponds to the table)? Does mysql take this into account, or will a query against this table yield incorrect data? Getting there.. thanks for the help :) Ross

another replication question..

2003-06-05 Thread Ross Simpson
slaves will be read-only dbs in a production environment with a lot of traffic, so I need to insure that they can always serve requests. Thanks, Ross -- Ross Simpson [EMAIL PROTECTED] MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

table copying/replication

2003-06-04 Thread Ross Simpson
solved this problem before? Any ideas that would help out? Thanks! Ross -- Ross Simpson [EMAIL PROTECTED] MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: table copying/replication

2003-06-04 Thread Ross Simpson
existing on stage can be copied/replicated/etc over to prod, but _only_ when requested, and then immediately. Any thoughts? Thanks, Ross On Tue, 2003-06-03 at 12:07, Dathan Vance Pattishall wrote: ---Original Message- --From: Ross Simpson [mailto:[EMAIL PROTECTED] --Sent: Tuesday

RE: table copying/replication

2003-06-04 Thread Ross Simpson
possible. Maybe there's a way to dump and reload the indexes as well as the data.. Thanks for the help, and I hope you don't get fired.. I won't tell anyone ;) Ross On Tue, 2003-06-03 at 16:53, Andrew Braithwaite wrote: Hi, Assuming that this system runs on *nix and that prod is set up

create fails with on delete set null

2003-02-21 Thread Ross Davis
(master_id) on delete set null on update cascade ) type=InnoDB; mysql 4.0.10 on Windows XP Pro Anyone else have this problem? Is it a bug? Ross - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: innofb foreign keys problem

2003-01-14 Thread Ross Davis - DataAnywhere.net
I agree with you. If there is no index already on the referenced fields then add one. By adding a foreign key you are already altering the table why not just finish the job. -Original Message- From: Natale Babbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:58 AM To:

Design feature or bug

2003-01-14 Thread Ross Davis - DataAnywhere.net
I have a 3.23.53 server that is a slave of another 3.25.52 server. Master has 2 databases on it. On the slave only only one of the databases is replicated. If I reference the table database that is not on the slave during an insert or something on the server it crashes the slave! Shouldn't the

RE: Design feature or bug

2003-01-14 Thread Ross Davis - DataAnywhere.net
-Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:00 PM To: Ross Davis - DataAnywhere.net Cc: [EMAIL PROTECTED] Subject: Re: Design feature or bug On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis - DataAnywhere.net

RE: Design feature or bug

2003-01-14 Thread Ross Davis - DataAnywhere.net
Unfortunately that won't help me. The slave database is part of of an access system at a ski resort. Missing updates means unhappy customers that are being denied access. Thanks for your help. Ross -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: Replication bug?

2003-01-13 Thread Ross Davis - DataAnywhere.net
I don't think I have anything that should cause this. Here is my my.ini from the the slave. The tables that are being excluded are not listed. [mysqld] basedir=C:/mysql datadir=C:/mysql/data set-variable=max_allowed_packet=16M log-slave-updates log-bin # Replication variables

RE: Replication bug?

2003-01-12 Thread Ross Davis - DataAnywhere.net
: Frederick R. Doncillo [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 10:58 PM To: Ross Davis - DataAnywhere.net Cc: [EMAIL PROTECTED] Subject: Re: Replication bug? Are the slaves doing the replication process? If not, you may try it that way. Slaves should do the updating and must

Replication bug?

2003-01-11 Thread Ross Davis - DataAnywhere.net
I think I have found a replication bug. We are using Mysql-Max 3.23.53 in a master and multiple slave situation. That is working fine. We are using InnoDB We have found a workaround to the problem but I thought you should know about it. We have 2 databases on the system call them dba and dbb.

Best MySQL version for replication

2002-10-14 Thread Ross Davis - DataAnywhere.net
. This will be deployed in just over a week so the path with the least replication issues is the best One for me. Keep in mind that the workstations may be shutdown nightly. Can't control all the users;-) Thanks in advance Ross PS the link from the master to the branch offices is a 10MB/Second wireless link

MySQL 3.23.49

2002-10-11 Thread J Ross Nicoll
I seem to have found a bug in MySQL 3.23.49 (untested in later versions). It appears that if the server cannot resolve the hostname of an incoming TCP connection, it crashes. I've been testing this under a RedHat 7.2/7.3 hybrid, and only came across the problem because I've managed to somehow

Problem with encode() and decode() functions

2002-10-07 Thread Ross Rannells
(80,97,115,115,119,111,114,100),char(107,101,121)); ERROR 1064: You have an error in your SQL syntax near 'char(107,101,121))' at line 1 Any assistance in solving or finding a workaround for this problem would be greatly appreciated. Ross Rannells Adjunct Professor, Purdue University Donnell Systems Senior

on update problem?

2002-06-06 Thread Ross Davis
When I try to change the id field in the parent table below, I get the error: 1217 - Cannot delete a parent row; a foreign key constraint fails. What have I got wrong? Shouldn't it cascade the changes that were made to the parent down to the child table? This is done with Mysql 3.23.50-max

Re: on update problem?

2002-06-06 Thread Ross Davis
It would seem strange to implement one and not the other? The help does say that you can use it and does keep the create options now. Does anyone know if this will be implemented in the next .5x release? Ross Me writes: Hi! don't think ON UPDATE is supported. The manual : http

Official State of Mysql-Max

2002-01-14 Thread Ross Davis
On the front screen of the mysql site the mysql-Max 3.23.47 is listed as stable. However on the download page it is said to be considered a beta yet? The reason that I am asking this question, is that the Borland Delphi Developers will not release a new version that supports the record

BSD/OS 4.1 binary for MySql

2001-08-09 Thread David Ross
Is the freebsd-elf mysql binary available at mysql.com compatible with BSD/OS (bsdi) 4.1? If not, is there a place to download this binary...or am I stuck with building it myself? Thanks, David - Before posting, please

Dedicated MySQL Application Server

2001-08-02 Thread Bryan Ross
be running on the same machine. Basically to be completely wrapped and only accessible by the application. My question is: is there a relatively simple way of doing this? Bryan Ross Programmer iMustPlay.com mailto:[EMAIL PROTECTED] 818-265-0255 x 236 818-948-1596 Pager

Re: Using symbolic links for databases and tables

2001-07-31 Thread ROSS MCCORMICK
restarted. Any ideas what might be going on? Thanks, Ross McCormick Division Maintenance Engineer = YOU MIGHT BE AN ENGINEER IF: The sales people at the local computer store can't answer any of your questions. = !DOCTYPE HTML PUBLIC -//W3C//DTD

3.23.39 Solaris binary on Solaris 2.6 (sparc)

2001-06-26 Thread Ross Kendall
binary. The system is: (uname -a) SunOS 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-2 I will be upgrading from binary Distrib 3.22.25, for sun-solaris2.6 (sparc), yes well overdue! Thanks for any feedback. Ross Kendall Technical Developer http://www.bluecarrots.com/ Tel: +44 (0) 20 7479 2789

RE: JOIN to the same table multiple times

2001-06-08 Thread Ross Goonan
tdfont size=\-1\$r[deptphone3]/td tdfont size=\-1\$r[deptfax3]/td tdfont size=\-1\$r[deptemail3]/td tdfont size=\-1\$r[deptmobile3]/td; -Original Message- From: Ross Goonan [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 June 2001 11:47 To: [EMAIL PROTECTED] Subject: JOIN to the same table

JOIN to the same table multiple times

2001-06-07 Thread Ross Goonan
### Creating a Telephone / Information Directory with MySQL / PHP3 People belong to a department a site. Need to be able to: List all people List all people within a Department List all people within a