 | | | MySQL General | | I have a problem with mysql/innodb hopefully someone
here can offer a nice pointer.
our innodb databases got wiped out (oops) and the problem
is the .frm files dont seem to match the structure I compiles a C application which uses mysql library on two RedHat 9.0 machines.
Both machines are using the same GCC and the same MySQL 4.0.16
MySQL-client-4.0.16-0
MySQL-server-4.0.16-0
MySHello--
We 're using Red Hat 's cluster manager (RH AS 2.1 MySQL 4.0.16 RPM). Due
to a problem within the cluster software that we 're working on with Red
Hat the cluster fails over from one nodeI am attempting to interface between a simple C program and MySQL client library but without luck.
I searched the MySQLforum archives to see if there was info specific to this problem. While therHi
i want to update couple of columns like
update tablename
set <value1 >
where columname <value2 >
I want to run query on mysql prompt each time and enter value1 and value2 for diffrent columnAt 14 33 -0600 3/22/04 Daniel Gaddis wrote
>I copied the following from my coldfusion application.log
>
> "Error " "2152 " "03/20/04 " "09 03 13 " "ODBC Error Code S1000 (General
>error) <P > [MySQLDo a mysqldump -d on both machines to make sure the schema and the
indexes in particular are exactly the same. Run "analyze table " on
all tables. Make sure the MySQL conf files (e.g. /etc/my.cnThanks a lot Jigal and Egor - just what i searched for!
Sincerely
Victor
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mIn the last episode (Mar 22) Chris Elsworth said
> Now that 's all well and good and I 'm fairly sure it 'll all work but
> another interesting idea I was wondering over was - can I myisampack
> thJohn McCaskey wrote
> The master pushes data to the slave as soon as it has executed the query
> itself. It is not a periodic push but an asyncrounous push as soon as
> data is ready to be sent. >I finally managed to install MySQL succesfully. I created a simple DB with
two
>different tables. I also created a simple PHP script to list all DBs and
>tables.
>
>However it seems that the Tim
----- Original Message -----
From "Sasha Pachev " <sasha@(protected) >
Newsgroups mailing.database.myodbc
Sent Thursday March 25 2004 7 04 AM
Subject Re Mystifying mysqld memory usagI think you need the DISTINCT operator.
Assuming you haven 't seen it it works like this. Let 's say that your query
asks for a list of all the job titles in your employee table where the job
titStanton Brian wrote
> Shortly after the MySQL 4.0 line went to production I upgraded to mysql
> 4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times
> every month. I 've a >I am trying to get a single result from a database which works fine at
>the sql command line. I have tried several versions of code this being
>the most recent -
...
>No matter what I do I doI have a table of adjectives
+--------+
| word |
+--------+
| green |
| ugly |
| dark |
| evil |
| female |
| male |
| drunk |
+--------+
and I want to select three of tHi!
On Mar 21 Lorderon wrote
> Hi
>
> I also found that when you use JOIN with full-text MySQL don 't
> automatically sort the results by the coefficient of the full-text... when
> you useprogrammer@(protected) wrote
>
> I want to CREATE a TABLE an specify a collation.
>
> If I do
> CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci
> SHOW TABLE STATUS shHi
Is it possible to move the folder "data " where there are all databases to
another hard driver and then create a virtual link using "ln -s "? If yes
is it just shutdown the MySQL server and I think you need to be using
select * from clients_tb where active 'on ' AND first_name LIKE '%ja% ' OR
middle_name LIKE '%ja% ' OR last_name LIKE '%ja% ' "
Your query is looking for names where tA Z wrote
>Thanks for your replies regarding to my previous
>query.
>
>We have encountered another problem
>MySQL 4.0.14 INNODB.
>A table does have an Index on Field1 this field
>(Field1)Jeremy
I am not sure if I have seen benchmarks of this. I think the stripe size is
not very important as long as you make it significantly bigger than the
InnoDB page size of 16 kB.
Since it
> > I have some problmes with MySQL. We have some CHAR columns which after
> > CREATE or ALTER TABLE
> >
> > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> > `media_file_class_id` CHHiya peeps.
I have a table which looks something like this
TABLE1
id something page1 page2 page3
1 "wibble " 1 3 5
TABLE2
id name
1 "hello "
2 "world "
3 "why can 't "
4 "i get "The continuing saga
> Can 't connect to MySQL server on '192.168.13.205 ' (4)
Our sysadmin has been searching in the sources of the MySQL client and came
up with this
The errormessage (4)
I am using the MX04 and PHP 4.3x to auto generate and authenticate a login
page but sessions just seem to be lost on submit???
When I call the login page this session is started -
sess_efHi list
We recently installed a new MySQL server (Redhat 8 MySQL 4.0.18 same as
old machine but with more powerful hardware) and every now and then the
following error appears in the errorlogDear User
the message with following attributes has not been delivered
because contains an infected object.
Sender mysql@(protected) (may be forged)
Recipients office@(protected)
"Nestor Florez " <Nflorez@(protected) > wrote
>
> I have a php web application that has an admin page for inserting course
> records and one for selecting course records 20
> and a client page forIn article <BAY1-F35jWQYwg105xz000042e5@(protected) >
"Pina Kelwin " <kelwinp@(protected) > writes
> Hi
> I have a table with the sales of each product by month (in the format
> yyyymm).
> Fo |
|
|
