Re: Blob implementation question

; -Original Message- From: Adam Ilardi [mailto:mastaskill...@gmail.com] Sent: Wednesday, March 13, 2013 9:16 AM To: mysql Subject: Blob implementation question Hello All, I'm trying to grok the blob implementation. This scenario is contrived to understand blobs please don't suggest I

mysql/sql server migration

I'm involved with a project that is migrating data from sql server to mysql. The project will take up to a year to complete. During that period of time, we will need to synchronize data from sql server to mysql as we migrate windows based functionality to linux based servers. What is the

mysqldiff resurrected and 0.43 released

project. github forks are of course welcome too ;-) Cheers, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Variables in stored procedure

= v_max do SET TABLENAME = CONCAT('wp_',v_counter, '_options'); INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap', 'edit_posts', 'yes'); set v_counter=v_counter+1; end while; commit; END Thanks, Adam -- Adam Gerson Co-Director of Technology Columbia Grammar and Prep

Re: Variables in stored procedure

', 'statpress_number-display_visit_spy_visitor', '20', 'yes');); prepare stm from @sql; execute stm; set v_counter=v_counter+1; end while; commit; END -- Adam Gerson Assistant Director of Technology Columbia Grammar and Prep School phone. 212-749-6200 ex. 321 fax. 212-428

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

but the date is: [root@tungsten /var/db/mysql]# date Sun Sep 4 19:11:13 CEST 2011 And it's delayed 1 hour. No data is transferred to the slave. It says: Secords behind master 0. What the hell is going on here? -- Adam PAPAI Grapes Communication Kft. http://www.grapes.hu E-mail: papai.a...@grapes.hu

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

the old ones there). Thanks again. -- Adam PAPAI Grapes Communication Kft. http://www.grapes.hu E-mail: papai.a...@grapes.hu Phone: +36 30 33-55-735 (Hungary) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Messed up mysql-server, cant reinstall?!

I accidentally drop the database mysql. I now cannot restore tables to the database or do much of anything some details can be found here http://serverfault.com/questions/234321/i-accidently-dropped-the-mysql-db/234340#234340 after a few unsuccessful uninstalled/reinstalls i wrote whereis mysql

Share To My Love x--)

Dear: I would like to share with you my recently shopping experience: I found a very excellent e-site, the above is the latest and most popular products. By their staff, understanding that they have stable supply channel, so the price of products is shock your eyeballs burst. Certainly I will not

Split string by regex

| 65 | +++ | RP |2 | +++ etc Could this be done in MySQL? I want to do something along the lines of set class2 = SUBSTRING_INDEX(class,'[A-Z]',-1) but I understand this is not possible. Any ideas? Regards Adam -- MySQL General Mailing List For list

Re: opening a server to generalized queries but not too far

privileges to a specific table for a specific user. -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:17, Don Cohen don-mysq...@isis.cs3-inc.com wrote: This seems like a topic that must have been studied, but I'm having trouble figuring out what to search for in Google, since the usual

Re: list rows with no recent updates

. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 16:02, MadTh madan.feedb...@gmail.com wrote: Hi, I ran a update command on around 2700 rows inside a mysql database table which has around 3000 table rows to change the ( say) price of each item ( with unique ID. unique product code

Re: opening a server to generalized queries but not too far

(which would be rather weak security imho). -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:48, Don Cohen don-mysq...@isis.cs3-inc.com wrote: Adam Alkins writes: Sounds like you just want to GRANT access to specific tables (and with limited commands), which is exactly what MySQL's

help with group by

I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql select distinct

Re: help with group by

works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by,

restoring mysql db doesn't restore user passwords

to the reinstall: mysql -u adam -px ERROR 1045 (28000): Access denied for user 'adam'@'localhost' (using password: YES) but in the mysql.user table, adam exists and has his password set from the dump file: mysql select User,Password from mysql.user where user = 'adam

Re: restoring mysql db doesn't restore user passwords

you're a genius! I had old_passwords=1 in my.cnf, changed it to 0, restarted mysql, and then the users worked like a charm. thanks! Little, Timothy wrote: My theory would be that it's an OLD-PASSWORDS issue. It would seem that you might have used the old_passwords=1 in your original

Solaris 10 bug with mysql_install_db

Description: running mysql_install_db does not correctly fill grant tables How-To-Repeat: run mysql_install_db; attempt to connect, fail. Fix: Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL** Submitter-Id: [EMAIL PROTECTED] Originator:Adam Thompson Organization

Re: Floor Decimal Math

)=0.11; +---+ | ROUND(11.11-FLOOR(11.11),2)=0.11 | +---+ | 1 | +---+ Thanks for all your help, Adam Jerry Schwartz wrote: Don't feel bad, many an experience programmer

