Oracle to MySQl conversion

Good evening all, I've got an Oracle text dump from a client for conversion to MySQL. Before I dive into SED or Perl does anyone know of a script to convert the dump file? I did the dev site by hand, not much to it, the site is fairly simple. Mostly NUMBER to INT, VARCHAR2 to VARCHAR, and CLOB

MySQL, Third Edition is available

MySQL, Third Edition (Sams Developers Library, 2005) has been published. More information is available at the book's Web site: http://www.kitebird.com/mysql-book/ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives

myodbc, mysql 5.0.0-alpha

I'm having trouble compiling myodbc-3.51.11 against mysql 5.0.0 - something about int2str has too many arguments - should I be using a newer version of myodbc (I couldn't find one), or is it not supported yet for mysql 5.0.0, or ...? Running debian / linux 2.6.9-2-k7. Frederik -- http://ofb.net

Question on Unicode/UTF8

I know this issue has been brought up many times and I have tried to search and read as much as possible but still have not been able to resolve my issue. I have a mysql database (not the latest but it supports unicode). I am keeping some columns in utf8 format and only save data that is in utf8. H

Newbie: mysql syntax error question

My server has mysql: version 3.23.58 // Performing SQL query SELECT cities.city, regions.region, countries.country FROM cities JOIN subnets on subnets.cityid=subnets.cityid JOIN regions on subnets.regionid=regions.regionid JOIN countries on subnets.countryid=countries.countryid where subnets.

Replication problem

I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication I setup the GRANT statement on server5

Re: MySQL and phpMyAdmin

Even I had the same problem so I moved to using SQLyog and its an awesom client. http://www.webyog.com Karam --- Asad Habib <[EMAIL PROTECTED]> wrote: > I just installed phpMyAdmin, made the appropriate > changes in the > config.inc.php file, and got the following error > when accessing it via >

Re: MySQL and phpMyAdmin

Did you try searching on the error message first? I got hundreds of hits in Google for this. Searching the mysql docs, the first hit has the explanation. The short version is that password security has been improved in mysql 4.1, so clients

MySQL and phpMyAdmin

I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am

Re: Which one of these two queries would be fastest?

> Assuming everything is properly indexed. > > (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1, > field2 FROM my_table_2; > > or > > (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1, > field2 FROM my_table_2; > > Is there anything to say about this in a general

Re: [MySQL] mysql/snort/webmin/permissions

Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path

Fedora

Hi, in a fedora i install mysql 4, i upgrading to mysql 4, but when i put mysqld, say can´t start server: bind on tcp/ip port, before restart computer when i put ps, appear an mysql_safe but now no, with the same error. -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Which one of these two queries would be fastest?

Assuming everything is properly indexed. (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1, field2 FROM my_table_2; or (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1, field2 FROM my_table_2; Is there anything to say about this in a general sense, or does it al