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

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

-
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)

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

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

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