Floor Decimal Math

| ++ | 0 | ++ Any help would be appreciated, Many thanks, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: % wildcard host permission not working

Yes, I did FLUSH PRIVILEGES and I think I only have one username/host entry for this user. Adam Erik Giberti wrote: Did you FLUSH PRIVILEGES? I'd also check that the username and passwords are the same for each host entry, I've had problems if passwords were different for a shared username

% wildcard host permission not working

I set up a user and entered % for the host. I am not able to connect. However, if I change the host value to my FQDN it works fine. Shouldn't the wildcard allow me to connect from any host? Thanks, Adam -- Adam Gerson Assistant Director of Technology Apple Certified System Administrator

Re: how to drop index if exists

Fantastic, thanks very much! Adam Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote: Folks How can one conditionally drop an index in MySQL? Googling shows that the drop index does not support an if exists qualifier - apparently a bug has been raised

Re: how to drop index if exists

. ALTER IGNORE TABLE table_name DROP INDEX index_name; ALTER IGNORE TABLE table_name ADD INDEX UNIQUE index_name(column_1,column_2); Thanks - Ada Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote: Folks How can one conditionally drop an index in MySQL? Googling

how to drop index if exists

Folks How can one conditionally drop an index in MySQL? Googling shows that the drop index does not support an if exists qualifier - apparently a bug has been raised but as far as I know its not fixed yet. Does anyone know of a work-around? TIA - Adam -- MySQL General Mailing List

Re: Need help with a natural sort order for version numbers and release code names

out what the ultimate goal was. I think it's kind of clever myself :) Yes, there's no possibility of indexing here, but it gets the job done. Adam. On Oct 12, 2007, at 12:39 PM, Daevid Vincent wrote: I'm trying to get some 'release/version numbers' to sort properly. mysql SELECT ReleaseID

Re: Need help with a natural sort order for version numbers and release code names

| +---+-+ 20 rows in set (0.00 sec) Adam. On Oct 12, 2007, at 3:56 PM, Adam Randall wrote: Here's my full test solution: use test; drop table if exists releases; create temporary table releases ( releaseid int(10) unsigned not null auto_increment primary key, name varchar(255) )engine

test - please ignore

RE: Character sets

As habit I only use UTF in anything I do... and it has paid off many times over. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: List of ports which should be opened for IPTABLES

When it comes to clustering.. doesn't matter if it is MySQL, MS SQL Server, MS Exchange or a big bad Beowulf Cluster you need an independent switch for the cluster. Here is why, There is so much traffic to and from the nodes, and on the network that it will slow down your network, and the

RE: SQL Translation

to keep them equivalent. Regards, Adam Adam Trimeloni Project Leader Quality Systems [EMAIL PROTECTED] (949) 255-2600 -Original Message- From: Trimeloni, Adam Sent: Thursday, February 15, 2007 2:32 PM To: 'Gary W. Smith'; Dan Nelson Cc: mysql@lists.mysql.com Subject: RE: SQL

SQL Translation

but populates all the group_payers columns are NULL. After our translation attempts returns no rows. (I am running the test cases in SQL Server 2000 first, to show our changes will still work with the current setup) Thanks, Adam

RE: SQL Translation

I should have mentioned it is a short hand for a join. *= is a left outer join. =* is a right outer join. Adam Trimeloni Project Leader Quality Systems [EMAIL PROTECTED] (949) 255-2600 -Original Message- From: Gary W. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15

