Re: Manually enabling root access from remote machine

g fine (alongside a version 4 server on the same machine). How do I manually enable root access from remote machines as adding "%" into the list of hosts for root does not seem to do anything in Administrator? grant all privileges on *.* to root@'%' identified by PASSWORD('pas

Question on views, stored procedures & temporary tables

procedure that creates and populates the temporary tables? Thanks :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au

Re: Please solve immediately Error found in migration from MS SQL 2000 to My sql

java.lang.reflect.Method.invoke(Unknown Source) com.mysql.grt.Grt.callModuleFunction(Unknown Source) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Re: mysqldump: Got errno 27 on write. file too large

/var/mail nfs - yes actimeo=0,bg,soft,retry=10 swap- /tmptmpfs - yes - As I thought, your filesystem seems OK, I keep my bet on kernel issue. Anyone else? -Message d'origine- De : Daniel da Veiga [mailto:[EMAIL PROTECTED] Envoyé : Friday, 07

Re: mysqldump: Got errno 27 on write. file too large

I'd be very surprised in this case--see above for reasoning. Greg -- Greg Lehey, Senior Software Engineer, Online Backup MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Diary http://www

Re: Rekall

ministrator and Query Browser? -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL Gen

Re: Show tables replacement

tacks would ruin a LOT of sites. Table names are supposed to be static, so, most apps hard code their names. (but that IMHO). If someone point that out (I couldn't find it googling, nor searching manuals) it would be pretty intersting. -- Daniel da Veiga Computer Operator - RS - Brazil -BEG

Re: MS Access gives error no. -7776.

003 if I remove the timestamp field. Also, make sure your primary key column isn't larger than an int ( ie don't use int unsigned, and don't use bigint ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2

Re: Using MySQL as backend

sharvan kumar wrote: > Dear Sir/Madam > I am working on a project where I am > to use PHP as front end and MYSQL as backend.MySQL > stand alone is working properly,but it is not > connecting with PHP.Please tell me solution. > Connect it. -- Daniel Kasa

Re: Backup questions

ld edited files 6) Remember the position where you left editing the file 7) Line numbering, jump to, copy paste visual or command, delete lines by number, delete multiple and much more editing features. 8) Much more stuff I don't use/know OK, I'll stop VIM stuff here, I just love it, but I

Re: Backup questions

t is default for --opt) and will > get a single INSERT for each row. I thought this may be the way I needed to go, but wasn't sure. I will give this a try and see if it works. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Backup questions

ult for --opt) and will get a single INSERT for each row. Any ideas? Yes! Windows: Mysql Manual - Mysqldump section Linux: man mysqldump It's all there... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++

Re: Works in SQL Manager, but not PHP?

re sending multiple commands in the 1 query. Break it up into separate queries and execute them 1 after the other. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] websit

Re: MS Access gives error no. -7776.

ing service packs - version of Windows -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list

Re: Recommended backup scripts for mysql databases

port and populate it with one of the table separated backups, retrieving the data. It was efficient at that time, nowadays you have heartbeat and other tools, allied to a DNS, it can do a LOT more (even non-assisted crash recovery). But if you have a small dataset you can try this approach. -- Da

Re: Recommended backup scripts for mysql databases

-p | bzip2 -c > path/to/backup/$date-.sql.bz2 I guess it will work on a FreeBSD, its my own cron job here... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X++

Re: Upgrading from 3.23.58 > 5.0.22?

nyone have any suggestions? Upgrade to 4, then 4.1, then 5. Follow the above links, its quite fast as you'll only be careful with things your particular system is affected. PS: BACKUP EVERYTHING!!! 2 copies are never too good -- Daniel da Veiga Computer Operator - RS - Brazil -BEG

Re: Left Join Help

> DB engine. > > The query needs to pull in about 50,000 results. > > Does anyone see a way to optimize this query or rewrite it so it doesn't cause > a huge system load? > > Thank you, > > -- No virus found in this outgoing message. Checked by AVG Free Edition. V

