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 M

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

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

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 tab

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

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

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