|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Tuesday, 9 January 2007
|
| store spatial data in mysql CrazyWind 14:29:19 |
| |
Hi everyone,
I'm beginner in Gis,I want to establish a spatial database using MySQL.
But I don't kown hoe to.
Could someone give me the detail steps, or give me a databse that had
spatial data?
thanks.
--
View this message in context: http://www.nabble.com/store-spatial-data-in-mysql-tf2938527.html#a8215529
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| |  3 answer | Add comment |
|
| MYSQL REGEXP help Mike van Hoof 07:49:11 |
| | Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line end) or a v followed by a space.
so it should match:
'b test'
'test b'
'test b bv'
'bv b test'
and NOT
'test bv'
'bv test'
Any idea's?!
Thanks, mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: mike@medusa.nl
Uw bedrijf voor Multimedia op Maat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
|
| mysql backup methods Vitaliy Okulov 06:41:24 |
| | Здравствуйте, mysql.
Hi all. I searching mysql backup script, which detect type of table &
use mysqlhotcopy for MyISAM or mysqldump --single-transaction for
InnoDB.
Also save structure of table in file.
And support recovery for dumped db an tables.
Somebody meet such type of mysqlbackup script?
--
С уважением,
Vitaliy mailto:vitaliy.okulov@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| "DBD::Mysql on Intel Mac i686 (Quadcore)" make problems Ademmler 05:34:14 |
| | Hi folks!
I need all your help. I am trying to install DBD:mysql on an Quadcore
Intel Mac (i686).
My Setup:
Perl 5.8.6(ok)
MySQL mysql-max-5.0.27-osx10.4-i686 (ok)
DBI-1.53 (ok)
I tried on (Version 4) and on DBD-mysql-3.0008.
I can install this on Intel Mac DuoCore, but not on Quadcore.
I have done all the hints (about links, libs, cflags) from www - no
result.
I have done also:
host:~ admin$ PATH=$PATH:/usr/local/mysql/bin/
host:~ admin$ export PATH
host:~ admin$ env . . . for control
While using the configure script I use this:
sudo perl Makefile.PL -cflags='-I/usr/local/mysql/include -Os -arch
i386 -fno-common' -libs='-L/usr/local/mysql/lib -lmysqlclient -lz -lm'
##
I will use the following settings for compiling and testing:
cflags (User's choice) = -I/usr/local/mysql/include -Os -
arch i386 -fno-common
embedded (mysql_config ) =
libs (User's choice) = -L/usr/local/mysql/lib -
lmysqlclient -lz -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ps-protocol (default ) = 1
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
##
Now I try to do start the make cmd and get this:
##
host:~/Desktop/DBD-mysql-3.0008 admin$ make
Skip blib/lib/DBD/mysql.pm (unchanged)
Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged)
Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged)
Skip blib/lib/Bundle/DBD/mysql.pm (unchanged)
cc -c -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -I/
usr/local/mysql/include -Os -arch i386 -fno-common -
DDBD_MYSQL_INSERT_ID_IS_GOOD -g -g -pipe -fno-common -DPERL_DARWIN -
no-cpp-precomp -fno-strict-aliasing -I/usr/local/include -O3 -
DVERSION=\"3.0008_1\" -DXS_VERSION=\"3.0008_1\" "-I/System/Library/
Perl/5.8.6/darwin-thread-multi-2level/CORE" dbdimp.c
dbdimp.c: In function 'mysql_dr_connect':
dbdimp.c:1702: error: 'ulong' undeclared (first use in this function)
dbdimp.c:1702: error: (Each undeclared identifier is reported only once
dbdimp.c:1702: error: for each function it appears in.)
dbdimp.c:1702: error: parse error before numeric constant
make: *** [dbdimp.o] Error 1
host:~/Desktop/DBD-mysql-3.0008 admin$
##
Now I need help - definetly . . .please!
Regards Alex
|
| | 1 answer | Add comment |
|
| Selecting Different Tables Based on Value. Case seems to fail. Altendew 04:18:51 |
| |
Im trying to create one query here. I know why its failing because CASE can
not be used like this, but how could I ever do a query like this.
[CODE]
SELECT b.*
FROM bonus b
JOIN
CASE b.type
WHEN 'custom' THEN 'bonusCustom g'
WHEN 'pts' THEN 'bonusPts g'
WHEN 'ptc' THEN 'bonusPtc g'
END
ON g.bid=b.id
WHERE (b.hits IS NULL || b.hits>0)
ORDER BY RAND()
[/CODE]
Anyway this is possible!
--
View this message in context: http://www.nabble.com/Selecting-Different-Tables-Based-on-Value.-Case-seems-to-fail.-tf2943218.html#a8230082
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 3 answer | Add comment |
|
| Need SUPER Privilidge for UPDATE? Jesse 00:26:56 |
| | I have an ASP.NET app where I'm doing an update, and the user name that I'm
using has the access to do an update. When I execute this command, I get the
error, "#42000Access denied; you need the SUPER privilege for this
operation". Following is my query:
UPDATE Families SET
LastName='a',FathersFirstName='a',MothersFirstName='a',Address1='a',
Address2='',City='a',State='FL',Zip='a',
Donation=0,HomePhone='a',FathersWorkPhone='',MothersWorkPhone='',
FathersCell='',MothersCell='',EMail='jessec@msdlg.com',
UserName='a',Password='a'
WHERE ID=157
I thought that the Password field might be an issue, but I've changed it to
`password`, and that didn't make any difference. Neither did
Families.Password, or Families.`Password`.
Any ideas why I would be getting this error? This same exact query works
fine on another database with the same structure and every thing.
Using version 5.0.22-community-nt. with InnoDB tables.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Monday, 8 January 2007
|
| Strange Crashing Error - Assertion failed: fixed == 1, file item.h, line 1601 Jason J. W. Williams 19:42:46 |
| | Hello,
We've been getting random crashes on our MySQL servers running MyISAM
tables for the last month, its gotten very bad in the last two weeks.
This has occurred on both 5.0.27, 5.1.11 and 5.1.15-nightly20070103.
It crashes the tables with high queries per second. We've fixed the
issue on one of the servers by changing its tables to InnoDB. We can't
do that however on another server, which we turned debugging on
instead. It appears to be an assertion failure, the error message from
the MySQL debugging code is:
Assertion failed: fixed == 1, file item.h, line 1601
Any help is greatly appreciated. Should we report this as a bug?
Best Regards,
Jason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| How to pronounce MyISAM and InnoDB Js 19:36:44 |
| | Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 5 answers | Add comment |
|
| How to access an array variables in a single query VenuGopal Papasani 18:58:57 |
| | Dear all,
I have got an array variable say a[]={"i1","i2",i3""} now i need to get
the values from the database that matches i1,i2,i3 for example
select * from tablename where i1=a[1] and
simillaryly to a[2] and a[3] but my list is too big one more option i can
write it through loop but it takes time.Is there any possibility of writing
a single query to retrieve all that data.
Awaiting your reply
Thanks and Regards,
venu
--
Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю ,
Ю Ю Ю ёЮ Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю Ю .
|
| | 7 answers | Add comment |
|
| Help optimizing this query? Brian Dunning 18:02:31 |
| | This is the query that's killing me in the slow query log, usually
taking around 20 seconds:
select count(ip) as counted,stamp from ip_addr where stamp>=NOW()-
interval 14 day and source='sometext' group by stamp order by stamp
desc;
Here is the table:
CREATE TABLE `ip_addr` (
`ip` int(10) unsigned NOT NULL default '0',
`stamp` date NOT NULL default '0000-00-00',
`country` char(2) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
PRIMARY KEY (`ip`),
KEY `country-source` (`country`,`source`),
KEY `stamp-source` (`stamp`,`source`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Any help please? 
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
|
| high load, tons of data Michael Dykman 17:53:17 |
| | I am leading a project which has us (among other things) migrating
around 4T of data from Mysql 4.0.18 to 5.x.. we are currently
targeting 5.0.27 which seems to be holding up fairly well, although we
still having some issues in a couple of places.
Having put our migration suite through it's many paces (5 distinct
target hosts, multiple databases on each) we have found a few issues
which we have generally been able to address by refactoring our code,
reducing the load of any given query or upgrading to the latest
publicly available patch.
It has been suggested by our systems staff that InnoDB table type is
inherently unstable under MySql 5.x.and MyIsam presents the only
stable route.
Who else out there is dealing with very large amounts of data under
high load and InnoDB who would care to share some heart-warming
stories about how well InnoDB is working out under those
circumstances? Horror stories are also invited... please embellish
with version numbers and any interesting platform notes you might
have.
Our particular albatross is that we are trying to do this on a
combination of of PPC and Intel Macs under OSX 10.4.4
Any input, comments or sympathy cards accepted.
--
- michael dykman
- mdykman@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| Delivery reports about your e-mail Guest 13:23:30 |
| | The original message was received at Wed, 28 Jul 2004 17:49:55 -0400
from [10.95.148.55]
----- The following addresses had permanent fatal errors -----
msql-mysql-modules@lists.mysql.com
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m.gmane.org |
| | 36 answers | Add comment |
|
| Delphi - mySQL SЬren Andersen 12:19:29 |
| | Dear Friends
I have a irritating problem with mySQL installation.
I use
Delphi 6
odcb 3.51
and
mySQL 5.1.12
When I try to store floatingpoint variable from Delphi they are truncated.
I don't know what is the cause to the problem.
I have tried nearly every solution. Nothing help. Can you help me?
Best regards
SЬren Andersen |
| | 2 answer | Add comment |
|
| auto_increase Zhangyouc 06:28:36 |
| | dear all:
whether in MySql ,the data of auto_increase column could't start
from 0, if i want to the data start from a number i seted,how can i do.
another,in the table with auto_increase column,when i sert into a row
record,the auto_column field how can do
with it .
Thank you.
----------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Group Ltd., its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you.
-----------------------------------------------------------------------------------------------
|
| | Add comment |
Sunday, 7 January 2007
|
| FreeBSD chroot problem...Please help!!! VeeJay 15:16:02 |
| | Hello there
I was wondering if someone having great knowledge of FreeBSD chroot system
could give me some help. I trying to run MySQL and Apache under a chroot
envoirnment. But I am getting these errors. Could you please help me to
solve these problems. I have googled a lot but did't find any solution.
Please help!
1. When running MySQL 5.0 in a chroot envoirnment, I get following error:
# chrootuid /chroot/mysql mysql /usr/local/mysql/libexec/mysqld &
[1] 599
# /usr/local/mysql/libexec/mysqld: Can't create/write to file
'/var/tmp/ibPM3e0d' (Errcode: 13)
070107 10:43:49 InnoDB: Error: unable to create temporary file; errno: 13
070107 10:43:49 [Note] /usr/local/mysql/libexec/mysqld: ready for
connections.
Version: '5.0.27' socket: '/tmp/mysql.sock' port: 0 FreeBSD port:
mysql-server-5.0.27
2. When running Apache in chroot envoirnment, I get following error:
# chroot /chroot/httpd /usr/local/apache/bin/httpd
fopen: Operation not supported
httpd: could not open document config file /dev/null
I will really appreciate your kind help!
--
Thanks!
BR / vj
|
| | 1 answer | Add comment |
Saturday, 6 January 2007
|
| Selecting avg()... Ashley M. Kirchner 20:21:38 |
| |
This is a continuation of something I started with a few weeks ago.
So, here's the previous information again:
table: data
+------------+-----------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+------------+-----------------------+------+-----+-------------------+----------------+
| uid | mediumint(8) unsigned | NO | PRI | NULL |
auto_increment |
| temp_f | float(4,1) | YES | | NULL
| |
| temp_c | float(4,1) | YES | | NULL
| |
| windchill | float(4,1) | YES | | NULL
| |
| dewpoint | float(4,1) | YES | | NULL
| |
| time | timestamp | NO | | CURRENT_TIMESTAMP
| |
+------------+-----------------------+------+-----+-------------------+----------------+
This table gets information every minute. And for a '24 hour'
graph, I perform the following select:
select day(time) as the_day,
hour(time) as the_hour,
avg(temp_f) as avg_temp_f,
avg(temp_c) as avg_temp_f,
avg(windchill) as avg_windchill,
avg(dewpoint) as avg_dewpoint
from data
where time > now() - interval 24 hour
group by the_day, the_hour;
And this returns the data I need. However, I'd like a finer grain
select, if possible. For example, instead of it averaging each 60
minute period, I'd like an average per 15 minute. So that I get 4 data
points returned per hour, instead of just one.
Possible?
-- A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| Indexing issue in slave !! Himanshu Raina 20:04:25 |
| | Hi,
I am facing a peculiar problem.When i execute a query on slave server it
doesn't use indexes that have been created and hence read all the records
present in that table.The same query when execute on Master yields proper
results.The table structure , table types are same.What could be wrong?
regards
Himanshu Raina
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| On Duplicate Key Update question Ed Reed 14:27:19 |
| | I use On Duplicate Key Update a lot and I usually use it like this,
Insert Into tablename (myID, Qty)
Values (1034,15),
(6,13),
(5001,1),
(145,20) On Duplicate Key Update Qty=Values(Qty);
This works very well but now I'd like to do something a little
different. I'd like to have a query like this but instead of replacing
the value of the previous Qty I'd like it to take the old Qty and the
new Qty and store the sum of the two values in the Qty field.
Is this possible and can anyone tell me how?
Thanks
|
| | 3 answer | Add comment |
|
| Data types and space needs Olaf Stein 04:46:40 |
| | Hi All,
I have somewhat of a silly question.
If I define a column as int it needs 4 bytes.
Do I gain anything space wise if I restrict the length to e.g. 10, int(10),
or is this only a logical restriction?
Thanks
Olaf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
Friday, 5 January 2007
|
| Varchar limit warning Olaf Stein 23:54:07 |
| | Hi all
If I insert a value to great for a field (e.g. '123456' into a varchar(5)
field), mysql runs the insert without warning or error and cuts of what
doesn't fit.
How can I tell it to launch an error and abort the insert?
Thanks
Olaf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| Re: Varchar limit warning - similar question Olaf Stein 22:38:23 |
| | Thanks
That works nicely.
Why does that not have any effect with numeric values.
E.g. I can insert the same max numbers in a tinyint column then in a
tinyint(1) column,
For example, how do I create a column that only allows 1 numeric value from
0 to 5?
Thanks
Olaf
On 1/5/07 12:52 PM, "ddevaudreuil@intellicare.com"
<ddevaudreuil@intellicare.com> wrote:
You need to set the sql_mode to STRICT_TRANS_TABLES or STRICT_ALL_TABLES. We> set this for the server in the my.cnf file. Be careful, though, because there> are some third-party GUI clients that don't read the my.cnf file and thus> don't set the sql_mode to what you expect. In that case, set it yourself in> the client: > set SESSION sql_mode='STRICT_TRANS_TABLES';> select @@session.sql_mode;> You can read about sql_mode here.> Donna > Olaf Stein <steino@ccri.net> 01/05/2007 12:37 PM> To > MySql <mysql@lists.mysql.com>> cc> Subject > Varchar limit warning> Hi all> If I insert a value to great for a field (e.g. '123456' into a varchar(5)> field), mysql runs the insert without warning or error and cuts of what> doesn't fit.> How can I tell it to launch an error and abort the insert?> Thanks> Olaf>
-------------------------
Olaf Stein
DBA
Center for Quantitative and Computational Biology
Columbus Children's Research Institute
700 Children's Drive
phone: 1-614-355-5685
cell: 1-614-843-0432
email: steino@ccri.net
|
| | 3 answer | Add comment |
|
| how to get (lapse) time in microseconds ? C.R.Vegelin 20:46:18 |
| | Hi List,
I need the lapse time in microseconds.
I have tried various things, like:
SELECT TIME_FORMAT(CURTIME(), '%f');
SELECT TIME_FORMAT(NOW(), '%f');
SELECT MICROSECOND(CURTIME());
but all I get is 0.
What am I doing wrong ?
TIA, Cor |
| | 2 answer | Add comment |
|
| using the 'use' query. Gary Clark 19:59:22 |
| |
Hello,
Running mysqlpp 2.1.1 on Windows XP and 5.0 mysql.
Been trying tracking down what appears to be a leak. A
wee bit bizarre.
I have a column in a mysql database called messageData
is a VARCHAR(4096).
I have the following code extract:
mysqlpp::Query query = _con.query();
mysqlpp::ResUse res = query.use();
mysqlpp::Row row;
try {
if (res)
{
while(row=res,fetch_row())
{
}
}
}
catch (exception & er)
{
cout << "Failed Dude! " << endl;
return 0;
}
Seems straightforward. It always ends up going to
"Failed Dude".
It then pops a leak. I commented out the above code
and it no longer leaks.
Can somebody be so kind to enlighten me on what I
assume to be misuse of the above so I can avoid the
leak.
Thanks,
Garyc
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 11 answers | Add comment |
|
| Any license news? Alessandro Ranellucci 19:58:24 |
| | Hello all,
I found this old thread: http://lists.mysql.com/perl/2651
and I thought that by DBD::mysql 4.00 the dual-license scheme would have
been replaced by the single GPL to comply with MySQL client libraries.
Why is DBD::mysql still distributed under Perl license, given that is
definitely "derivative work" of a GPL library?
Cheers,
- alessandro ranellucci.
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m.gmane.org
|
| | 3 answer | Add comment |
|
| 5.1.14-beta with ssl build failure Duncan Hutty 19:06:12 |
| | I attempted to build 5.1.14-beta with ssl support and it failed (output
below).
It builds quite happily on this system without the ssl support parameter
to configure. Since it appears to fail in an area (timezone system) that
to me seems rather unrelated, I wondered if something odd was afoot.
x86-suse9.3, openssl-0.9.8d, gcc-3.4.6 (or gcc-4.1.1) using:
CFLAGS="-O3" CXX=gcc \
CXXFLAGS="-O3 -felide-constructors \
-fno-exceptions -fno-rtti" \
./configure --with-ndbcluster \
--with-ssl=/usr/local/openssl \
--enable-assembler && make
Any suggestions?
--
Duncan Hutty
System Administrator, ECE
Carnegie Mellon University
gcc -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o
mysql_tzinfo_to_sql mysql_tzinfo_to_sql.o ../vio/libvio.a
../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a
../strings/libmystrings.a -lz -lpthread -lcrypt -lnsl -lm -lpthread
/usr/lib/crt1.o(.text+0x18): In function `_start':
../sysdeps/i386/elf/start.S:115: undefined reference to `main'
mysql_tzinfo_to_sql.o(.text+0x3ab): In function
`Time_zone_system::TIME_to_gmt_sec(st_mysql_time const*, char*) const':
mysql_tzinfo_to_sql.cc: undefined reference to `my_system_gmt_sec'
mysql_tzinfo_to_sql.o(.text+0x3ef): In function
`Time_zone_system::gmt_sec_to_TIME(st_mysql_time*, long) const':
mysql_tzinfo_to_sql.cc: undefined reference to
`localtime_to_TIME(st_mysql_time*, tm*)'
mysql_tzinfo_to_sql.o(.text+0x45f): In function
`Time_zone_utc::gmt_sec_to_TIME(st_mysql_time*, long) const':
mysql_tzinfo_to_sql.cc: undefined reference to
`localtime_to_TIME(st_mysql_time*, tm*)'
mysql_tzinfo_to_sql.o(.text+0x167a): In function `my_tz_find(String
const*, st_table_list*)':
mysql_tzinfo_to_sql.cc: undefined reference to `sql_print_error(char
const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1729):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1749):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1764):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1e91):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1fe9):mysql_tzinfo_to_sql.cc: more
undefined references to `sql_print_error(char const*, ...)' follow
mysql_tzinfo_to_sql.o(.text+0x20e7): In function `my_tz_init(THD*, char
const*, char)':
mysql_tzinfo_to_sql.cc: undefined reference to `THD::THD()'
mysql_tzinfo_to_sql.o(.text+0x2117):mysql_tzinfo_to_sql.cc: undefined
reference to `THD::store_globals()'
mysql_tzinfo_to_sql.o(.text+0x23c4):mysql_tzinfo_to_sql.cc: undefined
reference to `simple_open_n_lock_tables(THD*, st_table_list*)'
mysql_tzinfo_to_sql.o(.text+0x24ed):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x250e):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_warning(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2571):mysql_tzinfo_to_sql.cc: undefined
reference to `global_system_variables'
mysql_tzinfo_to_sql.o(.text+0x25a6):mysql_tzinfo_to_sql.cc: undefined
reference to `close_thread_tables(THD*, bool, bool)'
mysql_tzinfo_to_sql.o(.text+0x25d8):mysql_tzinfo_to_sql.cc: undefined
reference to `THD::store_globals()'
mysql_tzinfo_to_sql.o(.text+0x25f6):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2615):mysql_tzinfo_to_sql.cc: undefined
reference to `THR_THD'
mysql_tzinfo_to_sql.o(.text+0x262f):mysql_tzinfo_to_sql.cc: undefined
reference to `THR_MALLOC'
mysql_tzinfo_to_sql.o(.text+0x2645):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x268b):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x26de):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2748):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2770):mysql_tzinfo_to_sql.cc: undefined
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x28cb): In function
`my_tz_find_with_opening_tz_tables(THD*, String const*)':
mysql_tzinfo_to_sql.cc: undefined reference to
`simple_open_n_lock_tables(THD*, st_table_list*)'
mysql_tzinfo_to_sql.o(.text+0x28fd):mysql_tzinfo_to_sql.cc: undefined
reference to `close_thread_tables(THD*, bool, bool)'
collect2: ld returned 1 exit status
make[4]: *** [mysql_tzinfo_to_sql] Error 1
make[4]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql'
make[3]: *** [all-recursive] Error 1
make[3]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta'
make: *** [all] Error 2
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 3 answer | Add comment |
|
|
