Re: How can I detect if MySql is already installed?

an answer. -- 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 For list

Re: MYSQL under windows -- Max number of instances

to give them different TCP ports to listen... -- 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: Backup: Copy MYSQL Directory or use MysqlDump

to test and choose from multiple options in this matter. -- 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

Re: Unable to put data on a different computer from mysql

on a real system with some valuable data. -- 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: no log generated?

it be that the problems you mentioned generate warnings and not errors? If so, then you won't see anything in the error log, only if you use the log-warnings variable. Check the manual... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C

Re: Linux Installation

sort of consistency (replication?) between the servers. Oh, combine high load services with M$ and NTFS and you'll get problems (my personal experience, no flames intended). -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA

Re: account that can only do backup

: http://dannyman.toldme.com/2006/08/22/mysql-backup-grant-privileges/ -- 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: *bump* Upgrade wiped out table? What to do?

easily. You can always install the old version you had and try copying the file direcly to get the data back, but I guess the corruption is in the file, so, there's really not much to do... Check your filesystem integrity ASAP. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE

Re: old-password issue with mysqldump

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++ 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 For list

Re: old-password issue with mysqldump

this so I have to use old-passwords option in the new servers :) Thanks On 12/11/06, Daniel da Veiga [EMAIL PROTECTED] wrote: On 12/11/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote: Hi everyone I'm using mysqld with option old-passwords in my server (let's call it serverA) and in my

Re: Renaming the root user - problems.

and many dictionary passwords. -- 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

Re: MySQL Performance Degrades Significantly Over Time

for speed, and if I were you I would check for another option. What's the most frequent operation (read/write) on your tables? Anyway, glad you solved your problem. Just out of curiosity, what is your filesystem? -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version

Re: MySQL Performance Degrades Significantly Over Time

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 BLOCK-- -- MySQL General Mailing List For list archives

Re: Newbie - View several databases as one

friend is a DBA and he once told me that if you have to CODE the creation of a database for any purpose besides restoring a backup, something is wrong. -- 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

Re: Problem with upgrade

to change password format or start your server with --old-passwords. I strongly suggest you to change your password format. -- 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: Best way to backup a 24/7 database

... Choose your own :) -- 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

Re: Remove unwanted characters from a name field

. My 2 cents. -- 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

Re: Version 4.1.9 crash

launch MySQL, but this kind of workaround is in most cases something to avoid. My advice: first of ALL, upgrade. Then, try again, if it fails, change your backup tool, if you have any other issue, come back and we may help. Good luck. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN

Re: query logging is making me mental!

. Remove the filename, or give it a full path. Try this and let us know. -- 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: Code snippet to run at database service startup

a simple application to monitor the error log file for changes and check it to see if mysql was shutdown and/or started. Accourding to the manual: The error log file contains information indicating when mysqld was started and stopped snip -- Daniel da Veiga Computer Operator - RS - Brazil

Re: Problems connecting using -h hostname with new installation

instead. Also, check this: http://hackmysql.com/dns Hope that helped. -- 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 SQL statistics

or CTRL+ALT+DEL on windows. -- 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

Re: MySQL SQL statistics

STATSPACK of Oracle for MySQL. Now I'm pretty sure there's no such thing for MySQL, but someone else can point me wrong. -- 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: Delete one record, automatically delete other records...

-constraints.html Hope that helped. -- 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

Re: Backup SQL

were trying to run both at once, which in my opinion is a Bad Idea(tm). What if each .sql contains a DROP TABLE IF EXISTS statement at the start? Something to be carefull if its the program that generated the backup likes to add this tags. -- Daniel da Veiga Computer Operator - RS - Brazil

Re: Backup SQL

On 8/4/06, Chris White [EMAIL PROTECTED] wrote: On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote: What if each .sql contains a DROP TABLE IF EXISTS statement at the start? Something to be carefull if its the program that generated the backup likes to add this tags. What if my website

Re: upgrading mysql...

/downloads/mysql/5.0.html It wasnt that hard... -- 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: Any form to recover deleted data from a MYISAM/ISAM table?

can also use the binlogs (if you have them). -- 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: Upgrade from 4.1.7 to 4.1.20

it at all. One with such a big scheme should have a mirror, plus backups, just in case. Personally I have daily backups, a slave mirror and another backup of the backup files (network server with TSM backups). -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version

Re: mysql hangs on connection attempt

sort, then deal with the resultset, else it will connect, and that's all. Maybe if you post the entire PHP code, along with any error messages... -- 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: 3.23.58 - 5.0.22 upgrade

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- w O M- V- PS PE Y PGP- t+ 5 X

Re: I don't understand why SCSI is preferred.

. Nobody will do that, but you can jump for yourself for not googling for ide scsi sata pata performance. ;) I'm just kidding. -- 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

Re: I don't understand why SCSI is preferred.

