On Sun, Feb 13, 2011 at 11:40 PM, Andrés Tello mr.crip...@gmail.com wrote:
I have a test process, which runs in the old server in 35 seconds, the new
server runs the same process in 110.
There is a change of version from mysql 4.1.22 to 5.1.22.
We were stuck at 5.1.22 because higher version
Yup, I'm doing clean tests,lshutdown, and reload mysql each test.
The raid setup is similar, Faster is raid1 with 10k harddisk, slower is raid
10 with 15k.
Metrics show
Old raid
Secuecial writting 1G: 533 mb/s (using dd if=/dev/zero of=1G bs=1024
count=102400)
Secuencial reading 1G: 500 mb/s
I have a test process, which runs in the old server in 35 seconds, the new
server runs the same process in 110.
There is a change of version from mysql 4.1.22 to 5.1.22.
We were stuck at 5.1.22 because higher version give us another issules like
encoding, case sensitivity...
I really belive
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory and now things are working.
But still quite slow.
I do sum() operations over the 22G table. I'm using the latest version of
mysql 4... (I WILL migrate soon, I promise), one thing I have notice
Use indexes before thinking about partitions.
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, July 15, 2010 8:44 AM
To: mysql
Subject: Mysql 4 and or Partitions.
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect its
a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL syntax; check the
manual
execute
statement: $DBI::errstr; stopped;
- md
On Sun, Jul 11, 2010 at 7:50 PM, Grant Peel gp...@thenetnow.com wrote:
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect
its a version syntax
- Original Message -
From: Michael Dykman mdyk...@gmail.com
To: Grant Peel gp...@thenetnow.com
Cc: mysql@lists.mysql.com
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get
- Original Message -
From: Grant Peel gp...@thenetnow.com
To: Michael Dykman mdyk...@gmail.com
Cc: mysql@lists.mysql.com
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: Michael Dykman mdyk...@gmail.com
To: Grant Peel gp
Grant Peel wrote:
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect
its a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL
Michael Dykman wrote:
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you shouldn't need that final semi-colon inside your statement
string.. I have had preparedstatement interfaces give me
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
At 4:12 PM -0800 3/5/08, Garris, Nicole wrote:
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
% needs quotes around it.
I recommend always quoting the username and
I might have misread the original message, but it sounded to me like the person was
looking for earlier software than available via the official download links. I
personally don't have any need for old versions, but I use Giuseppe Maxia's
mysql_sandbox tool to run many different versions so I
Hello,
Where I can find the best stable version 4.xx?
Greetings,
Łukasz Ciszak
http://www.subasta.pl
Hi,
Subasta.pl - Darmowe Aukcje Internetowe wrote:
Hello,
Where I can find the best stable version 4.xx?
Some of the mirrors still have older versions, such as
http://mysql.mirrors.pair.com/
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
In the last episode (Jun 03), Subasta.pl - Darmowe Aukcje Internetowe said:
Where I can find the best stable version 4.xx?
http://dev.mysql.com/downloads/mysql/4.1.html
You should really consider using MySQL 5.0, though.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General
I'm haing a hard time figuring out why you want
an old 4.0 server, when newer better versions
are available.
MySQL 4.0.27 can be downloaded from Softpedia:
http://linux.softpedia.com/progDownload/MySQL-Download-3074.html
On Mon, June 4, 2007 00:44, Baron Schwartz wrote:
Only back to 4.1.x --
On Fri, 2007-04-27 at 09:19 -0500, [EMAIL PROTECTED] wrote:
So if one is doing a full mysqldump every night, all bin-logs can be
deleted after this?
On the slave - Yes. In fact I would highly recommend it before
starting the slave processes again. This will reset the bin log's
'position'
So if one is doing a full mysqldump every night, all bin-logs can be
deleted after this?
If bin-logging is disabled, will master/slave syncing still occur?
David
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
--
-
Scott
Hi,
Scott Haneda wrote:
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
See attached message I just sent
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which binlogs can be purged safely
Hi Scott,
Scott Haneda wrote:
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which
Yes -- sorry for being so general. You can use the binlogs for a)
replication b) replaying changes since your last backup so you get
point-in-time recovery. If you have no replication slaves, just delete
everything older than your latest backup. You can just use 'rm'. If
you use PURGE
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index file.
If you aren't running a slave, then these files are only good for data
recovery purposes. Say a DBA goes crazy and deletes all of the databases
mid-day (too much
So, I take it since I do not have a slave at all, I could safely just
disable this feature altogether?
If I do not need point in time recovery, and the once every 12 hour dump I
do across all databases is ok with me, I suppose I can just disable said
feature? Heck, some of these boogers are a
hi,
we are in the process of moving from our old hosting company to new one.
and I was thinking that it's the best time to move from mysql 4 to version
5. currently, we use php 4.3.4 / mysql 4.0.18 / apache 2.0
where I can expect problems because of difference in versions?
all queries I use
] wrote:
hi,
we are in the process of moving from our old hosting company to new one.
and I was thinking that it's the best time to move from mysql 4 to version
5. currently, we use php 4.3.4 / mysql 4.0.18 / apache 2.0
where I can expect problems because of difference in versions?
all queries I
When I ran version 4, mysql would start as many mysqld process as it
needed. This would vary depending upon how busy it was. As a lay
perosn I will refer to this as the threading model.
I have upgraded to version 5 and notice that no matter what it only
runs 1 mysqld. Everything seems to work
Willy wrote:
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id`
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT
Hello,
I have solved this problem, thanks.
Regards
Willy
- Original Message -
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
show invivisbles feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided to see what I can
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them entirely.
Could you
Graham Reeds wrote:
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I
Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them
(it appears v5 can hold
4096 while v4 max is 255).
The maximum size of a VARCHAR is 255 bytes in MySQL 4.0, and about 64K
characters in MySQL 4.1 and later.
Can you load a v5 server with a v4 script?
Yes, you can generally load scripts written for MySQL 4.x into
MySQL 5.x.
You may also want to use
and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
*
Mon Jun 12 06:53:02 2006
, and watchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
*
Mon Jun 12 06
, and watchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
--
MySQL General
, though I don't have direct access to the machine
(colocated) to verify when it occurs.
There are no crash.logs from MySQL, and watchdog and system.logs
show nothing. I have culled the following panic.log - can anyone
tell if MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
values('Whatchamacallit',
Vincente Aggrippino wrote:
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
In the last episode (Apr 21), Vincente Aggrippino said:
The following query runs fine on my test server at home, running
MySQL 5.0.15, but on my hosting provider's server, running MySQL
4.0.24, it gets a syntax error. Can anyone help me figure out why?
...
insert into product (name, url,
/mnogosearch3235/url.MYD
what`s wrong?anybody can help me?
--
View this message in context:
http://www.nabble.com/symbolic-links-mysql-4-error-on-ubuntu-5.10-t1322625.html#a3528642
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
As I already wrote I try do get a replication running from a mysql-4.1.13
(32bit) master to a 5.0.18 (64bit) slave. It only runs for a few minutes and
then a query hangs.
I think I now found out why:
I modified a multi-table-update that hung to a select. The same query on the absolutely
Jan Kirchhoff [EMAIL PROTECTED] wrote on 02/01/2006 06:31:20 AM:
As I already wrote I try do get a replication running from a
mysql-4.1.13 (32bit) master to a 5.0.18 (64bit) slave. It only runs
for a few minutes and then a query hangs.
I think I now found out why:
I modified a
Jan,
While my query has a cardinality of 23,124*1=23,124 on mysql4,
it has
6,412*34,341=220,194,492 on mysql5 - and takes forever and makes
me
think everything hangs?!
Yep, MySQL improved the SQL compatibility of its join syntax beginning
with 5.0.12, see
Comma separated JOINS strikes again!!!
[...]
Here is where you will find this change documented in the manual:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
I read that page over and over again... probably too late at night.
thanks for that info. Thanks to Peter, too.
Hi,
I am trying to run an sql query such as below to list items=x randomly and
then items != x randomly..
mysql (select * from tablea where item=1 order by rand()) union all
(select * from tablea where item != 1 order by rand());
but the result is not as expected. rand() seems not to be
Hello.
From http://dev.mysql.com/doc/refman/5.0/en/union.html:
ORDER BY for individual SELECT statements within parentheses has an
effect only when combined with LIMIT. Otherwise, the ORDER BY is
optimized away.
Therefore you're getting the same results, because ORDER BY doen't
work
]
---
Gleb Paharenko [EMAIL PROTECTED]
05.12.2005 12:19
To
mysql@lists.mysql.com
cc
Subject
Re: About union sql Mysql 4.x
Hello.
From http://dev.mysql.com/doc/refman/5.0/en/union.html:
ORDER BY for individual SELECT statements within parentheses
HALIL DEMIREZEN wrote:
Hi,
I am trying to run an sql query such as below to list items=x randomly and
then items != x randomly..
mysql (select * from tablea where item=1 order by rand()) union all
(select * from tablea where item != 1 order by rand());
but the result is not as
DEMIREZEN [EMAIL PROTECTED]
cc
Gleb Paharenko [EMAIL PROTECTED], mysql@lists.mysql.com
Subject
Re: About union sql Mysql 4.x
HALIL DEMIREZEN wrote:
Hi,
I am trying to run an sql query such as below to list items=x randomly
and
then items != x randomly..
mysql (select * from
[EMAIL PROTECTED]
05.12.2005 12:19
To
mysql@lists.mysql.com
cc
Subject
Re: About union sql Mysql 4.x
Hello.
From http://dev.mysql.com/doc/refman/5.0/en/union.html:
ORDER BY for individual SELECT statements within parentheses has
HALIL DEMIREZEN wrote:
Michael,
Thank you and all for effort to help.. I solved the problem by giving high
limit numbers such as;
(select * from tablea where item=1 order by rand() limit 0, 1)
union all
(select * from tablea where item != 1 order by rand() limit 0,
1);
Hello.
I do have my data
Check if yum has cleared the data directory, if not, you should be
able to recover the data.
Can I install mysql 5, and it will migrate/work with my existing data?
In my opinion it is a good idea, but be aware of compatibility issues
for your applications
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5.
Can I install mysql 5, and it will migrate/work with my existing data?
Thanks,
-nat
PROTECTED]
Sent: 11/07/2005 03:19 PM
To: mysql@lists.mysql.com
Subject: Linux Yum DELETED mysql 4! Can I install mysql 5 and be on my way?
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5
MySql v3.23 is part of the Fedore Core 3 distribution. MySQL v4.1 only
became standard in Fedora Core 4.
I suspect it's one of the non-Fedora repositories you're using. Check your
logs and also check /etc/yum.repos.d
grep enabled /etc/yum/repos.d/*
Best regards,
Richard Dale.
Norgate
'192.118.68.5-192.118.68.5' for key 2
mysql 4
mysql insert into manager_new
(id_from_hits,from_ip,to_ip,lstupdate,comment) values
(39,'192.118.68.5','192.118.68.5',now(),'added automatically');
Query OK, 1 row affected (0.00 sec)
Is there any change in the way that mysql 5 treats UNIQUE index
'192.118.68.5-192.118.68.5' for key 2
mysql 4
mysql insert into manager_new
(id_from_hits,from_ip,to_ip,lstupdate,comment) values
(39,'192.115.52.5','192.115.52.5',now(),'added automatically');
Query OK, 1 row affected (0.00 sec)
Is there any change in the way that mysql 5 treats UNIQUE index
this insert in each version I get :
mysql 5
mysql insert into manager_new
(id_from_hits,from_ip,to_ip,lstupdate,comment) values
(39,'192.118.68.5','192.118.68.5',now(),'added automatically');
ERROR 1062 (23000): Duplicate entry '192.118.68.5-192.118.68.5' for key 2
mysql 4
open-sourced their compatibility RPM that enables system
administrators to install MySQL 4.x on Red Hat Enterprise Linux (RHEL3)
Operating System with minimal impact.
Baltimore -- August 1, 2005 -- PD Inc. today announced the release of
their MySQL-shared compat RPMs for RHEL3
Hi,
Im using : mysqlclient10-3.23.58-6
,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3.
when i run the following command its gives Error:
[EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start
touch: cannot touch `/var/log/mysqld.log': Permission denied
chmod: changing permissions of
Hello.
You have several problems and they're should be resolved step by step.
First fix the problems with permissions. Usually they're solved by
changing the owner of mysql database to mysql user. Check what's wrong
with /var/log/mysqld.log. It might be necessery to create it manually.
Why
I want to install MySQL 4 on Fedora Core 2.
Questions:
#1. Do I need to uninstall MySQL 3 from the server first?
#2. Where I can get source for MySQL 4?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Jerry Swanson wrote:
#1. Do I need to uninstall MySQL 3 from the server first?
Not really.
#2. Where I can get source for MySQL 4?
At your local 7/11. They usually store it hidden behind the counter along
with the most popular nuclear launch codes.
If they are out of stock, you might
I want to install MySQL 4 on Fedora Core 2.
Questions:
#1. Do I need to uninstall MySQL 3 from the server first?
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
#2. Where I can get source for MySQL 4?
http://dev.mysql.com/downloads/
Go to the page of the version you like to install
.xx version.
See notes about them at:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Jerry Swanson [EMAIL PROTECTED] wrote:
I want to install MySQL 4 on Fedora Core 2.
Questions:
#1. Do I need to uninstall MySQL 3 from the server first?
#2. Where I can get source
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new
On Friday 03 June 2005 03:36 pm, Joey wrote:
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
Joey wrote:
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem
Hello.
I want to upgrade mysql 3 to mysql 4.
At first, you should read:
http://dev.mysql.com/doc/mysql/en/upgrade.html
Search the MySQL lists archives about possible problems which you can
expect. It is strongly recommended to make a backup.
How to remove mysql3 and install
I want to upgrade mysql 3 to mysql 4.
Operating System is Fedore Core 2. Is there any package dependency?
How to remove mysql3 and install mysql 4?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hash: SHA1
Hi All,
I installed a fresh copy of Mandrake Linux 10.0 with MySQL.
I tried to login to MySQL server ,But it says that authorization is failed.
My hostname is localhost and user is root.I entered the root password.
Here is the log :-
Prabath Ranasinghe (by way of Prabath Ranasinghe [EMAIL PROTECTED])
ha scritto:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hash: SHA1
Hi All,
I installed a fresh copy of Mandrake Linux 10.0 with MySQL.
I tried to login to MySQL server ,But it says that authorization is failed.
My hostname is
different.
maybe this can be helpful:
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
From: Prabath Ranasinghe [EMAIL PROTECTED] (by way of Prabath
Ranasinghe [EMAIL PROTECTED])
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Authorizing Problem in MySQL 4 with Mandrake 10
Hello.
See:
http://dev.mysql.com/downloads/mysql/4.1.html
sam wun [EMAIL PROTECTED] wrote:
Hi,
I realised that install mysql 4 thru rpm is the best way for a smooth
installation.
Can anyone please point me to a site where I can download mysql 4 rpm
for Redhat9
Hi,
I realised that install mysql 4 thru rpm is the best way for a smooth
installation.
Can anyone please point me to a site where I can download mysql 4 rpm
for Redhat9?
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc dir, so I created one from my-huge.cnf and
placed it in the /etc
But the
At 11:02 -0600 12/15/04, Randy Paries wrote:
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc dir, so I created one from
init.d on
mandrake 10.1 and mysql 4
At 11:02 -0600 12/15/04, Randy Paries wrote:
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc
Does mysql 4 require file locking? I'm not talking about in the
database -- I know how to lock and unlock tables for data consistency.
I'm referring to the filesystem that the data lives on.
For reasons too boring to go in to, I have a mysql server and I'm keeping
the database files (i.e
PROTECTED] wrote:
Does mysql 4 require file locking? I'm not talking about in the
database -- I know how to lock and unlock tables for data consistency.
I'm referring to the filesystem that the data lives on.
For reasons too boring to go in to, I have a mysql server and I'm keeping
-Original Message-
From: Ravi T
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:49 AM
Subject: Is there any good soul out there who can help me with mysql 4.0.17
replication.
Hi,
I am new to mysql and having some trouble with replication. Simple
stuff like,
1. How to restart the stopped
Hi,
I'm using a kernel 2.4.25 system (Slackware distro) installed
with gcc 3.2.3.
I've tried both 4.0 and 5.0 source tarballs and when
configured with :
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql \
--with-openssl
and compiled, I always end up with:
gcc
Hi!
Marius Stan wrote:
Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
8
Are you sure you _do_ have ncurses devel
Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
lib_termcap.o(.text+0xcc): undefined reference to `__ctype_b'
You could try MySQL 5(it is in alpha state), which comes with stored
procedures, mixing stored procedures and prepered statements could be a
possibility.
About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very
nice. IMHO
Best Regards
On Thu, 2004-03-04 at 23:23, [EMAIL
Hi there, i happened to be peering into the Sybex book on Mysql4 , it was
pretty expensive about 100 AUD is it a good one ? Anyway i had reference to
be able to compile c code into Mysql to add functions into it. Is there
anyway posible to avodi doing this and add it using queries ? Let me know
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top reply all so
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
yes it does. we use a bigint(20) for example.
[EMAIL PROTECTED] wrote:
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
Jeff Mathis, Ph.D.
El Sáb 07 Feb 2004 02:28, escribió:
Mr. Alfredo
Pls, will you give the complete structure as 'create query' of your
database? that will help us to solve your problem.
Pradap
This is the structure of the table that holds the sequential numbers for
various documents that need them:
CREATE
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's.
In my application, I have a table that stores the sequential numbers of
invoices prepared by several stores. Every time a salesman prepares an
invoice for a customer, the system goes to this table, locks it with lock
tables table
Hi all
I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The
database primarily uses MyISAM tables with 60% SELECT statements. The database is used
as a backend for a PHP web application.
Do the following values make any sense?
set-variable= key_buffer=200M
Hello!
Got a database I'd like to know what user/s have
access to this database.
I am able to login to MySQL and can do SHOW DATABASES,
Now, I know there's a user supposedly called kong
using an specific database. How can I tell if that is
so?
I am new to MySQL, being this the 1st time I ever
1 - 100 of 224 matches
Mail list logo