From: Sujay Koduri
I guess anywhere we have 3 levels of hierarchies for a phone number.
(Country code, Area code and the actual number).
That's a pretty wild guess IMHO. You have to be absolutely sure that this is
true for each and every country in the world. Furthermore, various telecom
I made an upgrade from Mandrake 10.1 to 10.2. Since, I cannot connect anymore
to the database locally using '127.0.0.1':
[EMAIL PROTECTED] sysconfig]# mysql -u root -h 127.0.0.1
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
I suppose that something has changed
See the release notes:
http://qa.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNotes#MySQL
j- k-
On Monday 25 July 2005 23:43, Pascal Francq said something like:
I made an upgrade from Mandrake 10.1 to 10.2. Since, I cannot connect
anymore to the database locally using
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Subject: Re: Phone Number Storage
From: Sujay Koduri
I guess anywhere we have 3 levels of hierarchies for a phone number.
(Country code, Area code and the actual number).
That's a pretty wild guess IMHO. You have to
Since I make an install, Mandrake has hold the old /etc/init.d/mysql script
(rather than /usr/init.d/mysqld) and the file in /ect/sysconfig/mysql was
not created.
On Tuesday 26 July 2005 09:56, Joshua J. Kugler wrote:
http://qa.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNotes#My
Hi Bruce,
Thanks again for your advice.
I have control over the client access so it a possibility to do what Heikki
is suggesting, additionally I have to do it to a master and slave, I could
always try it on one and if it fails then go down the dump and import route,
this way I wouldn't lose
THe MySQL packages was not well installed. I remove the packages and
re-install them after, the file /ect/sysconfig/mysql appears, and after
modifications, everything works well.
Thanks.
On Tuesday 26 July 2005 10:09, Pascal Francq wrote:
Since I make an install, Mandrake has hold the old
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
Appreciated your help,
Thank you,
Phong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
MySQL doesn't have sequences or storage specifiers.
You cannot run your script directly.
Depending on your current Oracle structure, you might want to give
our
Hi all,
We're trying to get a new 64-bit machine going to get around the memory
limitations of the 32-bit machines we have. On this dual Opteron server with
8GB memory we've installed Fedora Core 4 and MySQL 4.1.13.
Our sysadmin configured MySQL to use a 7GB buffer pool to accomodate a few
big
Nguyen, Phong wrote:
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
You can try our Migration Toolkit which has pretty good support
for Oracle now...
Hi Catalin,
Here are some InnoDB performance tuning tips that may boost
your insert speed:
Catalin Trifu wrote:
...
innodb_buffer_pool_size = 256M
Higher is better, in fact pushing this up to 60%-80% on a
dedicated database would be good. If there are other things
running like a web server,
Christos Andronis wrote:
Hi all,
we are trying to run the following query on a table that contains over 600 million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running for over 10 hours
I recomend to you FabForce DBDesigner 4.x with this tool you can do Reverse
Engineering to a database in oracle, and then once created a model, export
sql to mysql and that's it!
I have made this to some databases in oracle, is really easy do it!
Saludos!
-Original Message-
From:
Hi Jigal!
Jigal van Hemert wrote:
[[...]]
After a while he needed to restart MySQL (made some changes somewhere) and
it refused to do so:
050726 14:13:12 mysqld started
050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of
InnoDB: memory with malloc! Total allocated memory
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2 varchar(255) NOT NULL default ''
Hi Joerg,
From: Joerg Bruehe
Jigal van Hemert wrote:
050726 14:13:12 mysqld started
050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 78086952 bytes. Operating system errno: 12
On my machine (Linux:
On Jul 26, 2005, at 3:56 AM, Marvin Wright wrote:
Regarding the file size issue, we are on a 32-bit system running
redhat AS3,
we already have idb files in excess of 21Gb, I'm not sure what the
limit is
though if any ?
No, typically a 32 bit file system would have limits like 2G or
Hi all,
i try to use the C API but i get a segmentation fault...
my code looks like :
MYSQL mysql;
if( ! mysql_init(mysql) )
exit(0);
if( ! mysql_real_connect(mysql,localhost,user,xxx,,3306,NULL,0) )
exit(0);
if( mysql_select_db(mysql, nomBdd) != 0 )
exit(0);
mysql_query(mysql,SELECT
[EMAIL PROTECTED] wrote:
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2
Sorry to disturb you, i have resolved my problem by using other mysql headers!
Selon [EMAIL PROTECTED]:
Hi all,
i try to use the C API but i get a segmentation fault...
my code looks like :
MYSQL mysql;
if( ! mysql_init(mysql) )
exit(0);
if( !
Michael Stassen wrote:
Sort of. The order of requirements in the WHERE clause is irrelevant.
...
No composite index will be fully used here. MySQL uses composite
indexes from left to right, *stopping on the first key part used in a
range* rather than to match a constant. WHERE latitude
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to upgrade to mysql 4.1.13
(MySQL-server-standard-4.1.13-0.rhel3.i386.rpm) and I'm getting the
usual errors of required dependencies because I need the shared-compat
package.
Problem
Hello list,
I'm having some mysterious problems when I try to migrate several
databases from one server to another one. This
databases contain some InnoDB tables - db size is around ~3GB. On both
servers I'm using MySQL version 4.1.12,
the same kernel version, same libc (2.3.2), but different
I have esentially this query (the list of integers may differ):
SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans` JOIN
`TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE
`TechsPerPlan`.`id` IN (17, 48, 54, 64, 75, 13, 30, 37, 45, 55, 65, 76, 11,
33, 46, 58, 68,
I am trying to find documentation on how to use the new Distributed
Transactions (XA) feature without going through a JDBC driver. According
to a Webinar I just reviewed, the XA protocols are available in the SQL
layer but I am having the hardest time finding documentation on how to
initiate,
Pupeno [EMAIL PROTECTED] wrote on 07/26/2005 03:53:10 PM:
I have esentially this query (the list of integers may differ):
SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans`
JOIN
`TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE
`TechsPerPlan`.`id` IN (17,
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email the list with questions and comments
-Jason Pyeron
On Tue, 26 Jul 2005, Jeff wrote:
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to upgrade
Tim Holmes wrote:
Hello.
You could find the clues in the error log. See:
http://dev.mysql.com/doc/mysql/en/error-log.html
Good Afternoon:
I have rebuilt by web / database server from bare metal this morning.
The computer is running Fedora Core 3, and is fully patched and up to
Thanks!
Jeff
-Original Message-
From: Jason Pyeron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 3:03 PM
To: mysql@lists.mysql.com
Subject: Re: Mysql-shared-compat for 4.13
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email the
[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: test
ERROR 2013 (HY000): Lost connection to MySQL server during query
Hi,
Look at having :
having count(*) 3 for example
Mathias
Selon Pupeno [EMAIL PROTECTED]:
I have esentially this query (the list of integers may differ):
SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans` JOIN
`TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan`
Hello,
How to optimize != statement?
SELECT * FROM table1 WHERE char_255_column != '';
How to fast select all rows, where CHAR(255) NOT NULL column not
empty?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
When I try to install
MySQL-server-4.1.13-0.glibc23.ia64.rpm
MySQL-Max-4.1.13-0.glibc23.ia64.rpm
MySQL-devel-4.1.13-0.glibc23.ia64.rpm
MySQL-debuginfo-4.1.13-0.glibc23.ia64.rpm
MySQL-client-4.1.13-0.glibc23.ia64.rpm
MySQL-bench-4.1.13-0.glibc23.ia64.rpm
I get lots of messages like this:
Error:
Michael Monashev [EMAIL PROTECTED] wrote on 07/26/2005 04:41:28 PM:
Hello,
How to optimize != statement?
SELECT * FROM table1 WHERE char_255_column != '';
How to fast select all rows, where CHAR(255) NOT NULL column not
empty?
Sincerely,
Michael,
You could try
WHERE
I'm using a boolean query to perform an exact match on musicians within a text
field. However, if the musician's name contains a quote, I get inaccurate
results. For example, this query works fine:
select * from feeds where MATCH(feed_title, feed_content) AGAINST('Tom Petty'
IN BOOLEAN MODE)
hello
what command should i type to see all the user connected to the
database.
thank you very much.
rgds,
Joeffrey
--
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
[EMAIL PROTECTED] wrote:
I am trying to find documentation on how to use the new Distributed
Transactions (XA) feature without going through a JDBC driver. According
to a Webinar I just reviewed, the XA protocols are available in the SQL
layer
mysqladmin processlist
On Jul 26, 2005, at 5:21 PM, Joeffrey Betita wrote:
hello
what command should i type to see all the user connected to
the database.
thank you very much.
Rich Allen
Dare Do
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello mysql,
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2
40 matches
Mail list logo