SQL Query Question

, so the gains by using nested queries would be negligible. I'm guessing that this isn't possible, but I thought asking some people that know more than myself couldn't hurt. Any assistance is appreciated. Thanks, Adam Bishop

RE: SQL Query Question

Ah, that would work. Looks like I was making the problem too complex in my mind, thanks for your help. Adam Bishop -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: 22 January 2007 07:07 To: Adam Bishop Cc: mysql@lists.mysql.com Subject: Re: SQL Query Question

Retaining last primary key value

Hello, When I run a DELETE FROM table_name, my primary key field is reset back to 1. Is there any way for it to not do this? Preferably, if there were 1000 records in table_name, and I ran DELETE FROM table_name, that the primary key field would start at 1001. This is an InnoDB table

Re: Retaining last primary key value

Thanks for the reply but that didn't do it. I believe I've got this to work by performing the following steps: DELETE FROM table_name (1000 rows) INSERT INTO table_name(column) VALUES(value) DELETE FROM table_name Now when I perform another INSERT, the primary key starts at 1001. Adam Zerlin

java mysql alias is being displayed blank?

, Adam JSP: c:set var=resultObj value=${sessionScope[\javax.servlet.jsp.jstl.sql.Result\]} / table border=1 cellspacing=2 tr thUser ID/th thFirst Name/th thLast Name/th thUser Name/th thPhone Number/th

Drop Index if Exists

Folks, Does this work in MYSQL 5? I tried DROP INDEX [NAME] IF EXISTS; and got an error check your syntax. Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Drop Index if Exists

Thanks What I am getting at is: does the IF EXISTS qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks - Adam Visolve DB TEAM

mysql/syslog - 100,000s of log messages on restart

. -- Adam Rosi-Kessel http://adam.rosi-kessel.org # # The MySQL database server configuration file. # # You can copy this to one of: # - /etc/mysql/my.cnf to set global options, # - /var/lib/mysql/my.cnf to set server-specific options or # - ~/.my.cnf to set user-specific options. # # One can use all

MySQL commercial licence

experience of this? Upgrading commercial licences? What's the story? Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL commercial licence

Checking. I don't think the customer bought the network version. Apparently its MySQL Pro Licence V4. It's a bit rich not to offer upgrades at a discount IMO. Adam -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: 12 May 2006 11:52 To: Adam Lipscombe Cc: 'MySQL

Re: slow query

