At 22:24 -0700 8/30/02, Jefferson Cowart wrote:
>I just downloaded 3.23.52 from the mysql servers and the version of
>mysqlbinlog in there doesn't have the -d option you are talking about.
It appears to have been added in 4.0.2.
--
I just downloaded 3.23.52 from the mysql servers and the version of
mysqlbinlog in there doesn't have the -d option you are talking about.
Thanks
Jefferson Cowart
[EMAIL PROTECTED]
Support Open Instant Messaging Protocols
http://www.petitiononline.com/openIM/petition.html
> --
urSQL from http://www.urbanresearch.com/ursql -- I mostly use urSQL as a
development tool for ad hoc queries and reports and stuff -- as well as
some basic "admin" tasks...
On Fri, 30 Aug 2002, neal wrote:
> What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI?
> Other?
>
> W
At 15:29 -0700 8/30/02, Vicky Gonzalez wrote:
>Hi,
>
>Does anyone know what protocol is used for the mysql replication
>process? Is it TCP or something proprietary?
It *can* use TCP, but that's just the transport protocol through which
the replication information is processed. Replication can a
At 17:05 -0700 8/30/02, Jeremy Zawodny wrote:
>On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote:
>> Howdy,
>>
>> Before I run off and try it, can anyone offer up any problems with
>> doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB
>> of DB tables from a slave
Where can I get a new version of that program without having to upgrade
all of mysql? Will that work?
Thanks
Jefferson Cowart
[EMAIL PROTECTED]
Support Open Instant Messaging Protocols
http://www.petitiononline.com/openIM/petition.html
> -Original Message-
> From: Jere
On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote:
> Howdy,
>
> Before I run off and try it, can anyone offer up any problems with
> doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB
> of DB tables from a slave to a tape?
That should work. I assume you're going to
On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart wrote:
>
> Is there a way to parse the binary update logs and get separate
> binary files for each database? I am hosting mysql databases for
> people and I want to be able to give each of them binary logs but
> only want updates for their
Is there a way to parse the binary update logs and get separate binary
files for each database? I am hosting mysql databases for people and I
want to be able to give each of them binary logs but only want updates
for their DB in the logs they get. I understand that streaming these
might be hard, b
Hi,
Does anyone know what protocol is used for the mysql replication process? Is it TCP or
something proprietary?
Thanks!
~Vicky
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hasan,
You can use MyODBC for this.
Kerry
> -Original Message-
> From: Hasan Ozduru [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 14, 2002 10:35 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: About transferring database
>
>
> Dear MySQL company,
>
> How can
Neal,
I use Webmin. It has a MySQL module that allows you to create and drop
tables as well as view, edit, add, and delete the records in the tables. I
run it on a Linux box and it has other admin features for the rest of the
system as well.
Todd
-Original Message-
From: neal [mailto:
I've changed my query to:
$order = "SUBSTRING_INDEX(objektname,'-',1)";
$order .=
",RIGHT(objektname,(LENGTH(objektname)-LOCATE('-',objektname)))";
so that the syntax ist okay, and the tests too:
mySQL returns the correct values:
objekt SUBSTRING_INDEX(objekt,'-',1) LENGTH(objekt)
LOCATE('-'
I've changed my query to:
$order = "SUBSTRING_INDEX(objektname,'-',1)";
$order .=
",RIGHT(objektname,(LENGTH(objektname)-LOCATE('-',objektname)))";
so that the syntax ist okay, and the tests too:
mySQL returns the correct values:
objekt SUBSTRING_INDEX(objekt,'-',1) LENGTH(objekt)
LOCATE('-'
True, I hadn't considered that mysql will just create the indexes as it
loads the data back in. That increases the time for inserts by a
fraction of a second at most, but multipled over a large enough scale,
it's unnecessary. Even if I load the data and then create or rebuild
the indexes, it's s
Hello,
I have a colum as varchar with entries like
MD1-1, SD1-10, MD1-4354, KD2-998, ...
Now I have a problem with sorting them, because they are treated as a
string (f.e. MD1-1 is bigger than KD-998).
My order query:
$order = "SUBSTRING_INDEX(b.objektname, '-', 1)"; // getting everithing
left
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
> Date: Fri, 30 Aug 2002 14:02:51 -0500
> From: Jeremy Tinley <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Tape backups from live slave
>
> Good question,
>
> a) The slave does not have the free space to make a dupl
phpMyAdmin
Great tool.
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 4:07 PM
Subject: Remote admin app?
> What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI?
> Other?
>
> What's most popular and
At 21:13 +0100 8/30/02, Mike Hall wrote:
> > b) I have 200 tables. I don't want to have to recreate indexes for
>> every table if I have to restore. I'd rather spend an hour restoring
>> from tape and let replication catch me up.
>
>Why would you have to recreate the indexes? The dump will co
At 20:50 +0300 8/30/02, Andrew Sitnikov wrote:
>Hello mysql,
>
>Can not start mysqld with --defaults-file
>
>>mysqld
>>--no-defaults--defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.cnf
>
>/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/bin/mysqld: ERROR:
>unknown variable
>'defaul
if a web based solution is possible for you, use phpMyAdmin.
http://phpwizard.net/projects/phpMyAdmin/
//mikezero/
//radiotakeover
neal wrote:
>What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI?
>Other?
>
>What's most popular and why?
>
>Thanks!
>Neal
>
>
>---
What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI?
Other?
What's most popular and why?
Thanks!
Neal
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hello,
I have a table, not too large (200,000+). It crashes all the time. I
should qualifiy that: it crashes when I perform updates to it. I can
qualify that further, and say that it crashes when I update certain fields.
One more thing, the fields that it crashes seem to all be part of a fullt
> b) I have 200 tables. I don't want to have to recreate indexes for
> every table if I have to restore. I'd rather spend an hour restoring
> from tape and let replication catch me up.
Why would you have to recreate the indexes? The dump will contain this
information in the CREATE statements.
Hi,
No, it does not support stored procedures.
Best regards
Andrey Hristov
- Original Message -
From: "Kepa Zalbide" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 10:56 PM
Subject: MySQL : Store Procedure
>
>
> Good morning
>
> Does MySQL support store pro
I'm sorry, I guess I should make sure the query syntax is correct when asking a
question... Here it is with the correct
field names:
SELECT main.*
FROM kw_table, kw_table AS kw_table1, main
WHERE kw_table.keyword LIKE 'first word%' AND kw_table1.keyword LIKE '2nd word%' AND
main.id = kw_table.
Good morning
Does MySQL support store procedures ?
My best regards
<<<
Kepa Zalbide
Interlinea 2000
Tlf : 943 639 698 GSM : 649 878 982
www.i2000.es
-
Before posting, please check:
http://www.mysql.com
That is not valid SQL.
a table can't be like something.
I think you ommitted the field name.
I also don't see why you need a join , unless you have duplicate ids.
Gabe wrote:
>First off, please excuse me if this is the wrong list to post this sort of question
>to (and please direct me to the
>a
Good question,
a) The slave does not have the free space to make a duplicate of my
data.
b) I have 200 tables. I don't want to have to recreate indexes for
every table if I have to restore. I'd rather spend an hour restoring
from tape and let replication catch me up.
-J
-Original Message
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
> Date: Fri, 30 Aug 2002 12:36:28 -0500
> From: Jeremy Tinley <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Tape backups from live slave
>
> Howdy,
>
> Before I run off and try it, can anyone offer up any problems with doing
> a LOCK TABLES, FL
I try to install Binary package SGI Irix6.5 mysql-3.23.52
Following documentation I unpacked distribution in /...usr/local/
and created a directory mysql.
When I tried to execute mysql_install_db I got an error message I cannot resolve:
> ./scripts/mysql_install_db
Preparing db table
Prepar
Hello mysql,
Can not start mysqld with --defaults-file
>mysqld
>--no-defaults--defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.cnf
/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/bin/mysqld: ERROR: unknown variable
'defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.c
-
The real cause for the question lays in the problem which occured after
I
upgraded to 4.0.3 WITHOUT recompiling DBI module: the new mysql version
worked without any visible errors, however it was unable to process more
than about 30 queries per seconds, while the normal rate for this
First off, please excuse me if this is the wrong list to post this sort of question to
(and please direct me to the
appropriate list)
My problem:
I have a database of approx. 170,000 records and 1.2 million keywords. Most of my
searches happen fairly quickly using
the format below
However, t
Howdy,
Before I run off and try it, can anyone offer up any problems with doing
a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB of DB
tables from a slave to a tape?
Currently, I redirect the traffic to another slave, and then shut down
this slave to backup the tables and keep repl
>Description:
Segmentation fault when starti mysqld with --help
>How-To-Repeat:
mysqld --help
Server version: mysql-4.0.3-beta-pc-linux-gnu-i686
>Environment:
System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown
Architecture: i686
Some paths: /usr/
On Fri, 2002-08-30 at 10:04, Chad Arimura wrote:
>
> I'm considering inserting all of our web access information directly to a
> mysql table. We have a medium transaction rate, about 4.5 per second but at
> peak it can get a lot higher. We get about 140,000 hits per day on average
> for 1,500 v
There is a way to install the ODBC driver as a service in a NT environment
? In this way if I change the mysql server there is only a place to change
the parameter !
Otherwise if you need to change the mysql server you need to go on each pc
in the network to change the odbc parameter, like data
Hi All -
I'm considering inserting all of our web access information directly to a
mysql table. We have a medium transaction rate, about 4.5 per second but at
peak it can get a lot higher. We get about 140,000 hits per day on average
for 1,500 visitors/day.
I've never doubted MySQL's speed an
OS X 10.2, Mysql 3.23.52
I got past one failure by setting the -ltermcap flag in the configure file
as suggested at macosxhints.com. Now the compile fails due to a missing
header file:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/m
ysql\"" -DDAT
At 11:04 -0500 8/30/02, mos wrote:
>At 07:58 AM 8/30/2002, you wrote:
>>mos,
>>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>
Start by looking at the MySQL documentation:
http://www.mysql.com/doc/en/Query_Cache.html
Read the entire 6.9 section.
It offers quite a bit of i
Hi,
Yes is possible.
You can look in documentation at :
6.1.4 User Variables
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message
Wouter,
Friday, August 30, 2002, 6:59:04 PM, you wrote:
WvV> I've been wondering about something for quite a while now.. I know that it's
WvV> possible in some DBMS's to select a value in some variable, and then in some
WvV> other query use it again. Is this also possiblein MySQL and if so, how?
Wouter,
set @ID = 173633;
select @Name := Name from MyTable where ID = @ID;
select @Name;
Best regards,
Mikhail.
- Original Message -
From: "Wouter van Vliet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Wouter @ Witbier" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 5:59 PM
Sub
At 07:58 AM 8/30/2002, you wrote:
>mos,
>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>
> >>Start by looking at the MySQL documentation:
> >>http://www.mysql.com/doc/en/Query_Cache.html
> >>Read the entire 6.9 section.
> >>
> >>It offers quite a bit of information on how the cache operates, h
Heey Folks,
I've been wondering about something for quite a while now.. I know that it's
possible in some DBMS's to select a value in some variable, and then in some
other query use it again. Is this also possiblein MySQL and if so, how?
Thanks,
Wouter
-
Hi there class myself slightly above noive tipping towards intermediate
anyway i have for several months created db's under MySql 3.23 and
utilised M$ Access with Myodbc been great so far . I have just download
MySql4 to upgrade but i find that Mysql Doc page 2.5.1 Upgrading from
Version 3,23
Hi everyone:
I want to compile a mysql client on sparc Solaris 2.6,
but I have this problem. Is there any solution ?
How-To-Repeat:
>echo $PATH
/usr/sbin:/usr/bin:/usr/sbin:/usr/bin:/bin:/opt/VRTSvmsa/bin:/etc/vx/bin:/usr/pl
atform/sun4u/sbin:/usr/opt/SUNWmd/sbin:/usr/ccs/bin:/opt/libpcap:/usr
We've got a sloppy database that we must import to from another sloppy
database. The slop is due to user data entry and process inconsistencies
- that can't be fixed here.
The query we need to do (loosely) is this:
insert into table B
select SPO, Field2, Field3, etc... from table A
where
Hi,
It seems that the instructuons on
http://www.mysql.com/doc/en/Upgrading-from-3.23.html are contradicting
themselves, or I'm mistaken:
*** first snap ***
Ensure that you don't have any MySQL clients that uses shared libraries
(like the perl Msql-Mysql-modules). If you have, you should recompi
That is as high as an unsigned tinyint can go.
Change it to an int.
Tony Devlin wrote:
>I have a problem with MySQL. I am trying to insert data using INFILE, and
>it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
>further, either by manual insert or textfile insert. I
2002-09-29 = 1973
I suppose dte>1973.
Johnny Withers wrote:
>I'm a bit confused here.. dates are not my strong point..
>I have a table with a date column in it (DATE datatype)
>
>a few values:
>mysql> select dte from images\G
>*** 1. row ***
>dte:
sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:
ss> Description:
[skip]
ss> I got this
ss> MySQL-3.23.52-1
ss> That means mysql is installed successfully.
ss> What is the step by step procedure for post
ss> Installation configuration of MySql server?
Check chapter "2.4 Post-install
Tony,
Friday, August 30, 2002, 1:35:16 AM, you wrote:
TD> I have a problem with MySQL. I am trying to insert data using INFILE, and
TD> it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
TD> further, either by manual insert or textfile insert. I am running MySQL
TD> 3.2
Daniel's,
Friday, August 30, 2002, 3:11:17 AM, you wrote:
DsL> *This message was transferred with a trial version of CommuniGate(tm) Pro*
DsL> I installed Mac OS X 10.2 this last weekend and since then I've been
DsL> having some problems with the security on the MySQL files. I thought
DsL> tha
mos,
Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>Start by looking at the MySQL documentation:
>>http://www.mysql.com/doc/en/Query_Cache.html
>>Read the entire 6.9 section.
>>
>>It offers quite a bit of information on how the cache operates, how
>>you should configure it and so on.
m>
I got it! Sorry, ohh... So simple
The reason for the problem was ofcourse that I did not provide a
--datadir=c:\\mysql\\data parameter, this superseeded the parameter set
in the config file.
Regards
Tobias
Tobias Eriksson
ComOpt AB
Michael Löfmans gata 6
254 38 Helsingborg, Sweden
Direct: +46
I would like to run >2 mysqld-nt at the same time. This is because we
are shipping mysql with our product and then we would like to have the
database installed within our product. And also run separate from any
other MySQL database that might be installed on the system.
When I try to run the comma
rihad writes:
> I digged thru the manual, and tried running mysql with the -O
> max_allowed_packet=16M option as they suggested. Same thing. Exactly
> same line. Always.
>
> I opened up the file in [beep] (a text editor) and can see nothing
> wrong at line 1283716. It's the end of the previous ins
When I try to import a large (~180 mb) dump into mysql
$ mysql -uuser -ppassword db_name < /tmp/all.sql
It dies on me after 2 minutes with this:
ERROR 2006 at line 1283716: MySQL server has gone away
I digged thru the manual, and tried running mysql with the -O
max_allowed_packet=16M option a
Marc,
Is there any record of a startup 'confusion' in the Event Viewer/logs?
Once the machine is started and sitting static, what do you see (of
MySQL/unidentified) in the Services list?
If there is some entry, use a DOS box to stop the service.
Then clear out any reference to the service from R
Tony,
What data type is the "autoindex" field/column?
=dn
> I have a problem with MySQL. I am trying to insert data using INFILE, and
> it works, except that it ALWAYS stop at 255 (autoindex) and will not go
any
> further, either by manual insert or textfile insert. I am running MySQL
> 3.23
From: root
To: [EMAIL PROTECTED]
Subject: I need some help in MySql installation
Description:
I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name is Fi
63 matches
Mail list logo