 |
| 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 |
|
|