Re: Help saving MySQL
On Thursday 17 December 2009, Daisley, John (Burton) wrote: >I think that letter actually does MySQL a favour as it points out > >'MySQL has been used as a pricing lever by Oracle customers' > >That single factor says Oracle should not be allowed to control MySQL as it > would enable Oracle to more easily raise or maintain high prices! For > something to be an effective 'pricing lever' it has to be a viable > alternative. MySQL is a very effective pricing lever on Oracle as it is a > mature and proven product with excellent support. > >Regards > >John > >-Original Message- >From: Martijn Tonies >Sent: 16 December 2009 13:16 >Cc: mysql@lists.mysql.com >Subject: Re: Help saving MySQL > >> It's still not too late to save MySQL and everyone that is using MySQL >> > > can help making a real difference. > > Please visit > > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > > and write a message to EC! > > > > Regards, > > Monty > > Guess you don't want them to write letters like this? >http://kirkwylie.blogspot.com/2009/12/my-open-letter-to-european-competitio >n.html > Shesh, this guy should get a job as a spin doctor for Tiger Woods! -- Cheers, Gene "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author) The NRA is offering FREE Associate memberships to anyone who wants them. <https://www.nrahq.org/nrabonus/accept-membership.asp> An Italian is COMBING his hair in suburban DES MOINES! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql vs fedora-kde-akonadi Q
Greetings; I'm an absolute newbie at databases. Originally I installed mysql because it was needed by mythtv, and with a lot of help I got that to work, although mythtv itself is yet another story. Then I messed up x and was forced to upgrade from my fedora 8 install to fedora 10. Then I installed the mysql rpms over the top of the original tarball build and did not lose the working configs I had, they still work just fine I think. But kde uses a utility to manage some things for kmail, and it starts this service called akonadi. So I as root, run mysqladministrator and setup a user named akonadi using that for a passwd, then I setup akonadi to use akonadi as a login name and passwd. That doesn't work, akonadi fails to login and exits. And kmail continues on its merry way without it. Using the aussie dictionary for spell checking regardless of what I set it to. However, that leaves about a 20 second delay, and a bunch of error advisory window boxes to close. How can I discover what is wrong? I don't even know if either of these apps keeps a logfile. Or where if they do. I need help. Thanks everybody. -- Cheers, Gene "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author) Q: How do you keep a moron in suspense? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Locked myself out
I seem to have locked myself out of my database. RH8/4.0.18-standard ... the key user does not have file/reload/etc access. and no access at all to database mysql.. Is there some way to break this down as system root or is the only solution to delete the whole thing and re-install it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: So Slowly
I have a myisam database on a little Redhat 8 Celeron P3-866 with less than 256MB of ram. (Schema attached). While response for single table queries is excellent. (Double table queries are also mostly good.) More real world (ie complex) queries are glacial in their execution. My suspicion is that the either I have the database "tuned" wrong, (which one of these buttons do I push and how much) or the machine is just terribly underpowered. (I could try this on a dual P3-1ghz server with 2gb ram, but the microsofters will whine.) The tuning parameters are set at defaults... (not touched since rpm install). 4.0.18 database version. The schema isn't special, but the file is too big for the mail system... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance Koan
I've got 2 Redhat 8 machines with 4.0.1 (? latest) database. Machine1 is a P3-750, Machine2 is a P4-1.6 .. The same database is deployed to both machines using myisam tables. Query on Machine 1 takes almost 2 min to produce data. Same query on Machine2 returns in 5 seconds... ? Why? (I don't expect the same, but close would be nice.) thanks, ghd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql to oracle conversion
Hi. Is there a tool to convert a mysql database to oracle? thanks = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error 1064
That's what I used : mysql testdb < exp. Sorry about the typo Gene --- Gerald Clark <[EMAIL PROTECTED]> wrote: > > > Gene Gurevich wrote: > > > Hi all: > > > > I'm trying to import the tables from the dump file > > via > > > > mysqldump testdb < exp > > That should be: > > mysql testdb < exp > > > > > > and it complaints about the command in the export > > file: > > DROP TABLE IF EXISTS db; > > CREATE TABLE db ( > > Host char(60) NOT NULL default '', > > Db char(64) NOT NULL default '', > > User char(16) NOT NULL default '', > > Select_priv enum('N','Y') NOT NULL default 'N', > > Insert_priv enum('N','Y') NOT NULL default 'N', > > Update_priv enum('N','Y') NOT NULL default 'N', > > Delete_priv enum('N','Y') NOT NULL default 'N', > > Create_priv enum('N','Y') NOT NULL default 'N', > > Drop_priv enum('N','Y') NOT NULL default 'N', > > Grant_priv enum('N','Y') NOT NULL default 'N', > > References_priv enum('N','Y') NOT NULL default > 'N', > > Index_priv enum('N','Y') NOT NULL default 'N', > > Alter_priv enum('N','Y') NOT NULL default 'N', > > UNIQUE KEY Primary (Host,Db,User), > > KEY User (User) > > ) TYPE=MyISAM MAX_ROWS=1000 PACK_KEYS=1 > > > > Specifically the last three lines. The file I'm > using > > was created via mysqldump --add-drop-table > > --all-databases. I can't understand why a file > created > > by a mysqldump can have any issues. Can anyone > explain > > that for me? Is there a error search engine on > > mysql.com (something like oracle has on > oracle.com)? > > > > thanks in advance = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error 1064
Hi all: I'm trying to import the tables from the dump file via mysqldump testdb < exp and it complaints about the command in the export file: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) NOT NULL default '', Db char(64) NOT NULL default '', User char(16) NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', UNIQUE KEY Primary (Host,Db,User), KEY User (User) ) TYPE=MyISAM MAX_ROWS=1000 PACK_KEYS=1 Specifically the last three lines. The file I'm using was created via mysqldump --add-drop-table --all-databases. I can't understand why a file created by a mysqldump can have any issues. Can anyone explain that for me? Is there a error search engine on mysql.com (something like oracle has on oracle.com)? thanks in advance = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how do I export/import the whole database
HI all. Can I export/import the whole database in MySQL. I have exported the database into a text file. Now when I try mysql 'database' < filename; it errors out because column_privs table exists. I thought mysqlimport would help, but judging by what the manual says it only imports the single tables. What I'd like to do is to export the database so that i can import it back if a table is lost or corrupted. Can I do that? = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump question (very basic)
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs Oracle vs Acess
Hi This is a very generic quesiton and I would appreciate any info. I am an Oracle dba; our developers are now using access for their own small projects. When these projects grow and become too large for Access we move them to Oracle. The developers are now considering switching from Access to MySQL and I'm trying to figure out what are the advantages of that move. I have read some documentation and it looks like a big advantage of MySQL vs Access is multi-user access. There are also some features that are present in Oracle but missing in My SQL like views, subqueries and a few other. I was wondering if someone who has working experience in both Access and MYSQL (or ORacle and MySQL) could expand on the differences from practical standpoint. Thanks for any input = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] Database size
I hate to ask this on the list, but I have tried everything to unsubscribe and nothing works. Any suggestions? Thanks. -Original Message- From: TIGNAC BRUNO <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, August 03, 2001 11:00 AM Subject: [MySQL] Database size >--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21 > >Hello, > >I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One >of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use >MySQL/InnoDB ? > >Thank you. > >Bruno Tignac > > 03-08-01 17.21 Envoyé - > -> mysql(a)lists.mysql.com > >-- >Ce message et toutes les pieces jointes (ci-apres le "message") sont >confidentiels et etablis a l'intention exclusive de ses destinataires. >Toute utilisation ou diffusion non autorisee est interdite. Tout >message etant susceptible d'alteration, l'emetteur decline toute >responsabilite au titre de ce message s'il a ete altere, deforme ou >falsifie. >--- >This message and any attachments (the "message") are confidential and >intended solely for the addressees. Any unauthorised use or >dissemination is prohibited. As e-mails are susceptible to alteration, >the issuer shall not be liable for the message if altered, changed >or falsified. > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL errors during high activity
I know this has come up before, but I couldn't find a satisfactory solution. I'm running MySQL 3.23.23 on mandrake linux. It's used by a web site that has very high activity. During times of high activity, I find my perl scripts generating two kinds of errors: DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query at ... DBI->connect(games) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at The MySQL log does not errors. This happens both with Apache::DBI and plain DBI run at the command line. Does anyone have advice on getting rid of these errors? Thanks. -- -- smalltime industries brings you the latest in games, information, art, and interplanetary transport. Visit us at www.smalltime.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php