Differences Between ORACLE SQL PLus and MYSQL SQL
All, Could you please tell us what are the differences between ORACLE SQL plus and MYSQL SQL? Thank you :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql to Oracle migration
Look at http://www.ispirer.com It is free and very good tool to do it. I did it from Oracle to MySQL, but you can do it from Mysql to oracle. Good luck! -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:17 PM To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: Re: Mysql to Oracle migration You need to talk to Oracle, or look on an Oracle mailing list. People here are more concerned about migrating from Oracle to MySQL, rather than the other way around. There are probably lots of commercial tools out there that will do it (and compared to your Oracle licensing costs, they are probably relatively cheap). David Clyde Lewis wrote: Does anyone know of a straght forward approach to migrate a mysql(4.1.11) Schema to Oracle(9i release 2). Also, please provide any best practices. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Change columm Name
All, How do we change column name in the tables where there are constraint as PK, FK,...? V/R Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Import data (BLOB) from txtt file to mysql
All, Could you tell me how to import data (file.txt)with BLOB column to mysql? Thank you Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Show Constraint_type
Good morning All, What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or FOREIGN KEY of and schema? Thanks.Nguyen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can not connect to Mysql server with Number 2003
All, In a few minutes ago, I can connect to mysql. Log out and can not login with error Mysql error Number 2003 can't connect to Mysql server.. Any idea, please help! Thank you..Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No data transfer, using Mysql Toolkit
All, I used migration tool kit from myslq and did migration from Oracle to Mysql. No error occurred, but there are no data transfer? Do I need to set up something on the server before I do migration? Thank younguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin Shutdown fail
I used command: c:\mysql\bin\mysqladmin -u root shutdown and I got error : mysqladmin: connect to sever at 'localhost' fail error 'Access denied for user 'root'@ 'localhost' (using password: NO) Does anyone know why? Please share with us. Thankyou..Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqladmin Shutdown fail
Thankyou. But, when I startup I got error like Innodb: error: log file .\ib_logfile (0,1) is different size Innodb: than specifiled in the .cnf file 050729: {eror} can't init database 050729:{error} aborting Could you please tell me why? Thank you -Original Message- From: Scott Hamm [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 02, 2005 8:06 AM To: Nguyen, Phong Cc: mysql@lists.mysql.com Subject: Re: mysqladmin Shutdown fail If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p it should prompt for password. On 8/2/05, Nguyen, Phong [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I used command: c:\mysql\bin\mysqladmin -u root shutdown and I got error : mysqladmin: connect to sever at 'localhost' fail error 'Access denied for user 'root'@ 'localhost' (using password: NO) Does anyone know why? Please share with us. Thankyou..Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://lists.mysql.com/[EMAIL PROTECTED] -- Power to people, Linux is here.
Startup with Error
when I startup I got error like Innodb: error: log file .\ib_logfile (0,1) is different size Innodb: than specifiled in the .cnf file 050729: {eror} can't init database 050729:{error} aborting . Could you please tell me why? Thank youNguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MAX BLOB can Hold UP?
Good morning All, ORACLE, BLOB (Binary Large Object) can hold up to 4 GB of data. How about Mysql? Thank you, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration from ORACLE 9i to MySQL
Shawn Green, You are right? I agree as you said Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Thank you for input, Nguyen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 2:25 PM To: Johnson, Michael Cc: mysql@lists.mysql.com; 'Nguyen, Phong' Subject: RE: Migration from ORACLE 9i to MySQL Johnson, Michael [EMAIL PROTECTED] wrote on 07/28/2005 01:56:33 PM: Why are you going backwards MySql is an 8th grade toy. -Original Message- From: Nguyen, Phong [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 9:42 AM To: mysql@lists.mysql.com Subject: Migration from ORACLE 9i to MySQL I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: Migration from ORACLE 9i to MySQL
Thank you for your input, V/R, Phong -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 3:41 AM To: Johnson, Michael ; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com; 'Nguyen, Phong' Subject: Re: Migration from ORACLE 9i to MySQL Shawn, others, Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. It all depends on the application it's used for. MySQL 5 is a very nice release - once stable, of course - but in some regards, it has a long way to go. No doubt, many Oracle applications can be converted to MySQL, but this is because those applications don't use Oracle well enough :) IMO, duplicating something that can, could and should be done on the server in client code is a step backwards. In earlier days, the foreign key constraints like described in the MySQL documentation was a shining example of ignorance on the part of the documentation writers. Luckily, InnoDB has foreign key constraints. But there are plenty of other applications that cannot be converted to MySQL, no doubt, some run fine and dandy... We use MySQL here in the office as well, but use InterBase and Firebird for others... The right tool for the job makes the whole difference. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Migration from ORACLE 9i to MySQL
I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?
Good morning, I have scripts to create constraints, sequences, storage..., tables from ORACLE and I don't know if I can create them in MySQL? Appreciated your help, Thank you, Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]