Re: METAPHON does not exist
Brent Clark wrote: Hiya I got a debian server with mysql 5 and I get the following message. ERROR 1305 (42000): FUNCTION suppor_db2.METAPHON does not exist. Would anyone know how I can fix this. Got the following installed ii libdbd-mysql-perl4.007-1 A Perl5 database interface to the MySQL database ii libmysqlclient15off 5.0.51a-24+lenny1 MySQL database client library ii mysql-client-5.0 5.0.51a-24+lenny1 MySQL database client binaries ii mysql-common 5.0.51a-24+lenny1 MySQL database common files ii mysql-server-5.0 5.0.51a-24+lenny1 MySQL database server binaries ii php5-mysql 5.2.6.dfsg.1-1+lenny3 MySQL module for php5 Kind Regards Brent Clark That's an indication that the application (or user) expected to find a function in that database but did not. Do you have any details about the database `suppor_db2` itself or what the user might have been doing at the time they got the message that you would like to share? -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: METAPHON does not exist
That's a user defined function in the suppor_db2 database. On Mon, Aug 31, 2009 at 10:09 AM, Brent Clark wrote: > Hiya > > I got a debian server with mysql 5 and I get the following message. > > ERROR 1305 (42000): FUNCTION suppor_db2.METAPHON does not exist. > > Would anyone know how I can fix this. > > Got the following installed > > ii libdbd-mysql-perl4.007-1 A > Perl5 database interface to the MySQL database > ii libmysqlclient15off 5.0.51a-24+lenny1MySQL > database client library > ii mysql-client-5.0 5.0.51a-24+lenny1MySQL > database client binaries > ii mysql-common 5.0.51a-24+lenny1MySQL > database common files > ii mysql-server-5.0 5.0.51a-24+lenny1MySQL > database server binaries > ii php5-mysql 5.2.6.dfsg.1-1+lenny3MySQL > module for php5 > > Kind Regards > Brent Clark > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > > -- - Johnny Withers 601.209.4985 joh...@pixelated.net
Re: Suppressing Warnings
Right. Perhaps you could enlighten me as to what I should code to prevent
that warning? It repeats 2,400 times and makes finding the real errors a
pain in the behind.
Victor
On Tue, Aug 25, 2009 at 12:42 AM, peng yao wrote:
> Warning: Can't create database 'spreadsheets'; database exists
>
> This is the answer.
>
> 2009/8/24 Victor Subervi
>
> Hi,
>> I have the following python code:
>>
>> cursor.execute('create database if not exists spreadsheets;')
>> cursor.execute('use spreadsheets;')
>>
>> but it generates this warning:
>>
>> Warning (from warnings module):
>> File "C:\Python25\mysqlConverter.py", line 140
>>cursor.execute('use spreadsheets;')
>> Warning: Can't create database 'spreadsheets'; database exists
>>
>> What do?
>> TIA,
>> Victor
>>
>
>
Re: Database design - help
BobSharp wrote: As a complete newbie in MySQL, I need a database to store URLs related to Tenpin Bowling. There are several Categories ... Equipment Manufacturers, Organistations, (UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching & Instructional websites, etc. There will be some sub-categories. eg: Organistions will have ... Zones of WTBC, National Organisations within the Zones, UK organisations, Disabled Bowling organisations, ... eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues, etc. Can anyone suggest how I should set out tables for this database ? Here's one suggestion Table: URLs: URL_ID URL_TEXT CATEGORY CATEGORY_ID CATEGORY_TEXT SUBCAT SUBCAT_ID CATEGORY_ID SUBCAT_TEXT URL_CATEGORY URL_ID CATEGORY_ID SUBCATEGORY_ID PK: (URL_ID, CATEGORY_ID) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Database design - help
As a complete newbie in MySQL, I need a database to store URLs related to Tenpin Bowling. There are several Categories ... Equipment Manufacturers, Organistations, (UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching & Instructional websites, etc. There will be some sub-categories. eg: Organistions will have ... Zones of WTBC, National Organisations within the Zones, UK organisations, Disabled Bowling organisations, ... eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues, etc. Can anyone suggest how I should set out tables for this database ? -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 13876 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
METAPHON does not exist
Hiya I got a debian server with mysql 5 and I get the following message. ERROR 1305 (42000): FUNCTION suppor_db2.METAPHON does not exist. Would anyone know how I can fix this. Got the following installed ii libdbd-mysql-perl4.007-1 A Perl5 database interface to the MySQL database ii libmysqlclient15off 5.0.51a-24+lenny1MySQL database client library ii mysql-client-5.0 5.0.51a-24+lenny1MySQL database client binaries ii mysql-common 5.0.51a-24+lenny1MySQL database common files ii mysql-server-5.0 5.0.51a-24+lenny1MySQL database server binaries ii php5-mysql 5.2.6.dfsg.1-1+lenny3MySQL module for php5 Kind Regards Brent Clark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Downloading old version of MySQL ?
Hi David, all, David Harrison wrote: > Hi all, > > I'm trying to drag a database through the upgrade process from 5.0.32 > but I keep running into small cross-version compatibility issues. > > [[...]] > > So it looks like I now need a 5.0.34 install to transition through, > but I can't find anywhere on the MySQL site that offers access to > previous releases like that, does anyone know where I can find them ? > > I'm equally open to better solutions to my upgrade approach if anyone > has any :-) > > Cheers > Dave > I'm not sure you really need all these intermediate steps (leave it to others to comment on that), but access to old community packages is here: http://dev.mysql.com/downloads/mysql/5.0.html click "Archives" (top-left dark blue box, close to the end of the list) click "MySQL Database Server 5.0" and find your way further. Note that these are the Community packages only. If you use the (paid-for) Enterprise packages, you should know your access path. HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Unable to configuring multiple Management nodes.
Hi There, I am just trying to configure the two mgmt nodes on two different host but there is some error while starting the ndb_"mgmd". Required information is as follows: Hosts: 192.168.1.107 192.168.1.125 Required configuration for 192.168.1.107: - On 192.168.1.107 : 2 mgmt node(having an entry of another host's mgmt node and itself one). On 192.168.1.107 : 2 mysql node(having an entry of another host's mysql node and itself one). On 192.168.1.107 : 2 data nodes(having an entry of another host's data node and itself one). Required configuration for 192.168.1.125: - As same as required by the host 192.168.1.107 The "config.ini" on host:192.168.1.107 configuration file is as, [NDBD DEFAULT] NoOfReplicas=2# Number of replicas DataMemory=3500M# How much memory to allocate for data storage IndexMemory=1000M # How much memory to allocate for index storage #MaxNoOfConcurrentOperations=1048576 #MaxNoOfConcurrentTransactions= 1048576 #MaxNoOfLocalOperations=1048576 #MaxNoOfConcurrentIndexOperations=16384 #MaxNoOfConcurrentScans=500 #LockPagesInMainMemory=Y # TCP/IP options: [TCP DEFAULT] portnumber=2202 # This the default; however, you can use any # Management process options: [NDB_MGMD] id=1 hostname=192.168.1.107 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles [NDB_MGMD] id=2 hostname=192.168.1.125 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles # Options for data node "A": [NDBD] # (one [NDBD] section per data node) id=3 hostname=192.168.1.107 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles # Options for data node "B": [NDBD] id=4 hostname=192.168.1.125 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles # SQL node options: [MYSQLD] id=5 hostname=192.168.1.107 [MYSQLD] id=6 hostname=192.168.1.125 The "my.cnf" on host:192.168.1.107 configuration file is as, # The MySQL server [mysql_cluster] ndb-connectstring=nodeid=1,192.168.1.107:1186,192.168.1.125:1186 [ndbd] connect-string=192.168.1.107:1186,192.168.1.125:1186 [ndb_mgm] connect-string=nodeid=1,192.168.1.107:1186,192.168.1.125:1186 [ndb_mgmd] config-file=/var/lib/mysql-cluster/config.ini [mysqld] ndbcluster ndb-connectstring=nodeid=1,192.168.1.107:1186,192.168.1.125:1186 The "config.ini" on host:192.168.1.125 configuration file is as, [NDBD DEFAULT] NoOfReplicas=2# Number of replicas DataMemory=3500M# How much memory to allocate for data storage IndexMemory=1000M # How much memory to allocate for index storage #MaxNoOfConcurrentOperations=1048576 #MaxNoOfConcurrentTransactions= 1048576 #MaxNoOfLocalOperations=1048576 #MaxNoOfConcurrentIndexOperations=16384 #MaxNoOfConcurrentScans=500 #LockPagesInMainMemory=Y # TCP/IP options: [TCP DEFAULT] portnumber=2202 # This the default; however, you can use any # Management process options: [NDB_MGMD] id=1 hostname=192.168.1.107 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles [NDB_MGMD] id=2 hostname=192.168.1.125 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles # Options for data node "A": [NDBD] # (one [NDBD] section per data node) id=3 hostname=192.168.1.107 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles # Options for data node "B": [NDBD] id=4 hostname=192.168.1.125 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles # SQL node options: [MYSQLD] id=5 hostname=192.168.1.107 [MYSQLD] id=6 hostname=192.168.1.125 The "my.cnf" on host:192.168.1.125 configuration file is as, # The MySQL server [mysql_cluster] ndb-connectstring=nodeid=2,192.168.1.107:1186,192.168.1.125:1186 [ndbd] connect-string=nodeid=192.168.1.107:1186,192.168.1.125:1186 [ndb_mgm] connect-string=nodeid=2,192.168.1.107:1186,192.168.1.125:1186 [ndb_mgmd] config-file=/var/lib/mysql-cluster/config.ini [mysqld] ndbcluster ndb-connectstring=nodeid=2,192.168.1.107:1186,192.168.1.125:1186 After all configuration done (on both server) I am trying to start the mgmt using the following command as(on both server), [r...@test mysql-cluster]# ndb_mgmd --initial --connect-string=nodeid=1,192.168.1.125:1186,192.168.1.107:1186 2009-08-31 13:02:41 [MgmSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.34 ndb-7.0.6 2009-08-31 13:02:42 [MgmSrvr] INFO
