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 mys

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. a:7:{

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 wit

Re: selecting everyting from 2 non-identical tables.

2007-06-19 Thread ross
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&quo

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

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 misma

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.

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_rooms<10 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_rooms<10 AND single_rooms+double_rooms+twi

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: 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: Sent: Wednesday, May 09, 2007 6:56 PM Subject: Re: Query problem On Wed, May 09, 2007

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 = properties.prope

Re: Replication performance questions

2007-03-05 Thread Ross Vandegrift
e! "set long_query_time=1;" doesnt' seem 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

Re: Replication performance questions

2007-03-01 Thread Ross Vandegrift
e've fixed a few data formatting issues that made the select queries slow under certain circumstances, but we're still running into occasional performance problems running the inserts/updates. There are no joins, subqueries, transactions, or any of the usual muck that complicates a performa

Re: Replication performance questions

2007-03-01 Thread Ross Vandegrift
lly on each slave node. Slaves never perform updates. > Also, what type of database are you using? INNODB? MyISAM? If you are > running MyISAM then things can get slow on updates. The table is MyISAM. I searched on google a bit for info on slow updates with MyISAM and didn&#x

Replication performance questions

2007-03-01 Thread Ross Vandegrift
e 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 wi

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 u

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

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.

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 t

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
(7, 8) 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

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 CREAT

Re: Getting the previous months documents

2006-05-02 Thread ross
change the field to DATE? Ross - Original Message - From: "Peter Lauri" <[EMAIL PROTECTED]> To: 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 t

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 whic

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

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

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: Sent: Monday, April 24, 2006 4:46 PM Subject: RE: mysql query browser- editing resultsets Then, as the documenta

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: 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.

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 d

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
uot;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: Sent: Monday, April 10, 2006 11:25 AM Subject

query problem

2006-03-08 Thread ross
(area, and interest). $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

query problem

2006-03-08 Thread ross
(area, and interest). $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? Thank

Optimization suggestions when only using Innodb

2005-12-01 Thread Ross Anderson
es 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_cach

setting expiry date

2005-09-12 Thread ross
et and is in the format 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
Secondly 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 privil

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

Re: Migrating MySQL users

2005-09-04 Thread ross
word') where user='testing'; Query OK, 1 row affected (0.00 sec) But still cannot login: # mysql -u testing -psomepassword testing ERROR 1045 (28000): Access denied for user 'testing'@'localhost' (using password : YES) Thanks a ton for any suggestions! --

Migrating MySQL users

2005-09-04 Thread ross
als do not work. 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 Christ

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 I

Re: MySQL and HIPAA Compliance?

2005-08-05 Thread ross
ea! But didn't you have to store personal information at somepoint? I guess you could do 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 Chr

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` varcha

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 `s

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

2005-07-18 Thread ross
the manual. I haven't tried MySQL AB binaries - 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 empt

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

2005-07-17 Thread ross
| 2 | | Uptime | 64124 | +--++ -- 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 s

Comments on "hot" databases migration

2005-07-11 Thread Anderson, Ross
Thanks in advance, 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 existing

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). I

Deleting records using the 'LIMIT' clause

2004-04-03 Thread Ross Honniball
ork) NOTE : I can't 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.4

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

2004-04-02 Thread Ross Honniball
for me to : 1. Retrieve and save 2. Query 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, A

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

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

RE: Newbie - dependencies

2004-03-11 Thread Robert Ross
om: Victor 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'

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 mysql-server-

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 mysql-server-3.23.58-1.i386.r

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 db

Re: Installation Confusion in Linux

2004-02-17 Thread Ross O
files by running rpm -qlp 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 -ql

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 it

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

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 i

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

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

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 s

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 des

Unusual Date Query

2003-10-10 Thread Ross Davis - DataAnywhere.net
pgrade to the latest 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]

another replication question..

2003-06-05 Thread Ross Simpson
re db? My 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/mysq

RE: table copying/replication

2003-06-05 Thread Ross Simpson
m disk? - iirc, 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 fo

RE: table copying/replication

2003-06-05 Thread Ross Simpson
/ both 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 sh

RE: table copying/replication

2003-06-04 Thread Ross Simpson
ve the indexes from stage if at all 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

RE: table copying/replication

2003-06-04 Thread Ross Simpson
My need is that somehow a table already 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

table copying/replication

2003-06-04 Thread Ross Simpson
nyone 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]

create fails with on delete set null

2003-02-21 Thread Ross Davis
aster (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 m

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

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 0

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: 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: Oka

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 master-host=x.

RE: Replication bug?

2003-01-12 Thread Ross Davis - DataAnywhere.net
From: 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

RE: Replication bug?

2003-01-12 Thread Ross Davis - DataAnywhere.net
Did you ever get any confirmation that it will be added to the official bug list? -Original Message- From: Jason Brooke [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 3:14 AM To: Ross Davis - DataAnywhere.net Cc: [EMAIL PROTECTED] Subject: Re: Replication bug? Yes this is

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

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 s

Problem with encode() and decode() functions

2002-10-07 Thread Ross Rannells
ne 1 select encode(char(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 select decode(char(80,97,115,115,119,111,114,100),char(107,101,121)); ERROR 1064: You have an error in your SQL syntax near 'char(

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

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

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 locki

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 check

Dedicated MySQL Application Server

2001-08-02 Thread Bryan Ross
ay 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

Re: Using symbolic links for databases and tables

2001-07-31 Thread ROSS MCCORMICK
erver has since been 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. = W

3.23.39 Solaris binary on Solaris 2.6 (sparc)

2001-06-26 Thread Ross Kendall
e standard 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

RE: JOIN to the same table multiple times

2001-06-07 Thread Ross Goonan
ptfax2] $r[deptemail2] $r[deptmobile2] $r[sitename] $r[deptphone3] $r[deptfax3] $r[deptemail3] $r[deptmobile3]"; -----Original Message- From: Ross Goonan [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 June 2001 11:47 To: [EMAIL PROTECTED] Subject: JOIN to

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 sit