. Hope this helps! Dan Adam Wolff wrote: I have a very simple table that looks like this: CREATE TABLE `contacts` ( `id` int(11) NOT NULL auto_increment, `fullname` varchar(100) default NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY

Re: Sum of counts

You could you use UNION to make this all execute in a single query. On 5/10/06, Rhino [EMAIL PROTECTED] wrote: Hi Chris, Joerg, and everyone else following this discussion, Joerg, you are correct; the best way to sum the tables is individually and then add the sums together with program logic

Re: searching for words with special chars

On 2006-04-01, at 13:17, Octavian Rasnita wrote: Hi, Is it possible to create a query that searches for records which contains words with special chars and with their english correspondents? For example, if a user searches for mata, I want to return all the records that contain the

slow query

| ref | user_id,user_id_2 | user_id_2 | 4 | const | 506222 | Using where | ++-+--+--+---+---+-+---++-+ In other words, it *is* using an index for this query. Anyone have any advice for me? Thanks, Adam

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a

Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

Well, I hadn't known about the spatial features of MySQL. If you're ok using vendor extensions then that definitely looks like the way to go: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html A On Apr 24, Nick Hill wrote: Hello Adam Adam Wolff wrote: Actually runs through

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

I didn't look through your code very carefully. Have you confirmed (using EXPLAIN) that your select query is using the index? I don't much about the mysql optimizer, but it's possible that this query: $query1=SELECT lat,lon from integer_test WHERE lat$lat1 and lat$lat2 and lon$lon1 and

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

Actually I think this should be an INNER JOIN -- not a LEFT JOIN. A On Apr 23, Adam Wolff wrote: I didn't look through your code very carefully. Have you confirmed (using EXPLAIN) that your select query is using the index? I don't much about the mysql optimizer, but it's possible

Re: Why does this query takes a lot of time

On Apr 22, Philippe Poelvoorde wrote: alter table s add index(login_name); alter table c add index(recordID); To make this much faster, I think you may want: alter table s add index(recordID, login_name); alter table c add index(recordID); Because after the join, the engine can use the

Re: newbie optimization question

! combinations of filters and sort orders. Adam On Apr 20, Alexey Polyakov wrote: On 4/20/06, Adam Wolff [EMAIL PROTECTED] wrote: How can I optimize the case where I filter on one key but sort on another? This is fast: SELECT * FROM contacts WHERE fullname LIKE j% ORDER BY fullname

finding a record within a sort order

contacts AS c2 ... but that's conceptually what I'm looking for. Thanks! Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: newbie optimization question

Hey! I figured out this one myself: On Apr 19, Adam Wolff wrote: * Question 2: Why does introducing an extra WHERE clause make things slower? If I do this: SELECT * FROM contacts WHERE fullname LIKE j% AND user_id=1 ORDER BY fullname LIMIT 10; It's because the index needs

newbie optimization question

have user_id=1 Any insight will be greatly appreciated. Thanks, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: differences between varchar and text fields

On 2006-01-20, at 01:13, Tucker Cunningham wrote: So, my question is: what are the pros and cons of using varchar vs. text/longtext? Right now, longtext seems to be the best option (it provides most flexibility in data that can be stored, at only a 2-byte-per-row storage premium) There

Problems with importing the british pound (£) an d euro (€) sign

--default-character-set=latin1 -u user -ppwd dbname datadump.sql but this produces the same results. Any ideas? TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Easy regex replace?

On 2006-03-20, at 12:11, Pooly wrote: 2006/3/19, Adam i Agnieszka Gąsiorowski FNORD [EMAIL PROTECTED]: On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g

Re: Problems with UTF and MySQL

On 2006-03-20, at 16:12, Gabriel PREDA wrote: One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to talk the same language !!!

Re: Easy regex replace?

On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g. replace all '%20' with ' ' leaving the rest untouched?) You know that proverb - For a man in possession

Re: setting the data directory.

Hi, There's a mysqld startup option --datadir=/path/to/data which you can use to alter your data directory. Simply adjust your startup scripts to suite. Regards, -Adam On 1/31/06, Scott Johnson [EMAIL PROTECTED] wrote: Hi All, I am trying to find out how to change the location of the data

Mysqldump INSERT statements (Was Mysqldump line endings)

. : INSERT INTO t1 VALUES (1,2,3), (1,4,5), (1,6,7); TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqldump line endings

to persuade mysqldump to produce one file (with insert into statements) and also use Windows style line endings? TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

backwards compatibility when exporting MYSQL 5 BIT fields

this? TIA - Adam Lipscombe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Administrator on 10.3 Server -HELP

Did you drag it from a network drive, or copy in some other way? If so, that may be the problem. I haven't used the MySQL Administrator, but am pretty well versed in application troubleshooting. Send me an email privately if you need some direct help. Adam. -- Adam Randall [EMAIL

Locks acquired with get_lock() persisting, even after MySQL thread has exited

Description: We have distributed applications which make extensive use of the get_lock() function to acquire a system-wide lock. Occasionally, all copies of a given application block attempting to acquire a lock on the same lock string. Using is_used_lock() reports

Re: Sarge problems with MySQL and DBI / DBD::mysql

$DBI::errstr); How can I debug or fix this problem, please? Instead of doing this, you might want to try setting RaiseError (see man DBI) which would cause DBI to detect errors and throw exceptions. Alternatively, you might want to use $h-err to check for errors. - Adam -- MySQL General

How to set trabnsaction isoloation in my.ini file