Re: PHP mysql_connect

-- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Versio

Re: Exclusion Query

7;L0%') and (fld_archived = '0')) The problem is it is not returning the correct information. -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org H: 814.825.0847 M: 814-341-6233

Re: About mysqldump

sql.user Comments? Isn't the "hosts" table needed too?! -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --

Re: Just need script for creating tables

a command for this end? (I could copy & paste the part from 'mysqldump' but it's not what I want to do.) Read the reference manual for the mysqldump program, you can check the syntax to do that: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Specially for the --no-data a

Re: mysqld refuses to run on boot

love Gentoo. "rc-update add mysql default" and voilá, its done. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++

Re: [mysql] Attention List

i took it more as a grain of pepper and just wanted to warn y'all of the impending virus attack that may or may not be sent around. thanks for the break down though. On 6/16/06, Chris White <[EMAIL PROTECTED]> wrote: On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: > hel

[mysql] Attention List

The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel McQuay [EMAIL PROTECTED] boxster.homel

Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same

. Try closing your connections after you've used them in a proper way (that depends on the language you're using for your frontend) and that number should not increase anymore. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-?

Re: Reset (or Defrag) the AUTO_INCREMENT columns

it to an unsigned mediumint. The 'unsigned' bit means that the field won't store negative values - this gives you twice the positive numbers you can store. Otherwise if you're already using an unsigned data type, then just go up to the next data type ( eg mediumint to int, or in

Re: Reset (or Defrag) the AUTO_INCREMENT columns

key, then don't use an auto_increment column. Instead, use a numeric column and write some code to create your next primary key value. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922

Re: my-huge.cnf quite outdated (fwd)

ve you a config set that may crash/overload/put in risk your server. Simply grab a set of features and play in a test database. There are some "stress tests" for mysql over the web... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P

Re: How To Pronounce MySQL

and you (and you'll look like an idiot) 2) The person will infer what you mean even you saying it wrong (and you'll look even more like an idiot) I personally will avoid these situations. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT

Re: How to backup and restore

Has everything you need to know. And also, consider using an updated version, the one you're using is too old. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5

Re: all of a sudden can't connect to server..

On 6/8/06, Frances <[EMAIL PROTECTED]> wrote: Daniel da Veiga wrote: > On 6/8/06, Frances <[EMAIL PROTECTED]> wrote: > >> what's event viewer? (searched google for error 1067, so opened .err >> file, this is what is says (at the bottom, long file): >> &

Re: MySQL crashes

ur server to the latest 4.1, I believe its 4.1.20, and report back... I`ve seen various issues with versions below 4.1.12... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

passwords" as an option and see if it works. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK---

Re: Sad, I know...

(terminal.app) and SQL. There are lots of books out there, including on > using and installing MySQL. Might be advantageous to buy one. Or you can > read the free and wonderful manual provided by MySQL on their website. > > So, the command written by Daniel is used on the command line for

Re: UPDATE from one server to another

for creating PDF reports. Trust me - it's a LOT less work ( and trouble ) than doing it in PHP. If you're interested, have a look at: http://entropy.homelinux.org/axis_not_evil And also please send feature requests, bug reports, and contributions :) Dan -- Daniel Kasak IT Develop

Re: Sad, I know...

he Web Interface. You can also take a look at the MySQL Manual for a way to reset your password in case you can't login using console. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O

Re: Query performance.

d_cache_size = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 ... Check http://bugs.mysql.com/bug.php?id=12915 -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++

Re: UPDATE from one server to another

data, sort stuff and simply offer links to the ftp site... Just a suggestion... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+

Re: Moving database files to larger partition?

my databases? If you're not changing versions, move the whole dir (/var/lib/mysql) to the new location, simple as that, but you must do it yourself, cause MySQL won't. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C+

Re: please help me.

L from www.mysql.com -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List Fo

Re: Where is the triggers run when replicating?

p://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+

Re: How to get machine independent unique id??

replication. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing Li

Re: Take my name off your list !!

pfffttt... laziness! On 5/31/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 5/31/06, Michael Price <[EMAIL PROTECTED]> wrote: > > > > > > > > > Congratulations Michael! You just got yourself an indexed, searchable record of ignorance (Gmane, MySQL.c

Re: Take my name off your list !!

using your email/password) and that only you were easily able to do with little or no research at all. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv

Re: i'm at a complete loss?

ent --- -- *From:* Daniel McQuay [mailto:[EMAIL PROTECTED] *Sent:* Tuesday, 30 May 2006 10:39 AM *To:* Logan, David (SST - Adelaide) *Cc:* David Griffiths; mysql@lists.mysql.com *Subject:* Re: i'm at

Re: i'm at a complete loss?

ogan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: Hi Daniel, Is this actually the instance that you have just installed? I know that sounds trite but if it is running during the installation maybe it hasn't been able to start the new server and you are still trying to connect to th

Re: i'm at a complete loss?

resolve to the problem. FYI I had seen that error before on my machine and tried to solve, but with no luck. On 5/29/06, Daniel McQuay <[EMAIL PROTECTED]> wrote: Yeah when I ran it the first time I get this message: boxster# /usr/local/bin/mysql_install_db --user=mysql Installing all prep

Re: i'm at a complete loss?

have an instance of mysqld running, which I do. ps auxw | grep myslqd show it there running. Thanks again! On 5/29/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: Hi Daniel, Sounds like there are a few records missing out of the mysql tables. Did you r

Re: i'm at a complete loss?

7;, 'mysql', password(mysql)); Don't forget to do a "flush privileges;" afterwards (again, no quotes); The mysql schema is thoroughly (but dryly) documented @ http://dev.mysql.com David Daniel McQuay wrote: > Thanks Greg, I did try that here is what happened. > >

Re: i'm at a complete loss?

one has 'em. On 5/29/06, Greg Maruszeczka <[EMAIL PROTECTED]> wrote: On Sun, 28 May 2006 20:17:53 -0400 "Daniel McQuay" <[EMAIL PROTECTED]> wrote: > Hello list, > > I just installed MySQL on my FreeBSD box here at home and am having a > few problems with pr

i'm at a complete loss?

this guide here http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing seemed to go well but like I said I keep getting this error. Is there something else I should do? Any help on this would be MUCH appreciated. Thanks in advance, -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847

Re: How do I get off this list that I do not remember joining in the first place!!!!

subscribed. Otherwise, see the list administrator. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailin

Re: How do I get off this list that I do not remember joining in the first place!!!!

Phil Robbins wrote: Perhaps you should read the notice at the bottom of each post that you receive from the list !!! -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989

Re: Sparse 1.0b - framework for MySQL programs

Hi, According to the CC license, "Creative Commons licenses are not intended to apply to software. They should not be used for software." So I'm not entirely sure why you're recommending it. ^^; It is released under the GPL. --Daniel "Keith Roberts"

Sparse 1.0b - framework for MySQL programs

help they can offer, please do so! Thanks! --Daniel Orner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL crashes randomly

d yourself, your server is pretty much in order, the only thing I can think off is a bug, and a good one :) so, upgrade to the latest 4.1.x and see if it continue to happen, maybe its an issue fixed by now. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Ver

Re: Quick Linux/MySQL performance questions.

builds glibc by default twice (read the einfo of the ebuild?) one with linuxthreads and the other with NPTL, you can set USE flags to avoid that (I guess its a matter of compatibility). so, you may be running MySQL with linuxthreads instead. Check it. More RAM, that's my advice, since your sy

Re: batch installation of mysql 5.0

ated a config file, copied the needed files to a location and run the appropriate actions accourding to the OS of the user (windows xp, create service, win98, startup item). Its not really difficul if you know how to deal with MySQL. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEE

Re: how to restart mysql and apache?

On 5/9/06, Edward Vermillion <[EMAIL PROTECTED]> wrote: On May 9, 2006, at 1:50 PM, Daniel da Veiga wrote: > On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> hi again, >> I have to restart as soon as possible mysql and apache on our web >> server &g

Re: how to restart mysql and apache?

On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: found this: /etc/rc.d/init.d/mysqld restart /etc/rc.d/init.d/httpd2 restart I think it should work? Yeah, different systems, different locations, but the same purpose... -- Daniel da Veiga Computer Operator - RS - Brazil

Re: how to restart mysql and apache?

Thanks for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--

Re: Need help in recreating .MYD files

On 5/9/06, balaraju mandala <[EMAIL PROTECTED]> wrote: Thank you Daniel for reply. Just in curiocity i want ask u, how u r taking daily backups, just using 'mysqldump' or using any Tools. I'm using mysqldump plus bzip2 to compress data for about 2 years now. Tried

Re: Need help in recreating .MYD files

ion. In simple terms, if you have no backups, your binlogs are outdated or rotated to an extend (old changes lost) and you can't recover the files from the filesystem. You're pretty much f up (don't get me wrong, It happened to me once, and now I have daily backups, a replicate

Re: Backups with MySQL/InnoDB

as a backup would be cool), manage binlogs (date and purge) and be compatible with version 4.1 and above (I don't plan on using the 5 version any time soon). -- David Hillman LiveText, Inc 1.866.LiveText x235 -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK-

Re: Output to a file

ommand, eg: tee logfile.txt Or you can start mysql with the --tee switch, eg: mysql --tee logfile.txt -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTE

Re: Re: How to find size of my database

directory for every database, getting the size of the directory you see how much disk space the database has taken. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP

Re: difference between mysql max version and non-max version

the server with different options (more features) at compile time. Joerg, accourding to the page above, he used the correct terminology, a version has different meanings, one for apps (as you stated) and another for executables (builds), that is the way Ashwini mentioned it. -- Daniel da Veiga Compu

Re: HELP --- Slow SP

ueries are using the index, then setting up a new primary key and indexes will not help. Personally, I would do it anyway, but this won't help out in your current case. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61)

Re: HELP --- Slow SP

hat's pretty strange. Anyway, what output do you get if you put 'explain ' in front of your queries? Are the indexes being used? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 ema

Re: HELP --- Slow SP

MySQL will only make use of an index in a join or a where clause if ONLY that field is included in the index. If you pack 3 fields into an index and then try to join on ONLY ONE field, the index can't be used. So look at your joins and where clauses and make sure your indexes match. -- Danie

Re: Accumilating Blog Comments

rect response from the base. What is the correct communication for > the tables, or where am I going wrong with the two above attempts? > > Thank you, > -Patrick > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:ht

Re: what is this? --> errno=2006 errmsg=Server gone

lients don't have a "crash recovery" system that reconnect and resend the query on a server error, but the console has, so you'll see exactly what is happening. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C+

Re: Error wiht VB 5 and MySQL

out WHY the "" appears and the causes for it. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BL

Re: Error wiht VB 5 and MySQL

ySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+

Re: How to initiate a prog. via mysql

poll mysql for the changes. > I didn't get it, you need to run the PHP script at the client or at the server? I mean, if we're talking of a web page, the same script that updates that field should launch the script. If not, you're programming PHP locally, am I right? And if so, y

Re: [Fwd: Re: mysqldumps from java program]

On 4/19/06, Ed Pauley II <[EMAIL PROTECTED]> wrote: > out of curiosity, how do you do that? > > Daniel da Veiga wrote: > >> If I am not mistaken deleting from the production server would delete > >> the data on the slave in a replication environment. > >>

Re: [Fwd: Re: mysqldumps from java program]

> If I am not mistaken deleting from the production server would delete > the data on the slave in a replication environment. Not if you disable the binlog of the query that will delete data... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1

Re: Document / Image (Blob) archival -- Best Practices

I've done a number of special-purpose ones already. If other people show an interest I'll have one up over the next couple of days / weeks. It will of course be cross-platform. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Austral

Re: Reserevd Error -7776 -- Urgent

s it work work the 4th time ... -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list arch

Re: Password expire?

ss, else it makes another connection, this time with an account with read-write privileges so the user is logged into the app. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE

Re: auto_increment and the value 0

the table? Would that work? Yes but it would be no different to just updating the primary key of the existing record. Either way, you will have issues with restoring from backups if you keep an auto_increment column with a zero value around ( as you've discovered ), so what

Re: auto_increment and the value 0

tables ), back things up, and then move the data I would take the 2nd option. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.c

Re: GUI Tools for administering and reporting

n in a free tool, in windows you could schedule a task to see how things are running or simply parse the logs for information with another program. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+

Re: mysql 5.0 too new?

> http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK---

Re: query problem

est' ORDER BY fname $type"; > > > >but what if nether is chosen, or only one? Is there an AND/OR operator or > >similar in mysql? > > > > > >Thanks, > > > >Ross > > > > > > > > > > -- > MySQL General Mailing List

Re: data backup

; MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K-

Re: How can I observe mysqld?

; > If this mailing list is not the right place to ask such > questions please let me know. > > Bye > Karl > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > --

Re: Logging (wrong) passwords by mysqld

mpressum/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++

Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!

a too. Considering the volume of traffic generally, I don't think it's justified to start chasing ( on-topic ) commercial announcements out of the list. I don't know about any official policy. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Syd

Re: upgrade from 4.1 to 5.0

!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Ope

Re: email to db

t, else, I doubt any ISP would allow it... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK--

Re: How stable will mysqld [compiled from source] be on linux 2.4 with glibc 2.3.2 (gcc 3.3.4)?

If you come across a bug, the first thing they will suggest is that you try one of their binaries -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http:/

Re: mysqlimport, \r\n and \n

On 2/22/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: > A batch script or shell script can easily be written to do this. > > -Sheeri > > On 2/20/06, Daniel Kasak <[EMAIL PROTECTED]> wrote: > > I've got some import scripts that are giving me trouble. > >

Re: mysqlimport, \r\n and \n

George Law wrote: Daniel, What about just running your import file through dos2unix before piping it to mysql? That way, it would leave \n alone (since that is unix format) and replace any occurrances of \r\n with plan old \n. I could think of a lot of things I could do if this were all

mysqlimport, \r\n and \n

there any way to ease my pain here, short of importing with one format, counting the number of records, truncating the table, importing wit the other format, counting the number of records, and then selecting the format with the most number of records? -- Daniel Kasak IT Developer NUS Consul

Re: MySQL says, "Ich don't think so" (Subquery woes)

7;s very much worth it to create a temporary table *with* *indexes* on fields you will be joining on. I was hoping MySQL would support automatically indexing result fields inside a sub-query like this, but apparently it's not on the cards :( -- Daniel Kasak IT Developer NUS Consulting Gro

Re: MySQL View Optimization Help

[EMAIL PROTECTED] wrote: Views differ from tables in that they cannot be indexed. I've just started experimenting with derived tables under 4.1.14, and I had a hunch this was so. Is there any plan to include index support for views / derived tables? -- Daniel Kasak IT Develope

Re: dependency issues: coreutils and perl(DBI)

hese packages already, or you can force an install without checking for dependancies. I haven't used rpm in over 5 years, so I can't really give you any specifics, but 'man rpm' will help. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Syd

Re: MySQL 5.0.15 in Linux OS

a look at the INSTALL-SOURCE file in the source distrubution. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL Genera

<    1   2   3   4   5   6   7   8   9   10   >