Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking return type of sprintf... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking return type of sprintf... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hi,
Try,
Compress - [Mac A]
shell mysqldump -all -databases |gzip dbfilename.sql.gz
UnCompress [Mac B]
shell gunzip dbfilename.sql.gz | mysql -u user -p db
Thanks
ViSolve DB Team.
- Original Message -
From: Ratheesh K J [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday,
Hi,
I want to know is there any difference between myisam primary index vs
innodb primary index...
--
Regards,
Lakshmi.M.P.
DBA Support
Sify Limited.
Extn:4134
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is
Hi,
I try to read enums from a database through the prepared statement API, as a
number.
The enum is defined e.g., as ENUM('Accept', 'Reject', 'Reject_All')
The bind structure is filled in the following way:
buffer_type = MYSQL_TYPE_LONG
buffer points to an uint32_t
buffer_length = 4
length
Lakshmi wrote:
Hi,
I want to know is there any difference between myisam primary index vs
innodb primary index...
One's for a myisam table one's for an innodb table.
They are treated exactly the same - both are unique, both have indexes.
--
MySQL General Mailing List
For list archives:
Hi Lakshmi ,
I guess both treated same . But physical structure of storage is
different from Myisam and Innodb .
Correct me if iam wrong .
Lakshmi wrote:
Hi,
I want to know is there any difference between myisam primary index vs
innodb primary index...
--
MySQL General Mailing List
Ratheesh K J wrote:
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on
Nico Sabbi wrote:
Ratheesh K J wrote:
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both
the machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole
Chris wrote:
An additional note - you can only do this while mysql is completely
shut down. You cannot do this while mysql is running on either server.
why is it that I received this mail 3 times? I can understand 2 (one to
my and one to the list), but 3 ...
--
Email.it, the
Hi ,
Could you please tell me , how can i install C++ , mysql driver in Fedora core
5 ?
Is that available for any platforms ? does YUM supports for install mysql c++ ?
please help me , its really urgent .
Thank you,
Shaine.
-
Yahoo! Cars NEW
check out mysql++
I dont think there is a package but configure, make, makeinstall works for me
(on FC5, with mysql++ 1.7.40 and 2.1.1)
- Original Message
From: Shain Lee [EMAIL PROTECTED]
To: MySql mysql@lists.mysql.com
Sent: Tuesday, September 12, 2006 11:31:02 AM
Subject: mysql
Mike,
Oracle Corp. and MySQL AB renewed the InnoDB OEM contract in spring
2006. The licensing of InnoDB is the same as before and it is
distributed in the official MySQL distros.
Best regards,
Heikki Tuuri
CEO of Innobase Oy
VP of Oracle Corporation
Has Oracle placed any
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like this:
where url = 'xxx'.
Or perhaps add a TEXT index to the table?
Peter
On 9/6/06, Philippe Poelvoorde [EMAIL PROTECTED] wrote:
2006/9/5, Ben Lachman [EMAIL PROTECTED]:
So possibly a better solution would be to create a temporary table
and then do a subquery on that table?
yes. Or do a :
SELECT id FROM t1 WHERE
Or you can do this to combine the two steps together
shellmysqldump --all-databases -uuser -ppassword | gzip | ssh
[EMAIL PROTECTED] 'gunzip dump.sql'
Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects
On 9/12/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi,
Try,
Compress
Is there anyone who has EXTENSIVE sql experience that is available for
consulting? This is a short term opportunity for a single project. Maybe an
couple hours tops to assist in some COMPLEX queries that do totals and the
like across multiple tables. This is NOT for an amateur. IF you can handle
I am running mysql 4.1.7 on solaris 9. I want to install 2 versions (versions
4.1.7 and 5) on the server. I am reconfiguring my scripts in that perspective.
I have a script that start the mysql v4 so that I finally have:
7002 pts/4S 0:00 /bin/sh /seqweb/mysql4/bin/mysqld_safe
Hi Peter,
I'd thought I'd just mention that the varchar length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 2083 characters it
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like
Hi,
We just upgraded our server's RAM from 1 GB to 5 GB - I'd like to
now make some adjustments in my.cnf to better tune my server to
this new memory amount. I was looking in the MySQL 4.1.21 source
dir's support-files at the example my.cnf files provided with the
distribution, but these seem
FULLTEXT can only be used with ISAM tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Lakshmi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 3:29 AM
To:
I am receiving some messages an extra time, also. It seems that something is
wrong with the list server.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Nico Sabbi [mailto:[EMAIL
the urls never repeat. and it's a very active table so I don't wanna
compress right now.
And you're right, most URLs are 255chars, but some are bigger, so
can't use varchar.
I guess I'll just use TEXT :)
Thanks!
Peter
On 9/12/06, Mike Wexler [EMAIL PROTECTED] wrote:
Peter Van Dijck wrote:
Overnight (Monday night US time) I was receiving some duplicate messages
(not ones addressed to me specifically). Has this been fixed?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Duhaime Johanne wrote:
I am running mysql 4.1.7 on solaris 9. I want to install 2 versions (versions
4.1.7 and 5) on the server. I am reconfiguring my scripts in that perspective.
I have a script that start the mysql v4 so that I finally have:
7002 pts/4S 0:00 /bin/sh
Thank you for your answer.
Here is what I did
cd
/seqweb/mysqlhome
mercure{mysql}140: more .my.cnf
# The following options will be passed to all MySQL clients
[client]
user= mysql
password=
port= 3306
socket = /tmp/mysql4.sock
# Here follows
Is anyone using subversion to sync live and development databases?
If so, how?
Is this desired or a best practice?
Everything except my databases are under version control.
In theory, I would like my databases to sync with the same subversion
'svn update' command.
That way, all web content
Josh, I highly recommend Jeremy Zawodny's High Performance MySQL
from O'Reilly. It's written for 4.1 users, so would be perfect for
you.
Dan
On 9/12/06, Josh Trutwin [EMAIL PROTECTED] wrote:
Hi,
We just upgraded our server's RAM from 1 GB to 5 GB - I'd like to
now make some adjustments in
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of
memory running FreeBSD 6.1. Its sole purpose in life is to run the
MySQL 5.0.x database engine serving out databases to
I highly recommend Jeremy Zawodny's High Performance MySQL
from O'Reilly.
Dan
On 9/12/06, Gregory T Pelle [EMAIL PROTECTED] wrote:
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs and
I'm searching a database of geopoints, and when two records have the
same latitude and longitude, I only want to return one of them -
basically just find all the unique locations. How do you set up a
select like this? Thanks...
--
MySQL General Mailing List
For list archives:
select * from table where . limit 1
that would do it if you don't care which one it returns
JC
On Tue, 12 Sep 2006, Brian Dunning wrote:
I'm searching a database of geopoints, and when two records have the
same latitude and longitude, I only want to return one of them -
basically
Many different records will be returned though, I just don't want any
dupes where both lat/lon is the same.
:)
On Sep 12, 2006, at 12:20 PM, Hiep Nguyen wrote:
select * from table where . limit 1
that would do it if you don't care which one it returns
JC
On Tue, 12 Sep 2006, Brian
Select DISTINCT(lat_long_field) from table where...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Many different records will be returned though, I just don't want any
dupes where both lat/lon is the same.
:)
On Sep 12, 2006, at 12:20 PM, Hiep
Lat lon are two different fields. Either can be duplicated, but not
both.
On Sep 12, 2006, at 12:33 PM, Steve Musumeche wrote:
Select DISTINCT(lat_long_field) from table where...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Many different
Really you need to look at what your server is doing, the traffic patterns, then you can tune. There is a lot you can determine by
just looking at the output of SHOW STATUS and SHOW VARIABLES.
Threads_created number high and growing? Increase the thread_cache_size
variable.
Opened_tables number
You could try using CONCAT:
select distinct(CONCAT(lat, long)) from table where ...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Lat lon are two different fields. Either can be duplicated, but not
both.
On Sep 12, 2006, at 12:33 PM, Steve
Hi all, a though query problem for me...
I have a table with 2 rows that matter: url and id
If url and id are the same in 2 rows, then that's no good (bad data).
I need to find all the rows that are duplicates. I can't think of how
to approach the sql for this.. any pointers?
Thanks!
Peter
Select COUNT(*) as num_entries, url from table WHERE num_entries1 GROUP
BY url
Untested, but the concept should work for you.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Peter Van Dijck wrote:
Hi all, a though query problem for me...
I have a table with 2 rows that
Hi all, a though query problem for me...
I have a table with 2 rows that matter: url and id
If url and id are the same in 2 rows, then that's no good (bad data).
I need to find all the rows that are duplicates. I can't think of how
to approach the sql for this.. any pointers?
Select
- Original Message -
From: Jay Paulson [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, September 08, 2006 9:51 PM
Subject: Restarting MySQL on Solaris 8?
A couple questions since I'm not a Solaris person I really don't know how
to
do the following and was hoping that
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
Read the comments at the bottom.
DÆVID
-Original Message-
From: ESV Media GmbH [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 8:05 AM
To: mysql@lists.mysql.com
Subject: Getting next Birthdays
Hi,
I have a long list of email addresses, and names in a text file in csv
format, and I want to know what's the best approach to quickly INSERT
them into my customers TABLE.
Initially I thought it could be easy to just add SQL INSERTs to the
database dump but, the problem is I have to
Presuming your csv is set up in the structure of your table - this may help
BULK INSERT tablename
FROM 'C:\filelocation\my_data.csv'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\n'
)
I am going through a SQL class and this is the method we are using to bulk
I have a long list of email addresses, and names in a text file in csv
format, and I want to know what's the best approach to quickly INSERT
them into my customers TABLE.
Initially I thought it could be easy to just add SQL INSERTs to the
database dump but, the problem is I have to manually add
I don't know; never tried it that way
_
From: axis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 9:37 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: What's the best way to INSERT a long list of email addresses
and names into a TABLE?
Dear all,
I've encountered a very strange problem. I dumpped one table from a
database and then import it into another database. I works successfully,
all the data is exactly the same. But when I the below SQL on two tables:
select * from foo_table ORDER BY id DESC
it shows up different result.
50 matches
Mail list logo