is REPEATABLE-READ. I can set it manually from the mysql command line and that works. The tx_isolation is then reported as READ-COMMITTED. Its almost as if the server is not reading the my.ini file. How can I set the tx isolation level on startup? Does anyone have any ideas? Thanks -Adam

RE: How to set trabnsaction isoloation in my.ini file

created the file in the installation dir. Many thanks - Adam -Original Message- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 17:23 To: Adam Lipscombe Cc: mysql@lists.mysql.com Subject: Re: How to set trabnsaction isoloation in my.ini file Adam Lipscombe wrote: I

utf8, 4.1, and character length truncation in mysql system tables

recommended for other tables in the manual. Also, on a related note, these are really big tables, and running alter table on them to modify the column lengths is taking a LOOONG time. Any hints on speeding this up? -- - Adam ** I can fix your database problems: http

Re: utf8, 4.1, and character length truncation in mysql system tables

set the server character set to utf8 (which makes sense, as most terminals don't support utf8). Is there something else I should be doing to create new users post 4.1? Is this behavior something I should be worried about? (I am, currently.) Adam Fields [EMAIL PROTECTED] wrote: I changed

Re: problems with 4.1.11 on Solaris

On Apr 8, 2005, at 12:21 PM, Adam Arrowood wrote: I just installed the 32-bit SPARC Solaris package (mysql-standard-4.1.11-sun-solaris2.9-sparc.pkg.gz) in made a symbolic link to the install directory as /usr/local/mysql . I am having the following problems: 1) when I start mysql

problems with 4.1.11 on Solaris

) ... thanks, adam a -- Adam Arrowood :: http://www.gatech.edu/adam :: adam AT oit.gatech.edu Office of Information Technology/OE/CS :: (404) 894-0372 Georgia Institute of Technology, Atlanta, GA USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Hex data in VARBINARY fields -- Is it me, or MySQL?

any ideas/suggestions... I'd hate to unnecessarily submit a bug report, if it's something on my end. THANKS!!! --Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

dataKiosk 0.6 released

of dataKiosk in action can be found here: http://web.mit.edu/~treat/Public/datakiosk.html and here: http://web.mit.edu/~treat/Public/datakiosk-editor.html Cheers, Adam Treat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Encodings

. (This PHP script is called by a desktop app, so I can guarantee the encoding is UTF.) What should I do when retrieving the data from the database and outputting it to a PHP page? For example, how do I convert é to eacute; (or whatever is appropriate)? Adam Ernst -- MySQL General Mailing List

Error in Complex SELECT

') And even: SELECT * FROM matches WHERE question_id IN (SELECT q.server_id FROM questions as q WHERE q.results_id = 'MyID') But no go--in all cases, I get an syntax error near the first parentheses. Any suggestions? This is on MySQL 4.0.22-standard. Thanks, Adam Ernst -- MySQL General Mailing

Help: Index performance on moderately sized table

and the order don't play nice, and I can't seem to figure out how to get an index that applies to all the criteria. I've tried multicolumn indexes, forcing indexes, setting the max_seeks_for_key to 100, etc. Nothing seems to make it better. If anyone has any advice, I'd love to hear it. Adam

Re: Excel 2 mysql

Ziggy, I'm not sure what you need help with. If you want to get data into MySQL from Excel, consider saving the data (I assume it is a table) as a CSV then using the LOAD DATA command to bring the data into a temporary table in MySQL. Take a look at the command in the help pages. Regards, Adam

Re: Trying to dump from GUI client

file. Good luck! Regards, Adam Eve Atley I'm not sure how best to proceed in dumping data from 1 database and getting a copy of the export, in order to transfer it to another server. I usually use phpmyadmin to do an export, which nicely creates a .zip file of everything. I managed to get

Re: Problem connecting to MySQL 4.1.7 running on another machine

this helps some. Cheers, Adam Kevin Barry I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306

Re: Database/Table Structure

/index.html) There are many other some are probably free. Look around! I hope you find something you like. Cheers, Adam Ferguson, Michael G'Day All, Can anyone recommend an application that will read/probe a MySQL database on a Linux server and generate a graphical output of thedatabase

