Re: Help saving MySQL

2009-12-17 Thread Gene Heskett
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.blogspo

mysql vs fedora-kde-akonadi Q

2009-03-14 Thread Gene Heskett
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

Locked myself out

2004-03-29 Thread Gene H. Dreher
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? -- MyS

FW: So Slowly

2004-03-26 Thread Gene H. Dreher
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

Performance Koan

2004-03-21 Thread Gene H. Dreher
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 do

mysql to oracle conversion

2001-09-12 Thread Gene Gurevich
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 --

Re: error 1064

2001-09-12 Thread Gene Gurevich
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 > > >

error 1064

2001-09-12 Thread Gene Gurevich
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 '',

how do I export/import the whole database

2001-09-10 Thread Gene Gurevich
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 tab

mysqldump question (very basic)

2001-09-10 Thread Gene Gurevich
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

Re: my.cnf file

2001-09-05 Thread Gene Gurevich
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

MySQL vs Oracle vs Acess

2001-08-31 Thread Gene Gurevich
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 M

Re: [MySQL] Database size

2001-08-03 Thread Gene Sanborn
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 siz

MySQL errors during high activity

2001-02-16 Thread gene
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 fa