(and no one will EVER sign it, *lol*). SCSI has one more advantage I forgot to add to my previous message, they can be arranged better in RAID with hot swap. I can only tell about my company, where servers have all SCSI disks (IBM, Dell). -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK

Re: Manually enabling root access from remote machine

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('password'); ? -- Daniel da Veiga

Re: mysql - multimedia database

, because the database do not serve the data, only the info about it. Anyway, its MHO. -- 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: Please solve immediately Error found in migration from MS SQL 2000 to My sql

is not with MySQL, it is with MSSQL, as the migration tool can't connect to your already existing database in order to migrate 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

Re: Rekall

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 General Mailing List For list

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

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- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b

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

- 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 July 2006 13:38 À : mysql

Re: Show tables replacement

. 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 -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM

Re: Backup questions

. 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++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b

Re: Backup questions

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:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS

Re: Backup questions

, 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'm pretty sure I can't convince most people, but I like to try. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK

Re: Recommended backup scripts for mysql databases

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. -- Daniel da Veiga Computer Operator - RS - Brazil

Re: Recommended backup scripts for mysql databases

| bzip2 -c path/to/backup/$date-database.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?

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 -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: PHP mysql_connect

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- w O M- V- PS PE Y PGP- t

Re: mysqld refuses to run on boot

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++ --END GEEK CODE BLOCK

Re: Just need script for creating tables

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 append. -- Daniel da Veiga Computer Operator

Re: About mysqldump

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++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List

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

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-? s:- a? C++$ UBLA++ P

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

. There are not such configs, sorry, but you gotta test your configs because I don't think anyone would give 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

Re: How to backup and restore

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 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK

Re: How To Pronounce MySQL

an idiot) I personally will avoid these situations. -- 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

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): 060607 22:37:33 [Note] mysqld: Shutdown complete

Re: Sad, I know...

.. no commands.. nada.. On 6/6/06, Daniel da Veiga [EMAIL PROTECTED] wrote: On 6/6/06, tomáz rezistänz [EMAIL PROTECTED] wrote: extreme snip I have no idea how to log in to mySQL... can you help? MySQL_dir/bin/mysql.exe for Windows /usr/bin/mysql (AFAIK) for *ix like

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

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-- -- MySQL General Mailing

Re: MySQL crashes

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 Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y

Re: UPDATE from one server to another

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+ r+ y++ --END GEEK

Re: Query performance.

... 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+++$ 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

Re: Sad, I know...

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 M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y

Re: Moving database files to larger partition?

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++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V

Re: please help me.

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

Re: How to get machine independent unique id??

. -- 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 For list archives

Re: Where is the triggers run when replicating?

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+ G+ e h+ r+ y++ --END GEEK CODE

Re: Take my name off your list !!

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 b+ DI

Re: Quick Linux/MySQL performance questions.

RAM, that's my advice, since your system seems pretty powerful. Also check MySQL manual on optimization, and check the variables and the way they are set on your system. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA

Re: MySQL crashes randomly

, maybe its an issue fixed by now. -- 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

Re: batch installation of mysql 5.0

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

Re: Need help in recreating .MYD files

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 replicated server and binlogs saved daily too). -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN

Re: Need help in recreating .MYD files

scripted in bash (linux) or even in .bat (windows) was always better than any other tools. -- 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: how to restart mysql and apache?

://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+ 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 -BEGIN GEEK

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 (mandrake cooker 10) - since our admin is out

Re: Backups with MySQL/InnoDB

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- Version: 3.1 GCM/IT/P/O d-? s:- a? C

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

(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 Computer Operator - RS - Brazil

Re: Re: How to find size of my database

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- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK

Re: Error wiht VB 5 and MySQL

1.2569 correctly, but can't see 1,2569 (note the comma instead of the dot). Isn't this a problem with your app? I believe MySQL is returning the correct values, your app is just showing them incorrectly, check your language manual about WHY the appears and the causes for it. -- Daniel da Veiga

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

, 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++$ 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

Re: Accumilating Blog Comments

, more a PHP one. Check this: http://www.php.net/manual/en/function.mysql-num-rows.php -- 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: Error wiht VB 5 and MySQL

/[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+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing

Re: How to initiate a prog. via mysql

, 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, you'll have to keep it running and as Dan said check the value constantly. Kinda weird if you ask me. -- Daniel da Veiga Computer Operator

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 GCM/IT/P

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. Don't get me wrong, try not to top-post, it makes

Re: Password expire?

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 Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List

Re: GUI Tools for administering and reporting

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+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y

Re: query problem

://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+ G+ e h+ r+ y++ --END GEEK CODE BLOCK

Re: mysql 5.0 too new?

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 For list archives: http

Re: How can I observe mysqld?

://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+ G+ e h

Re: data backup

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 For list archives: http

Re: Logging (wrong) passwords by mysqld

/[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+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General

Re: upgrade from 4.1 to 5.0

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 Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L

Re: email to db

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-- -- MySQL General Mailing List

Re: mysqlimport, \r\n and \n

... -- 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 For list