Re: syntax question..

are the details of the tables in the join (column names data types)? Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to turn on auditing for mysql

Is there any way to log all the activity in a mysql database? I would like to know every single delete insert or select on all tables for my database. Regards, Alex

RE: frecvent table corruption

-Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 12:40 PM To: [EMAIL PROTECTED] Subject: Re: frecvent table corruption adam [EMAIL PROTECTED] wrote: The actual error message we get is: SELECT query FROM namedqueries WHERE userid = 4

frecvent table corruption

Hello. My company is using mysql as a backed to Bugzilla. However, recently, as the number of users that are logging bugs increased we are experiencing frequent table corruption and loss of data. The actual error message we get is: SELECT query FROM namedqueries WHERE userid = 4 AND

mysqldump under cron

Hello. I am using mysql 4.0.18 on rh3, and I would like to daily save db state. I have this small script under the cron directory that when executed from the prompt works fine. Basically the dump is done by: mysqldump --user=root --password=root-password --opt bugs

how to uninstall mysql

Hello. I have installed MySql on RH Linux, however since I have installed in the wrong location I would like to uninstall. Basically I have installed the binary version from the mysql-standard-4.0.18-pc-linux-i686.tar.gz and I have followed the instructions in the INSTALL-BINARY, in

Re: Create table results in (errno: 121)

, I'd reference the message, and if that doesn't help bring the message to the group. Regards, Adam On Apr 22, 2004, at 9:29 AM, Tom Brown wrote: Hi, I'm trying to create a table with the following syntax CREATE TABLE TNSession ( SessionID int(11) NOT NULL auto_increment, IPAddress varchar(50

Re: Mysql for Family History (genealogy)

specifically MySQL or not. The current release of GRAMPS stores its information in an XML file. Adam Stein -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed

Re: Datetime Default Value - I want to know too!

This is a great question! I also work on SQL Server (2k) databases as well as Access and MySQL. I run into the same problem. So far, I've just changed the SQL in my applications, but I also would like to know if a default can be set. Regards, Adam On Apr 18, 2004, at 12:01 AM, Stormblade wrote

Fwd: Trying to run multiple statements through MySQL monitor

All, I've got data listing people's identification details including first and last name, social, and status in the application. Given this data, I want to know how many duplicate socials I have. Normally I'd write a query with a sub select to get that information - something like this:

MySQL Cluster

.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Thanks, Adam Erickson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Why can't I use an AS value in the WHERE clause.

MIchael, Point well taken. Cheers, Adam On Apr 8, 2004, at 2:47 PM, Michael Stassen wrote: Good point. I was focused on the question of using the alias to restrict results, so I left the function in the SELECT part. As you say, in this query, that would just give a useless column of '1's, so

Re: Why can't I use an AS value in the WHERE clause.

the expression in the `IF` to the HAVING clause? So take my old statement and ditch the where clause. You'll get: SELECT * FROM wifi_table HAVING unix_timestamp()-unix_timestamp(last_seen) 600; A little easier on the eyes no? Cheers, Adam On Apr 6, 2004, at 9:42 PM, Michael Stassen wrote: Adam

Re: Why can't I use an AS value in the WHERE clause.

Daevid, SELECT * FROM wifi_table WHERE active = 1 HAVING unix_timestamp()-unix_timestamp(last_seen) 600; Regards, Adam On Apr 5, 2004, at 8:29 PM, Daevid Vincent wrote: I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen

Re: Using Access as client all fields are marked #Deleted

executing DDL queries to MySQL. Regards, Adam On Apr 1, 2004, at 4:14 AM, Patrick Kirk wrote: Hi all, My setup is windoes 2000, Access 2000 and Mysql built from source on Debian. Some tables can be seen but all new entries are marked #Deleted. If I close the table in Access and re-open it, its

Re: A question about mysql database backup.

should generally add the -Q option which quotes table and row names. Otherwise, restoring data can be really hard in case of perhaps only one complicated row name... Are back-ticks actually part of ANSI SQL? Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

  1   2   3   4   5   >