Hi There,
(mysql, query)
>From the online manual I see:
--
innodb_data_file_path
Paths to individual data files and their sizes. The full directory path
to each data file is acquired by concatenating innodb_data_home_dir to
the paths specified here. The file sizes are specified in megabytes,
h
On Wed, Sep 04, 2002 at 10:28:36AM +0530, Sekhar.Thota wrote:
> Hi,
>
> I have did setup for MySQL - Innodb tables. But I am not getting support for
> row level locks. Whenever I am issuing a update the innodb tables are
> locking my tables. Please help me whether I need to set any variables in
>
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
-
That's only if you access it directly from client.
What I was talking about is AppServer sitting next to MySQL
server. Preferably on the same computer.
Agree that for some cascade actions triggers are very useful.
But most of the folks just try to push all business logic
into sp/triggers.
And th
Pada Tue, 3 Sep 2002 19:28:33 -0400
"Bob Davis" <[EMAIL PROTECTED]> menulis :
> I'm trying to do a cross database mysql query. Does anyone know of a way to
> do this? I've looked through all the documentation I can find including
> release 4.0.
what kind of query do want to do ?
shell> mysql -p
Pada Tue, 3 Sep 2002 21:40:44 -0400
"Al Davis" <[EMAIL PROTECTED]> menulis :
> Being new to MYSQL as well as this list, I'm hoping you'll forgive what
> I'm sure will be a rather "dumb" question...
> I just installed mysql on a new install of SUSE 8.0 and every time I try
> to connect to the mysq
I use the 4.x branch for innodb support.
Hrmm, did you download ALL the rpm's? the client, the server and libs i
think.
I suggest backup/dump your databases first before doing a reinstall.
I also strongly suggest you install from the source so you can customize
your installation of MySQL better
As far I know, it would help to leave it set. All the queries executed by
the slave to follow the master have the master's server id associated with
them. The one's which don't have that id will be replicated by the new
slave(old master), there by making the process easier and faster.
Regards,
Bh
Being new to MYSQL as well as this list, I'm hoping you'll forgive what
I'm sure will be a rather "dumb" question...
I just installed mysql on a new install of SUSE 8.0 and every time I try
to connect to the mysql server as a non root use I am denied
access..have changed passwords, granted permiss
Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to:
>>To: Vicky Gonzalez; [EMAIL PROTECTED]
>>Subject: Re: changing a slave to a master in mysql replication
>>bin-log in 'needed' for a server to act as a master. This will make the
server log all it's queries for the slave to fol
I had this problem to but was never able to find what was causing it. The
way I got around it was by doing execute statements like:
connection.execute("INSERT INTO .")
That way I avoided VB handling the updates and it worked. But since Josh
pointed this little problems "solution" out I might g
bin-log in 'needed' for a server to act as a master. This will make the
server log all it's queries for the slave to follow. Don't know of a faster
way.
Regards,
Bhavin.
- Original Message -
From: "Vicky Gonzalez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 03, 20
If this is the first time u r installing mysql, then,
rpm -i mysql.rpm.
If u r updating, then
rpm -u mysqlxxx.rpm should do it.
The binary install is more optimized and hence is the best way to install
mysql, however, rpm's work fine too.
Regards,
Bhavin.
- Original Message -
From: "P
I have just installed redhat linux 7.1 and now need to install Mysql. with
innodb support.
I downloaded the rpm (3.23.51) from the mysql site and tried to install it.
The process appeared to stop mysql and then complained it could not find a
file:
/etc/rc.d/mysql
A query on rpm -qa | grep mysql
http://www.indexcn.com ÖйúÊ×Ò³--ΪÄú´òÔìÆóÒµÉÏÍøÊ×Ò³£¡
Ãâ·ÑÓòÃû£¬.com .net .orgÈÎÒâÑ¡Ôñ£¬
ÏÖÆð·²¹ºÂòÖйúÊ×Ò³¸÷¿îÐéÄâÖ÷»ú¾ùËÍÒ»¸ö¹ú¼ÊÓ¢ÎÄÓòÃû¼ÛÖµ100Ôª£¬¿ÉÖ§³Ö
20¸ö×ÓÓòÃû£¬URLת·¢£¬ÔÚÏßÐÞ¸ÄDNSµÈ¡£
1.Ö»Òª350Ôª£¬¼´¿ÉÂíÉÏÓµÓÐ"Æóҵͨ"Ìײͣº
Currently to make a slave a master, the docs say you need to set the bin-log option in
my.cnf on the slave, and that will make the transition to master quicker. I know I can
manually change a slave to a master by stopping the slave process, stop mysql, take a
snapshot of the databases, copy ove
I'm trying to do a cross database mysql query. Does anyone know of a way to
do this? I've looked through all the documentation I can find including
release 4.0.
-
Before posting, please check:
http://www.mysql.com/manual.php
Tom -
I'll address what I can
I had the same problem with fields being truncated on direct connections (the
problem does not manifest on ODBC table attaches in Access).
IIRC, the way to "solve" this problem is to make sure the "optimize columns
widths" (option 1) in the ODBC properties.
Hello. I'm attempting to install 3.23.52 on solaris 7 from source and am
having issues with the linker not finding libraries in /usr/lib. I'd greatly
appreciate any help as it seems this should be a non-issue.
phantom% gcc -v
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/s
Reconfiguring without the --with-mysqld-ldflags=-all-static switch resolved
the issue. Any idea why the recommended configuration does not link properly
in my case?
Thanks,
Christian
-
Christian Gilmore
Technology Leader
GeT WW Global Applications Development
IBM Software Group
I've been monitoring slow-queries.log to try and find
querys that might be causing problems. I see the
following logged:
# Time: 020903 16:59:14
# User@Host: cfweb[cfweb] @ storm.centurytel.net
[10.10.1.17]
# Query_time: 47 Lock_time: 0 Rows_sent: 5
Rows_examined: 145240
SELECT
On Tue, 2002-09-03 at 05:24, Victoria Reznichenko wrote:
> MTW> I just installed MySQL from RPM and can connect to it via shell using
> MTW> the MySQL command, but I can't get anything else to connect to it.
> MTW> MySQL Connection Failed: Can't connect to local MySQL server through
> MTW> socke
Hello !
Mysql 4.03 crash on my linux server...
./resolve_stack_dump -s /tmp/mysqld.sym -n mysql.stack
0x80c84fa handle_segfault__Fi + 450
0x13bae5 (?)
0x80f33bf create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUl + 355
0x80f31fe
create_tmp_table__FP3THDP15TMP_TABLE_PARAMRt4List1Z4ItemP8st_o
Hi Everyone:
Can UDFs be written for Microsoft 2000? Many of the posts I read on the
newsgroups contradict each other. It seems that support was added by a
patch from Ralph Mason, but I can not be sure.
I am using 3.23.52 and VC6. I was able to make a dll of the udf I wanted
to add. I assum
At 14:25 03/09/02 -0400, Tam, Michael wrote:
Hi,
>I just tried 4.0.3beta and it doesn't seem to address the bind-address
>problem at all.
>When I include the option in the ini file and run "mysql-max-nt --help",
>it stops showing the variables when it reaches "bind-address" variable and a
Victoria Reznichenko writes:
> Hi!
>
> Indeed I could repeat it :(
>
> In addition, MySQL crushes if the table is not empty. Subscriber
> provide ALTER TABLE .. with a column name that already exists.
>
> So I modify test case a little to:
>
> CREATE TABLE `users` (
> `ID` int(10) unsigned NOT
Wouter,
- Original Message -
From: "Wouter Zelle" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 03, 2002 7:43 PM
Subject: InnoDB locks disappear
> My program uses locks to allow for multi-threading (processing
> requests that are stored in the database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 03 September 2002 18:44, Matthew Scarrow wrote:
> According to the documentation under section 4.3.9 to get openssl
> working with mysql you need to configure mysql with the --with-vio
> --with-openssl.
That's correct.
> When I add the a
At 12:44 -0400 9/3/02, Matthew Scarrow wrote:
>According to the documentation under section 4.3.9 to get openssl
>working with mysql you need to configure mysql with the --with-vio
>--with-openssl.
>
>When I add the as arguments to ./configure and then compile it I get
>a mysqld that will run
On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote:
> And here is my update query:
>
> update vbooth_data set optionText='Not at all, I'm waiting for the other shoe
> to drop' where (pollID='34' AND voteID='3');
>
> When I hit Enter, it gives me this prompt:
>
> '>
This prompt indicates y
> I have a query which is more complex (taking advantage of relational
> databases more) than I have ever done before... and I'm not sure where in
> the docs to be looking for examples.
>
> I have three tables...
>
> cd (id, title, etc)
> artist (id, name)
> cd_to_artist (cdid, artistid)
>
In
Heey Folks,
I've got this small problem... I'm working on a site (www.esctoday.com). In
runs on PHP and MySQL. The remote server has some linux version, for local
testing of scripts I use Windows 2000. And now the problem, when I run a
create tables script on windows 2000 it changes the capitaliz
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up with the following message:
Th
> From: Buddy Bell <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: mysql_real_connect - capi
> Date: 03 Sep 2002 04:05:24 -0400
>
> I am using c to write some basic mysql programs and I cannot seem to get
> past mysql_real_connect. I get an access denied message. It does not
> recognize
Thanks everyone!
I see that I need double quotes now.
I received about 12 different personal emails from various people with exactly
the same answer. Thanks again!
On Tuesday 03 September 2002 10:31, Matthias Trevarthan wrote:
> Howdy,
>
> I'm trying to perform an update on a php poll table.
>
At 17:10 +0200 9/3/02, mixo wrote:
>sql,query
>
>Is there a way to find out what the value of the last entry just made
>in a mysql table where the field is being auto incremented?
SELECT LAST_INSERT_ID();
-
Before posting, plea
Howdy Matthias,
update vbooth_data set optionText='Not at all, I'm waiting for the other
shoe
to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'>
Two things:
1 (the >) is because it is waiting for the end of the string - you have an
apostrophe opening t
According to the documentation under section 4.3.9 to get openssl
working with mysql you need to configure mysql with the --with-vio
--with-openssl.
When I add the as arguments to ./configure and then compile it I get a
mysqld that will run but try to do anything with it and the client
freez
Hello,
> > I am developing an aplication where I need format the date for
> > inserting into mySQL.
>
> =what language is your application written in?
> =dn
The application is written in Java, but the problem is that the module
where the dates for the DB are managed is an open source framewor
You need to escape the ' mark in your string. The query should be:
update vbooth_data set optionText='Not at all, I''m waiting for the
other shoe to drop' where (pollID=34 AND voteID=3);
Note the '' within the string: the first tick escapes the second one.
If you're more comfortable with C-styl
Matthias,
MySQL is letting you know that you have an unterminated string with the
apostrophe. You'll have to either use double quotes to contain the
string "Not at all, I'm waiting for the other shoe to drop", or escape
the apostrophe in the word "I'm".
i.e.
UPDATE vbooth_data SET optionText="No
I can't think of any reason to have that many fields. It really starts
to make the databases structure unmanageable, or at least difficult and
time consuming to manage. It also can make it very difficult to create a
good, flexible search interface.
Filemaker might be an exception because of the
Hi,
You should escape quotes within strings:
Matthias Trevarthan wrote:
> Howdy,
>
> I'm trying to perform an update on a php poll table.
>
> Here is the table description:
>
> mysql> describe vbooth_data;
> +-+--+--+-+-+---+
> | Field | Type
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up with the following message:
Th
Thank you Ken for the answer, but here the cause was different from what
you say. count() works fast enough for innodb as well, expecially if the
query cache feature is turned on. In my case, I used a mysql 4.0.3
compiled from ports, which had a debug option turned on, and it appeared
to be critic
Hello Javier,
> I am developing an aplication where I need format the date for inserting
> into mySQL.
=what language is your application written in?
=dn
> With DATE_FORMAT I can format the mySQL date to "my date", but I haven't
> found a good way to format "my date" to the mySQL date.
>
> My
Hi
I'm trying to see how many queries per second I have running in my MySQL server.
I understand that the number i see (Queries per second avg) is the average since the
time the MySQL Server came up.
The numbers i see below do not make much sense since the number stabilizes around
47 at any g
Buddy,
Tuesday, September 03, 2002, 11:05:24 AM, you wrote:
BB> I am using c to write some basic mysql programs and I cannot seem to get
BB> past mysql_real_connect. I get an access denied message. It does not
BB> recognize the password user combination. I set the usr/pswd up with the
BB> admi
sitnikov,
Friday, August 30, 2002, 8:34:03 PM, you wrote:
>Description:
s> Segmentation fault when starti mysqld with --help
>How-To-Repeat:
s> mysqld --help
I tested it and mysqld --help worked without any problem.
Today Michael Tam reported about crush if he used bind-address
Rolf,
Tuesday, September 03, 2002, 1:57:49 AM, you wrote:
>>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
>>
>>[skip]
>>
>>RH> It "recovers" my table but I end up with only 1030 out of 27497 rows,
>>RH> so that's not a log of help!
>>
>>RH> Running myisamchk -r -e g
hi all,
given a certain id # (eg 4), how would i query the value either side of it
(usually 3 and 5). In theory, yes, it'd be 3 + 5, but in the case of the
following table:
1
4
5
it'd be 1 + 5, and this:
3
4
7
it'd be 3 + 7.
Even more interesting would be obtaining some sort of an error whe
Hi!
> "Miguel" == Miguel Angel Solórzano <[EMAIL PROTECTED]> writes:
>> Hello,
>>
>> I have a very strange problem with all of the Windows versions of MySQL.
>> I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will
>> not work period. Has anyone ran into this problem and
sql,query
Is there a way to find out what the value of the last entry just made
in a mysql table where the field is being auto incremented?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
My program uses locks to allow for multi-threading (processing
requests that are stored in the database using more than one thread
and/or application). The problem is that the locks disappear for
seemingly no reason at all. The same queries are repeated over and
over again until the lock just vani
Neal,
> Sorry for the MySQL newbie question ... but are there not primary/foreign
> key constraints in MySQL 3?
In MyISAM tables or ISAM tables no.
> I can't imagine that this is right. Perhaps
> I'm just overlooking something
innodb?
(mysql query)
DSL
Hi Alexander,
I believe that the the 'count()' function works differently under
INNODB type tables. With MyISAM count(*) is stored in a 'table
status' area, but INNODB must scan the tables and count the rows
(very slow). All other types of queries should perform much better
for you, but 'coun
Howdy,
I'm trying to perform an update on a php poll table.
Here is the table description:
mysql> describe vbooth_data;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
|
Hello,
I am developing an aplication where I need format the date for inserting
into mySQL.
With DATE_FORMAT I can format the mySQL date to "my date", but I haven't
found a good way to format "my date" to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the
Hi,
I have a table with this structure:
CREATE TABLE dats (
id INT UNSIGNED NOT NULL,
id_ref INT UNSIGNED NOT NULL,
start DATE NOT NULL,
endDATE NOT NULL
)
Now I am trying to create a query that will give me all intervals for which
the table does not con
I have just installed redhat linux 7.1 and now need to install Mysql. with
innodb support.
I downloaded the rpm (3.23.51) from the mysql site and tried to install it.
The process appeared to stop mysql and then complained it could not find a
file:
/etc/rc.d/mysql
A query on rpm -qa | grep mysql
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
What is the limit on amount of fields in a MYSQL table.
Access / lotus will only do 255, whereas Filemaker will do over
Hopefully someone will tell me it is more than 459 (that is what I need in
mine).
Thanks
Brian Leyland
-
It think MySQL could very well have corrupted the data back in 3.23.38 for Marian
when I first started out using mysql, I was fairly new to linux and totally new to
MySQL
MySQL default install went to /var/lib/mysql, default RedHat /var is quite small
So unknowingly to me, it filled up quite q
Sekhar,
do your updates have good indexes through which they can access only the
rows they are going to update?
>From section 8.4 of http://www.innodb.com/ibman.html:
"
UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock on every
record the search encounters
"
>From section 8.5:
"
Hi Tod,
> What happens if you escape the string first, like with DBD's quoting
> function?
Sorry i don't know it, how should i use this function?
> Still, the error message is a bit odd. Perhaps it isn't even
> Mysql's fault...
> How are you connecting?
Using the mysql client.
thx
Derk
Javier,
- Original Message -
From: "Javier Diaz" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Cc: "[EMAIL PROTECTED] (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, September 03, 2002 12:32 PM
Subject: RE: Inno DB Question
>
> Heikki,
>
> Thanks for your answer. I was yeste
Forwarded Message:
> To: Martin Brülisauer <[EMAIL PROTECTED]>
> From: [EMAIL PROTECTED]
> Subject: Re: MySQL 3.23.52
> Date: Tue, 3 Sep 2002 14:15:42 +0200
> -
> Your message cannot be posted to [EMAIL PROTECTED] because it did not
> follow the format expected by our spam/off-topic filter. T
turn them back into numbers with a math function
ORDER BY ABS(value)
> -Original Message-
> From: Jürgen Müller [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 5:23 PM
> To: [EMAIL PROTECTED]
> Subject: Add: Problem with ORDER BY
>
>
> I've changed my query to:
>
> $order =
I've heard that MySQL 4.x can use raw devices on Linux, I'm curious to
learn more. Are some speed tests available? Where I can find
documentation?
I can realize InnoDB tablespaces can benefit from bypassing the
filesystem overhead, but one of MySQL advantages is it's based on files
you can move/
Kai,
Tuesday, September 03, 2002, 3:09:45 PM, you wrote:
KV> is there any single MySQL script that would backup my complete database?
What about mysqldump?
http://www.mysql.com/doc/en/mysqldump.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This emai
neal,
Tuesday, September 03, 2002, 4:06:37 AM, you wrote:
n> Sorry for the MySQL newbie question ... but are there not primary/foreign
n> key constraints in MySQL 3? I can't imagine that this is right. Perhaps
n> I'm just overlooking something
Foreign keys constraints is supported in InnoD
Ramanathan,
Saturday, August 31, 2002, 3:54:27 PM, you wrote:
RPS> I have two connections open to a mysql-nt server. I am using one
RPS> connection to add a field field to a table using the command
RPS> ALTER TABLE testtable ADD testfield int;
RPS> Now if I issue any query from the second
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
-
use mySQLdump.
c:\mysql\bin\mysqldump.exe
there is a switch for dumping the whole DB.
heh,
.b
> -Original Message-
> From: Kai Vermehr [mailto:[EMAIL PROTECTED]]
> Sent: 03 September 2002 13:10
> To: MySQL List
> Subject: script for complete Database dump?
>
>
> is there a
Hi
I'm new to mysql and i'm trying to understand the privileges table.
With the following configuration of the user table
+---+--+
| host | user |
+---+--+
| % | robber |
| 192.168.0.
is there any single MySQL script that would backup my complete database?
thanks! Kai
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi,
I would like to know if you could help me to solve the following
problem:
The application I developed needs to run several selects, inserts and
updates all the time. When the clients are selecting data, mySql runs
the selects at the same time, but when an update command starts
executing, all
On Tue, 2002-09-03 at 13:22, Matt Hargraves wrote:
> Tried RedHat versions from 7.0 to 7.3, none of them will run, install any
> other distro, it works from the start. Don't matter whether it's MySQL 3.x
> or 4.x, it won't work for me or anyone else I know with RedHat.
I am running mysql 3.23.49
I personally have never had a problem with Redhat.
Andrew try this:
grant all privileges on *.*
to 'amp'@'%'
identified by 'blah'
(with grant option)
;
let me know if it works.
- Original Message -
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Andrew Pierce" <[EMAIL PROTECTED]>; <[EM
> >>
> >>
> >
> >I usually just copy the complete DB directory from one
> computer to another
> >one. With fast ethernet it takes around 5-10 minutes (30
> minutes if I have
> >to backup the table where I store images). Only thing is
> that mysql can't
> >write to the table currently being
I believe that your problem is specifically with RedHat. I've ran it on
just about every incarnation of Linux from Mandrake to Gentoo. The only one
that I have ever had a problem getting MySQL to run on was RedHat 7.x and
I've even run it on things like OpenMosix (www.openmosix.org) and Scyld.
T
Hi all,
I just tried 4.0.3beta and it doesn't seem to address the bind-address
problem at all.
When I include the option in the ini file and run "mysql-max-nt --help",
it stops showing the variables when it reaches "bind-address" variable and a
window pops up with the following message:
Th
I have a new installation of RedHat 7.3 and MySql. I had MySql working
great on a Mandrake 8.0 installation. Now that I have reloaded this box
with RH, I cannot get setup and working.
I can run mysql as root and get in. I ran the commands below:
>grant all on * to amp identified by 'blahdblah';
Hello.
It's anew me.
And how linking under Win32 with --with-mysqld-ldflags=-rdynamic?
I need UDF.
Thanks in advance.
Nick.
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hello!
Erlend Hopsø Strømsvik wrote:
>
>
>>-Original Message-
>>From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]]
>>Sent: 3. september 2002 11:59
>>To: [EMAIL PROTECTED]
>>Subject: MySQL Backup
>>
>>
>>Hi, can someone point me in the right direction please
>>regarding
> -Original Message-
> From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]]
> Sent: 3. september 2002 11:59
> To: [EMAIL PROTECTED]
> Subject: MySQL Backup
>
>
> Hi, can someone point me in the right direction please
> regarding backing up
> a MySQL database using Veritas
Xavier,
select
ID,
description,
if (ifnull(date1, 20201231) < ifnull(date2, 20201231), ifnull(date1,
20201231), ifnull(date2, 20201231)) as date
from MyTable
order by date
I didn't test it, but it should work.
Any questions? don't hesitate to ask.
Best regards,
Mikhail.
- Original Mess
Hi, can someone point me in the right direction please regarding backing up
a MySQL database using Veritas 8.6 on a Windows 2000 server?
Is there a script I can use to dump the database to a cold file where I can
back it up off-line or are there agents available to enable me to back the
database
Heikki,
Thanks for your answer. I was yesterday making other tests using dbExpress
components and the only way that I found so far to get the dbExpress
components working on transactions on MySQL is using the method ExcuteDirect
of the TSQLConnection. This is the code :
TSQLConnection *Conn;
C
Matt,
Monday, September 02, 2002, 8:33:36 PM, you wrote:
MTW> I just installed MySQL from RPM and can connect to it via shell using
MTW> the MySQL command, but I can't get anything else to connect to it.
MTW> MySQL Connection Failed: Can't connect to local MySQL server through
MTW> socket '/tmp
Bill,
Tuesday, September 03, 2002, 6:08:57 AM, you wrote:
BF> I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I
BF> rebooted later for another reason. Now I can't start the daemon. I tried
BF> deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. A
Hi,
I have a query from tables that give me records with two date "date1" and
"date2". How can I order the records by the most recent date (between the
two date) for each records ? Example:
Data:
IDdescriptiondate1date2
1 aaa09/03/02 09/05/02
2
Thank you very much for help.
Nick.
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL
Hi,
I've just ran a benchmark test to compare Innodb and MyISAM, and I just want some
input from you guys which already using Innodb ;-)
I have two tables : same definition and same records
Innodb table name : CUSTOMER
MyISAM table name : CUSTOMER2
and this is what I found on my queries :
-
At 08:41 03/09/02 +0100, Chuck Amadi wrote:
Hi,
>Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error
>occurred during the move data process: -103
Shutdown the current installed server or install 4.0.X on another
directory.
>Component Servers
>File Group:
>File:
>Thus i unzi
I am using c to write some basic mysql programs and I cannot seem to get
past mysql_real_connect. I get an access denied message. It does not
recognize the password user combination. I set the usr/pswd up with the
admin progrram and can get into mysql fine. One thing I noticed on the
error mes
Hi,
why innodb queries work MUCH slower (100 times) than if the table was of
myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor
outputs many messages like the following, why are they there and what do
they mean?
Purge done for trx's n:o < 0 782 undo n:o < 0 0
Total number of
Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error
occurred during the move data process: -103
Component Servers
File Group:
File:
Thus i unzipped mysql-4.0.2-alpha-win.zip into C:\mysql and the above
happened I am using excessivly MyODBC to connect to M$ Access 2000
fro
98 matches
Mail list logo
