Re: SSH tunnel for Mysql
If you are looking for a client to connect to MySQL using SSH tunnel, try out SQLyog. It has SSH Tunneling. Karam --- Jerry Swanson [EMAIL PROTECTED] wrote: How to create ssh tunnel for Mysql? TH __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table design question
Hi, A very simple question. I have two products at our website and i would like to keep track of how many of each softwares were downloaded daily. I am planning to create the following table: id - auto_incr date_of_download - data product_name - enum value containing the two products Then I plan to use: select date_of_download, product_name, count(*) from table table group by 1,2 Any other faster method or design? Karam __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: converting access (.mdb) files...
If you can catch hold of a windows box then there is tool called SQLyog that has a great migration tool. I was able to import a clients MDB database with all the FKs directly from Access to MySQL. You dont need to go thru Access - Script - MySQL. You can download it from http://www.webyog.com Karam --- Craig Hoffman [EMAIL PROTECTED] wrote: Anyone know a way to convert MS Access DB files (.mdb) into a format MySQL can import? I'm on a Mac hence I don't have Access. Best, CH ___ Craig Hoffman www.eclimb.net [EMAIL PROTECTED] iChat / AIM: m0untaind0g ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating MySQL users
Hello, First all it is not recommended at all to dump and import user information. Secondly the user authentication system has changed between 4.0 and 4.1 so old passwords from 4.0 wont work. Its given in the docs. Thirdly, MySQL does not store the actual password in its database. It always keeps a hash of the password and all the comparison are done against it. Karam --- [EMAIL PROTECTED] wrote: Hello everyone, I'm working on migrating a number of users to a different database server. mysqldump makes this quite easy, but I've run into a surprising issue with the new server. I imported things like this: # mysqldump --skip-add-drop --all-databases | mysql -h newbox -u root -p Somehow this didn't get the mysql.user table correctly. So I dumped that one seperately like this: # mysqldump --skip-add-drop --skip-extended mysql user | mysql -h newbox -u root -p mysql Now I have all the users in the new mysql.user table. But when I try to login, the same credentials do not work. Both DB servers are 4.1 servers, one happens to be Debian and the other RedHat. Both servers have the wide password field and use old_password in my.cnf. Any reason why these moved accounts are unable to authenticate? -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians have made a covenant with the devil to darken the spirit and to confine man in the bonds of Hell. --St. Augustine, De Genesi ad Litteram, Book II, xviii, 37 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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
I have been using SQLyog's ODBC Import tool for quite some time now. http://www.webyog.com Karam --- Nguyen, Phong [EMAIL PROTECTED] wrote: 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] __ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data sync offline
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent SJA is available for both Linux and Windows. Karam --- Alex Greg [EMAIL PROTECTED] wrote: Hi, Our company is considering migrating some tablesfrom MyISAM to InnoDB, as it has row-level locking and other improvements over MyISAM. However, one of the things we do at the moment is rsync the MySQL data directory to our development server every night over an 2Mbps ADSL connection (as we have 40GB of data, downloading it all every night isn't a viable option). I am aware that you can't copy the InnoDB binaries around to different installations. Does anyone have any suggestions as to how we could continue to do incremental downloads of this data over a slow connection? Regards, -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error no: 12 (
Hello, I am running MySQL on a WinXP box. I am getting the following error: Error no: 12 can't read dir of './tablename/' (errorcode: 2) What does this error mean? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Case issue in Information_schema
Hello, I was just checking INFORMATION_SCHEMA in 5.0.10. All the tables, columns and values are given in CAPS lock. The case is not important in Windows but it is in Linux. Do I assume that even in Linux it will be in CAPS and the case is not going to change in near future? Karam __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQLDUMP and Triggers, Functions and SP
Hello, mysqldump bundled with 5.0.10 does not seem to support the above features. Any plans when they will be supported? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 5.0.10 compilation error
Hello, I am trying to compile 5.0.10. While compiling i am getting the following error: e:\mysql5010abetasrc\extra\yassl\src\yassl_imp.cpp(393) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 2701) Please choose the Technical Support command on the Visual C++ Help menu, or open the Technical Support help file for more information and 5-6 more similar to this. I am also getting this one: LINK : fatal error LNK1181: cannot open input file '..\extra\yassl\Debug\yassl.lib' What should I do? Previously, it used to compile without any problem! Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 5.0.10 compilation error
I plan to modify mysqldump and mysql import utility to support SP, Triggers etc and plan to send a patch to the MySQL development tree. Thus downloading the binary does not seem to be option :) --- Martijn Tonies [EMAIL PROTECTED] wrote: I am trying to compile 5.0.10. While compiling i am getting the following error: e:\mysql5010abetasrc\extra\yassl\src\yassl_imp.cpp(393) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 2701) Please choose the Technical Support command on the Visual C++ Help menu, or open the Technical Support help file for more information and 5-6 more similar to this. I am also getting this one: LINK : fatal error LNK1181: cannot open input file '..\extra\yassl\Debug\yassl.lib' What should I do? Download the binaries? 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] Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM?]: Case issue in Information_schema
Thx. That answered my question. karam --- Mark Leith [EMAIL PROTECTED] wrote: Hi Karam, I'm not sure what you mean by All the tables, columns and values are given in CAPS lock... Certainly, all of the INFORMATION_SCHEMA tables and their columns are defined in upper case. This probably won't change.. However, any values are stored in the case that they were created in. For example, if you created a table in test called foo, and were to SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'test'; it would return foo - not FOO. HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: 10 August 2005 15:26 To: mysql@lists.mysql.com Subject: [SPAM?]: Case issue in Information_schema Hello, I was just checking INFORMATION_SCHEMA in 5.0.10. All the tables, columns and values are given in CAPS lock. The case is not important in Windows but it is in Linux. Do I assume that even in Linux it will be in CAPS and the case is not going to change in near future? Karam -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/2005 __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ALTER TRIGGER in MySQL
Hello, I was reading the docs on Triggers at: http://dev.mysql.com/doc/mysql/en/using-triggers.html Looks like there is no support for Alter Trigger. So if I want to change a trigger, I have to first drop the existing one and recreate another? Am I correct? Karam Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DROP VIEW Syntax
Hello, In the MySQL Docs at http://dev.mysql.com/doc/mysql/en/drop-view.html, it says: RESTRICT and CASCADE, if given, are parsed and ignored. I am not sure if I understood this? Regards, karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: migrate Access to MySQL
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027showtopic=1536view=getnewpost Karam --- Bing Du [EMAIL PROTECTED] wrote: Hello, I've been looking around for a while. Seems there are many options and tools that can help do it. Guidance and directions are highly welcome. We need to move the contents of a bunch of tables from Access to the existing tables on MySQL. The target tables in MySQL already have some information. So we need some how to map Access fields to MySQL fields. Anybody would like to share experience about how you did your migration and what kind of tool can best meet needs as such? Thanks much in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQLyog Enterprise
Hello, I find SQLyog Enterprise an indispensable tool. Your $49 will be saved within the first 3 days of use because of improved productivity with MySQL. Karam --- Scott Hamm [EMAIL PROTECTED] wrote: I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical) for personal use. Do anyone use it and how does it fare in your opinion? -- Power to people, Linux is here. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simple data GUI editor?
I have been using and would highly recommend SQLyog from http://www.webyog.com Regards, Ritesh --- D_C [EMAIL PROTECTED] wrote: i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simple data GUI editor?
Have you tried SQLyog? Somehow I prefer it more then MySQL-Front. Regards, Karam --- Carl [EMAIL PROTECTED] wrote: We use MySQL-Front from Star-Tools GmbH (www.mysqlfront.de)... works pretty much like you have asked. Thanks, Car - Original Message - From: Berman, Mikhail [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: D_C [EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:36 PM Subject: RE: simple data GUI editor? Well, Actually MS-Access through ODBC should work for you -Original Message- From: D_C [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 4:28 PM To: mysql@lists.mysql.com Subject: simple data GUI editor? i was wondering if people can recommend a simple Excel like tool for editing data? MySql control center - seems to have limitations (unicode, not in dev anymore) Query browser - have to type raw sql to show/hide columns... ideally i want something with a few more features than either of these, eg list data in a vertical table rather than just horizontal... lookups to other tables but more oriented to lots of interactive editing of the DB data than DB admin. I guess more like an Access GUI... (puts on flame pants) + ideally not very expensive :-) thanks! -- 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] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 6/15/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Backup/Dump
If you are on Windows then you can use a GUI like SQLyog (www.webyog.com) to do the job. I think it will be the easiest way to do that. Karam --- Kory Wheatley [EMAIL PROTECTED] wrote: I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed mysql 4.1.10 What is the best command to do a backup and dump everything into the new MYSQL version on a different box? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating from IBM Universe to mySQL
Hello, I guess IBMs Universe Database will be having an ODBC interface. Then you can use a GUI like SQLyog (www.webyog.com) to do an ODBC Import from IBMs database to MySQL. Regards, Karam --- Rahul Bollampally [EMAIL PROTECTED] wrote: Hi, Has any body migrated an IBM's Universe database to mySQL if so could you guys please help me out, I need to migrate a huge dataset in Universe to mySQL to generate an analysis report. Rahul :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Since I am on Windows, I prefer to use a GUI tool like SQLyog (www.webyog.com) Karam --- Adrian Cooper [EMAIL PROTECTED] wrote: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Export from Access
If you are on Windows then you can directly import data using SQLyog's ODBC Import Tool. www.webyog.com Regards, Karam --- S.D.Price [EMAIL PROTECTED] wrote: Hi, can anyone explain how I would export a database created in Access to MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt. Thanks Steven Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Work / Home DB synchronization
Hello, I am not the final authority on this but you can use SSH/HTTP Tunneling. More information on it can be found at: http://www.devx.com/security/Article/27854?trk=DXRSS_DB If you have any question regarding, SQLyog, I guess - http://www.webyog.com/forums would be your best guess. Karam --- Scott Purcell [EMAIL PROTECTED] wrote: Thanks for the info. I did not know there was a GUI for the mysql product. I installed it and its like Toad for mysql. Very cool. As I am not very strong at using mysql, I am a J2EE developer. I came up with two questions I need some more support with. 1). My home box does not have a static IP address, and my machine at work is behind a firewall, and we use DHCP. So I do not know if I can use sja? Anyone know? Upon reading, it looks like there is a need to use an IP on both ends. 2). Do ISPs allow this type of synchronization? 3). Is there a way to do a simple backup in the interim (copy the data to removable media) and copy to other machine until I get this all worked out? I see some export data capability in the SQLyog program. But do not know if this is valid? Thanks, Scott -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 12:08 PM To: Scott Purcell; mysql@lists.mysql.com Subject: Re: Work / Home DB synchronization You require SQLyog's Data Sync Tool. Download it from http://www.webyog.com You can find an article on it at: http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent Karam --- Scott Purcell [EMAIL PROTECTED] wrote: Hello, I am developing a web application in which I have been working between home and an away office. Anyway, up to lately, most of my efforts have been writing the queries, etc for the backend. So I have a text file that dumps the database and repopulates them. And up until now, it has been effective in getting some basic data into the datase to code against. But now, that portion is done, and I am starting to port more data into the database. Data I need to display purposes, etc. Is there a simple, easy, effective way to transfer the data between home and away? What I do for the code, is create a .war file and copy that to a ram stick and transfer it that way. But when it comes to the database, I am not sure how to keep them synchronized? Less than 10,000 total records at launch time. Thanks, Scott K Purcell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Work / Home DB synchronization
You require SQLyog's Data Sync Tool. Download it from http://www.webyog.com You can find an article on it at: http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent Karam --- Scott Purcell [EMAIL PROTECTED] wrote: Hello, I am developing a web application in which I have been working between home and an away office. Anyway, up to lately, most of my efforts have been writing the queries, etc for the backend. So I have a text file that dumps the database and repopulates them. And up until now, it has been effective in getting some basic data into the datase to code against. But now, that portion is done, and I am starting to port more data into the database. Data I need to display purposes, etc. Is there a simple, easy, effective way to transfer the data between home and away? What I do for the code, is create a .war file and copy that to a ram stick and transfer it that way. But when it comes to the database, I am not sure how to keep them synchronized? Less than 10,000 total records at launch time. Thanks, Scott K Purcell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore database
I prefder to use a FREE GUI like SQLyog found at http://www.webyog.com Karam --- Gary Richardson [EMAIL PROTECTED] wrote: try mysqldump -keq SDN SDN.sql Then you can import it on another instance using mysql -u root new_instance SDN.sql On 5/5/05, zlf [EMAIL PROTECTED] wrote: Hi all, I have installed a MySQL5.0 instance on Windows. And then created a database( named 'SDN' ). Now I want to move this database to another MySQL5.0 envirnment on Linux. How can I make it. Thx zlf -- 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] Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to export a table to a CSV file?
If you are windows then I prefer to use SQLyog at http://www.webyog.com to do the job. ITS FREE! Karam --- Homam S.A. [EMAIL PROTECTED] wrote: NOTE: I sent this message yesterday, but for some reason it didn't show up in the list. If you've already received it, I apologize for the inconvenience. So here it goes again: I searched the online manual and all I could find was a reference to a statement of the form: SELECT INTO OUTFILE... http://dev.mysql.com/doc/mysql/en/ansi-diff-select-into-table.html I searched for this statement on the web and I found several references to a statement that should look like this: select * into outfile 'C:/MyOutfile.txt' fields terminated by ',' lines terimated by '|' from myTable This statement generates a syntax error on MySQL 4.1.9. The following variation also generates a syntax error: select * from table into outfile 'C:/MyOutfile.txt' fields terminated by ',' lines terimated by '|' from myTable Why is this statement rejected? Why is it not documented anywhere in the manual except for a passing reference? And if there's no such a statement, how come there are many references to it on the web that date back to MySQL versions older than 4.1.9? Finally, if this statement has been depricated/removed from 4.1.9, is there any way to export a table to a CSV file? Thanks, Homam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: C API: Storing is easy; How do you retrieve?
The docs should have it. Basically these API is what you require (in order): mysql_init(); mysql_real_connect(); mysql_real_query(); mysql_store_result() or mysql_use_result(); mysql_fetch_row(); mysql_free_result; mysql_close (); HTH --- Matthew Boehm [EMAIL PROTECTED] wrote: Hey guys, (Why is there no C API specific list?) I want to write a C application that can take some audio file, store it in MySQL, then at a later date/time (upon request) pull from db and write to temporary file to be streamed. I've got the storing portion of the code down. The problem I have is, how do I SELECT out the audio and store it to a file on the local disk? Any examples? Sample code? Specific API functions I should look at? I've seen how this is done using ODBC, but the ODBC code is really crappy and not at all as easy as MySQL API. Thanks, Matthew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup databases one to another
This option involves two steps. First you have to export complete data and then import it again. You can do this more efficiently by using a sync tool like Webyog (www.webyog.com). It will sync any two MySQL databases with changes only done to modified rows/columns. YOu can probably mail their support people Regards Karam --- Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Something like: mysqldump -h 192.168.1.1 -uroot -p -A backup.sql See: http://dev.mysql.com/doc/mysql/en/mysqldump.html Abdul Aziz [EMAIL PROTECTED] wrote: Dear All, I wish to backup all databases to my server(192.168.1.1) from my host(192. 168.1.5) with (mysqldump),how can we possible,plz tell me command or Script with brief description. Thanks in advance aaziz -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help coverting MDB SQL
I have been using SQLyog for quite some time now to import data from Access and SQL Server database. www.webyog.com Regards, Karam --- Ricky Groleau [EMAIL PROTECTED] wrote: Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a forum run by MDB and in the transfer as you know...it wont work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2 converters...and MySql..again I have failed. The database is almost 9 meg. I need someone that can convert this for me and then explain how to upload since it is so big. I have read you cannot to it thru the web/mysql? Any help...guidancePLEASE! Regards, RickyG __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
If Dbase3 has an odbc driver then you can use SQLyog (www.webyog.com) to import data to MySQL. Karam --- Peter L. Berghold [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. There are a bunch of ways of skinning that cat. The easiest of which IMHO is to convert the data to comma separated files first and then use any one of a number of means to get it into the database. - -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCQW7WUM9/01RIhaARArhEAJ9ukrn8JSmmwmtdy9y86TVTcIx6vQCfQwZB G3BfaZB+So4iX6kbPlQCkOA= =cQYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 using MySQL 4.1.10, the latest stable release, with phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any help would be greatly appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Remote Connection via Toad for MySQL
You can try SQLyog (www.webyog.com), it supports 3.23.x to 5.0. Lightweight and very fast! Karam --- [EMAIL PROTECTED] wrote: Good good. On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote: BINGO!!! Thanks Dan! Kelly Daniel Walker [EMAIL PROTECTED] What version of MySQL are you using? 4.1.1 uses an enhanced password hashing system that isn't compatible with clients built for older versions. This page on MySQL's own documentation provides a number of workarounds, one of which will hopefully work in your case (assuming the problem is caused by the version number of your DBM, of course ;) http://dev.mysql.com/doc/mysql/en/old-client.html HTH Daniel Walker On 24 Feb 2005, at 20:35, [EMAIL PROTECTED] wrote: Client does not support authentication __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to send queries to a database periodically
SQLyog (www.webyog.com) has an option called SQLyog Notification Services. It can execute a set of queries and even send you the report over email. Using this you can schedule it to run a set of queries anytime you want. Karam --- Peter PeterDresden [EMAIL PROTECTED] wrote: Hi, is there a possibillity in mysql to send periodically queries to a database, for example all 5 minutes? Or, a liitle bit off topic, is there a possibility to this via php? Or, is it normally possible to set up such a query via cron tab (unix based web servers only)? Thanx. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup/synchronize tables/db web-local server
SQLyog Enterprise's Database Sync Tool is the answer for your queries. www.webyog.com Rgds, Karam --- Paul Godard [EMAIL PROTECTED] wrote: Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with php/mysql. When a web site is still in development, this is the master db, even if a copy has been uploaded on the live web server at my isp. When a site is completed, the web db becomes the master (as clients and visitors are updating data on the web db). My problem is that I would like to keep the local db synchronized with the web db (at least for the tables that are regularly updated on the web). Manually I would do a dump (data export only) of these web tables onto a local file, then empty the local equivalent tables and then running the sql statements of the dump file (insert). I don't do a systematic download of the whole web db as it is sometimes too big and besides not all the tables are updated by the client/visitors. My idea is to dynamically build a mysql script via php that can do the job for each client web sites for each of the tables contained in an array and be executed from a simple click on a button on the local server of course. As I am not a mysql/php guru, I would appreciate suggestions to do this as simple as possible. Please copy the reply to my email address. Thanks in advance. -- Kind regards, Paul. Gondwana [EMAIL PROTECTED] http://www.gondwanastudio.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup/synchronize tables/db web-local server
Well I know about it and I am working on MySQL Replication, the point is that you dont have control over replicatation when your MySQL server is installed by your ISP on shared server, In that case it is simply not possible :) Moreover, the simple setup I have, I prefer this then the nittygritties of replication. Agreed, if you have a heavy duty setup then the only answer is MySQL replication. Karam --- love [EMAIL PROTECTED] wrote: It is very easier with mysql replication concipt, this automatic replication from Master server to Slave server and real time. I wonder how you do not know about this. http://dev.mysql.com/doc/mysql/en/replication.html Love kumar .. [EMAIL PROTECTED] wrote: SQLyog Enterprise's Database Sync Tool is the answer for your queries. www.webyog.com Rgds, Karam --- Paul Godard [EMAIL PROTECTED] wrote: Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with php/mysql. When a web site is still in development, this is the master db, even if a copy has been uploaded on the live web server at my isp. When a site is completed, the web db becomes the master (as clients and visitors are updating data on the web db). My problem is that I would like to keep the local db synchronized with the web db (at least for the tables that are regularly updated on the web). Manually I would do a dump (data export only) of these web tables onto a local file, then empty the local equivalent tables and then running the sql statements of the dump file (insert). I don't do a systematic download of the whole web db as it is sometimes too big and besides not all the tables are updated by the client/visitors. My idea is to dynamically build a mysql script via php that can do the job for each client web sites for each of the tables contained in an array and be executed from a simple click on a button on the local server of course. As I am not a mysql/php guru, I would appreciate suggestions to do this as simple as possible. Please copy the reply to my email address. Thanks in advance. -- Kind regards, Paul. Gondwana [EMAIL PROTECTED] http://www.gondwanastudio.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The information transmitted is intended only for the person or entity to whom it is addressed and may contain confidential and / or privileged Material. Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. Thank you for your understanding co-operation. __ Do you Yahoo!? All your favorites on one personal page Try My Yahoo! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
List of connection error
Hello, Is there any documentation where I can find a list of all connection related error/error codes returned by MySQL? Regards, Karam __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Where can I download The MySQL C API??
I am not sure what you mean by getting MySQL C API. The API are built in libmysql.lib and libmysql.dll or mysqlclient.lib. The header files are in include directory. Just include them in your project and start coding. Hope I was of help. Karam --- Shuva, Judith [EMAIL PROTECTED] wrote: Hi J.R. Thanks for your answer. I saw that the API suppose to be in the MySQL server, so I downloaded mysql-essential-4.1.9-win32.msi, but after the installation, I can't find the API in the MySQL folder... Please, HELP! Thanks, Judith -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 3:55 PM To: mysql@lists.mysql.com Cc: Shuva, Judith Subject: RE: Where can I download The MySQL C API?? http://dev.mysql.com/downloads/ Please note the section of Official APIs # Application Programming Interfaces (APIs) * Official APIs: o The C API is included with the server, above. J.R. -Original Message- From: Shuva, Judith [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 8:30 AM To: mysql@lists.mysql.com Subject: Where can I download The MySQL C API?? Hi, I just downloaded mysql-essential-4.1.9-win32.msi, and as I understood, the C API supposes to be in here. Where exactly? I can't find it Thanks, __ Judith Shuva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Serious bug (or my foolishness) with alter table and InnoDB
Hello, I am running mysql 4.1.7 on Win2K. I have two tables: CREATE TABLE `child` ( `id` int(11) NOT NULL default '0', `name` char(1) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `master` ( `id` int(11) NOT NULL default '0', `name` char(10) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; If I execute the following statement: alter table child add foreign key (id) references master (id), type = innodb; the mysql server hangs and needs to be killed. After restarting the table child is also lost. Is this a known bug? Karam __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Serious bug (or my foolishness) with alter table and InnoDB
Can somebody try this on 4.1.7? I will download 4.1.8 tomorrow and check it out. Damn...my connection is slow (on a dialup) and 35MB of download...h Regards, Karam --- Chris [EMAIL PROTECTED] wrote: There was a serious (threat of data loss) bug in 4.1.7 InnoDB . I'm not very familiar with the specifics, but this problem could be that. In any case I'd be scared to run InnoDB on a 4.1.7 without fully understanding the problem. You should definitely consider upgrading to 4.1.8 , or, at the very least, look into the bugs that were fixed in 4.1.8 and their workarounds. Chris Karam Chand wrote: Hello, I am running mysql 4.1.7 on Win2K. I have two tables: CREATE TABLE `child` ( `id` int(11) NOT NULL default '0', `name` char(1) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `master` ( `id` int(11) NOT NULL default '0', `name` char(10) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; If I execute the following statement: alter table child add foreign key (id) references master (id), type = innodb; the mysql server hangs and needs to be killed. After restarting the table child is also lost. Is this a known bug? Karam __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Serious bug (or my foolishness) with alter table and InnoDB
Thanks for your ultra detailed reply. The tables are just samples (no where related to actual table). Well I am not that bad in db designing also ;) I checked the manual - you indeed can execute two statements like this in one. And if you see the query I am even changing the table type in the later part of the query. Executing it separately causes no problem but I just wanted to know why the two comnined throw up an error. Regards, karam --- Rhino [EMAIL PROTECTED] wrote: There is certainly *something* wrong if the ALTER TABLE statement causes the server to hang; the statement should either succeed or fail with an error but in neither case should the server hang. I'm still back on 4.0.15 so I'm not in a great position to try the code myself but I see a few odd things in your statements. First of all, you are using InnoDB for 'master' but MyISAM for 'child'; as I recall, MySQL will only enforce foreign keys if both tables in the relationship are using InnoDB as their engines. You'll want to confirm that in the manual of course, I may just be misremembering. Second, your Alter table statement has a Type=InnoDB at the end. According to the manual, you *can* change the type of the table in an ALTER TABLE statement. However, based on past experience with DB2 which works much like MySQL much of the time, you probably can't do two changes in the same statement. You might have better results if you changed the table type in one ALTER TABLE and then added the foreign key in another ALTER TABLE. Or, drop both tables and recreate them so that both are InnoDB, then add the foreign key via ALTER TABLE. You can also create the foreign key while you are creating the 'child' table; that's how I normally do it. However, you may be separating the creation of the 'child' table and the creation of its foreign key into two statements deliberately and that should work correctly. By the way, I can't help but notice that your table design is rather odd. It makes little sense to have child.id be a foreign key pointing to master.id the way you are doing since they will, presumably, never contain the same values. After all, child.id contains the child's ID number while parent.id contains the parent's ID number which will, presumably, be different. Wouldn't it make more sense to do something like this [untested]? create table master (parent_id int(11) not null, parent_name char(20) not null, primary key(parent_id) ) Engine=InnoDB, charset=utf8; create table child (child_id int(11) not null, child_name char(20) not null, parent_id int(11) not null, primary key(child_id) foreign key parent_id references master(parent_id) ) Engine=InnoDB, charset=utf8; This would result in tables like this: Master parent_idparent_name 1Tom Smith 2Mary Jones Child child_idchild_nameparent_id 555 Bonnie Smith 1 689 TedJones2 You could easily look up the names of the parents of the children by joining child.parent_id to parent.parent_id and you could be assured that the child.parent_id was always a value from the Master table. Rhino - Original Message - From: Karam Chand [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 25, 2005 10:49 AM Subject: Serious bug (or my foolishness) with alter table and InnoDB Hello, I am running mysql 4.1.7 on Win2K. I have two tables: CREATE TABLE `child` ( `id` int(11) NOT NULL default '0', `name` char(1) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `master` ( `id` int(11) NOT NULL default '0', `name` char(10) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; If I execute the following statement: alter table child add foreign key (id) references master (id), type = innodb; the mysql server hangs and needs to be killed. After restarting the table child is also lost. Is this a known bug? Karam __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
RE: Serious bug (or my foolishness) with alter table and InnoDB
Hello, I just checked with the same version at home and it works. Dont know whats the problem at office. Will check again? Karam --- Artem Koltsov [EMAIL PROTECTED] wrote: Works fine on WinXP 4.1.8. Only generates warning: mysql show warnings; +-+--+--+ | Level | Code | Message | +-+--+--+ | Warning | 1287 | 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead | +-+--+--+ And here is the `child` table after execution: mysql show create table child; +---+ - | Table | Create Table +---+ - | child | CREATE TABLE `child` ( `id` int(11) NOT NULL default '0', `name` char(1) NOT NULL default '', PRIMARY KEY (`id`,`name`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`id`) REFERENCES `master` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +---+ - -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 10:50 AM To: mysql@lists.mysql.com Subject: Serious bug (or my foolishness) with alter table and InnoDB Hello, I am running mysql 4.1.7 on Win2K. I have two tables: CREATE TABLE `child` ( `id` int(11) NOT NULL default '0', `name` char(1) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `master` ( `id` int(11) NOT NULL default '0', `name` char(10) NOT NULL default '', PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; If I execute the following statement: alter table child add foreign key (id) references master (id), type = innodb; the mysql server hangs and needs to be killed. After restarting the table child is also lost. Is this a known bug? Karam __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Attention: Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL win32 and SSL
Even I had the same problem and couldnt use SSL on windows. The developers have legal issues when using SSL on windows. I think there is some development going on using CryptoAPI but I am not too sure. My advice, dont even try on Windows. Atleast it was a big pain in ass for me. Karam --- Jose Antonio [EMAIL PROTECTED] wrote: Dear all, I need SSL support for MySQL. I've checked the documentation and it seems that for windows there is no SSL support in the binaries. In addition the documentation in the examples is for Linux. Has anyone has used MySQL with SSL in windows? If so ... how? How easy is to set it up? What changes need to be done on the client side? I don't really like the idea of compiling it because then I will have to compile again every time I want to updeate it. Another possible solution will be to use tunnels like stunnel.org but I would like to have a connection as direct as possible whenever possible. Thank you in advance. José A. Martínez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL C++ API (which libraries)
The one supported by MySQL AB and the best till date is MySQL C API (well its best because I am C developer). It is the speediest too. I think you should find wrappers over the C API() over the net. If not then you can develop one for yourself and probably release it in GNU. Regards, Karam --- Andy Ford [EMAIL PROTECTED] wrote: Hi fellow developers ... I'm about to move my Perl code to C++ for security. Which mySQL libraries are the best ones to use? There are so may available I thought I'd consult the community in the know! Thanks Andy -- perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^ This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telephone and confirm that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. We use reasonable endeavours to virus scan all e-mails leaving the Company but no warranty is given that this e-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor e-mail communications through our network is reserved by us. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_use_result issue: useless iterating over unused results
Yup.
This is a normal behaviour. mysql_free_result() will
result in bringing each unasked rows to the client and
freeing it up row by row.
BTW, why do you need to do - select * from
Karam
--- Renald Buter [EMAIL PROTECTED] wrote:
Hello list,
I am having this issue with mysql_use_result: it
seems it will iterate
over all unused results if I call
'mysql_free_result'. The following
code illustrates this:
mysql_query(mysql,SELECT * FROM
a_very_large_table);
res = mysql_use_result(mysql);
i = 0;
while (row = mysql_fetch_row(res)) {
fprintf(stderr,%d,%d\n, row[0], row[1]);
if (++i 5)
break;
}
fprintf(stderr,freeing...\n);
mysql_free_result(res);
/* wait wait wait wait wait wait wait wait ... */
With 'mysql_store_results', the code would run out
of memory, because
the table is very large (20m rows). But this version
will run up to 2
minutes, taking all CPU cycles with it, just
freeing the result.
Is this normal behaviour or can I change something
for the better?
I am using mysql 4.0.22 client and server on Linux
2.6.
Thanks!
Renald
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_use_result issue: useless iterating over unused results
I am not sure why they are doing it. You need to hack the protocol to understand it. Maybe some MySQL/network GURU will be able to help yuo. Regards, Karam --- Renald Buter [EMAIL PROTECTED] wrote: On 01:55 Tue 11 Jan , Karam Chand wrote: Yup. This is a normal behaviour. mysql_free_result() will result in bringing each unasked rows to the client and freeing it up row by row. This sounds to me as a useless feature. What could be the reason for such wasting behaviour? BTW, why do you need to do - select * from I need to visit every row. Originally, this came up when debugging my code, and since then I added a LIMIT statement when doing so. But it still find these kinds of things annoying and unsatisfiying from an engineering point of view --- and I was just curious if it was *me* who did something wrong. But thanks for the answer! Regards, Renald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? All your favorites on one personal page Try My Yahoo! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ALTER TABLE....with CHANGE syntax
Hello, Can somebody tell me from which version of MySQL is - ALTER TABLECHANGE... syntax supported. Regards, Karam __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ALTER TABLE....with CHANGE syntax
Hello, I am using 4.1.7 and it works for it. I just wanted to know from which version it support has started because it does not run on my 3.23.58 server. Regards, Karam --- Andy Ford [EMAIL PROTECTED] wrote: Which version are you running. Quite often when you see a 'check the version you are running' message indicates a syntax error in your mySQL statement.. Andy On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote: Hello, Can somebody tell me from which version of MySQL is - ALTER TABLECHANGE... syntax supported. Regards, Karam __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 -- perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^ This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telephone and confirm that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. We use reasonable endeavours to virus scan all e-mails leaving the Company but no warranty is given that this e-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor e-mail communications through our network is reserved by us. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Importing data from MS Access
I found SQLyog Enterprise (www.webyog.com) to be the best when importing data from ODBC to MySQL. Karam --- Peter Brawley [EMAIL PROTECTED] wrote: Using a data modelling tool (like Dezign from Datanamic) or a scripting tool (like DbScripter), all you need do, I think, is load the Access database into the tool, configure the tool to create an export script for MySQL (say, using InnoDB to enable FKs), touch up as desired, and generate the script. PB Paun wrote: I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase in MySQL 4.1.7. Of course, there is no possibility to import foreign keys from MSAccess. Question: If I read properly documentation in MYSql is possible to use only one foreing key per table, and fields with foreign key must be on ordered on the same way in booth tables, and only in InnoDB type of tables. I have tables with many foreign key connectons (e.g. members / streets, members/occupations, members/state of membership) between tables, and it was easier way to keep data in database in proper order with less programing. Is that is not possible in MYSQL? Of course, I am very new in MYSQL. Thanks. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.9 - Release Date: 1/6/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FK Id in Innodb
Hello, http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html According to it I can specify a name/id for a relation on and after 4.0.18. Before that InnoDB provides an internal id/number. I was just curious - what happened before 4.0.18 or 3.23.x. Was an ID still provided by InnoDB and it used to come in CREATE TABLE stmt.? Since I dont have access to those versions, I was just wondering. Regards, Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ALTER TABLE....with CHANGE syntax
Hello, I plan to reorder some columns of my table. So I am using ALTER TABLE STATEMENT .. with CHANGE syntax as suggested at: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html I believe its the only way to reorder columns? Is there something better? If CHANGE is the best option, is there any version restriction for the statement or it works with all versions of MySQL? Currently I am using MySQL 4.1 where it works great but my host is still running 3.23.58 :( Regards, Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL insert with PHPMyAdmin
As far as I know there should not be any problem but I prefer SQLyog for all my MySQL work. It even has HTTP Tunneling to access dbs that dont allow remote access. Karam --- leegold [EMAIL PROTECTED] wrote: Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data entry tool. I create a new record in a table and then fill in the fields with the field editing and insert abilities of PHPMyAdmin. For a remote user of course I'd escape any inserted strings with addslashes or mysql_escape PHP functions. But I wouldn't do anything mailicious to my own DB so I'm just using PHPMyAdmin to insert, edit...anything. Are any problems possible by me doing this? Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FLUSH syntax query
So if I use FLUSH MASTERS and FLUSH SLAVES, it will have the same effect with new versions of MySQL too. Karam --- Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? 4.1.1 RESET MASTER and RESET SLAVE were named FLUSH MASTER and FLUSH SLAVES before MySQL 3.23.26. Karam Chand [EMAIL PROTECTED] wrote: Hello, From the MySQL docs: http://dev.mysql.com/doc/mysql/en/FLUSH.html What does FLUSH MASTER and FLUSH SLAVES does? Its not documented? Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? Regards, Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FLUSH syntax query
Hello, From the MySQL docs: http://dev.mysql.com/doc/mysql/en/FLUSH.html What does FLUSH MASTER and FLUSH SLAVES does? Its not documented? Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? Regards, Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Query Browser
YOu could try the free version of SQLyog. It works on my Win98. www.webyog.com Karam --- Chris [EMAIL PROTECTED] wrote: Hassan Shaikh wrote: The MySQL Query Browser online documentation clearly mentions that it runs on 32-bit Windows operating systems, including Windows 95, 98 and Me. However, while installing it on WinME, I get the following error: The Operating System is not adequate for running MySQL Query Browser 1.1 Can anyone please explain? Thanks. Hassan This was mentioned, briefly, on the MySQL GUI list: http://lists.mysql.com/gui-tools/1563 I don't know any more than that. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql client that does export and import
I use SQLyog everyday at my job. Check out http://www.webyog.com Karam --- [EMAIL PROTECTED] wrote: When you install MySQL you get several tools (not just the command-line client and the various server versions). Two of them are mysqldump and mysqlimport. The docs for all of them can be linked to from here: http://dev.mysql.com/doc/mysql/en/Client-Side_Scripts.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Duhaime Johanne [EMAIL PROTECTED] wrote on 12/14/2004 03:03:03 PM: Hello I have looked at MySql browser and MySqlAdministration and then in the mysql lists but I could not find what I was looking for. A developper is working with one of the many databasees we have. We want to allow him to import and export data from this database throught a window client (mysql in on a unix machine). Can someone suggest something? Thank you in advance Johanne Duhaime IRCM __ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Getting monthly download report
I have a table like:
CREATE TABLE `user_details` (
`id` bigint(6) unsigned NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL default '',
`user_email` varchar(50) NOT NULL default '',
`user_ref_from` varchar(100) default 'Not Given',
`other_ref` varchar(255) default 'Not Given',
`products` enum('a','b','c') NOT NULL default 'c',
`last_download` mediumint(3) NOT NULL default '40',
`want_notify` enum('Yes','No') default 'Yes',
`dateofdown` date NOT NULL default '-00-00',
`dn_from_email` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `user_email` (`user_email`),
KEY `NotifyIndex` (`want_notify`),
KEY `dateofdown` (`dateofdown`),
KEY `products` (`products` )
) TYPE=MyISAM;
Whenever a user downloads a trial version I keep his
info in the table. I also send a mail to the user with
the download instrcutions. When the user clicks on the
link - i increment dn_from_email by one to know that
he actually downloaded the app by cliciking on the
link.
I get report for my downloads by executing multiple
queries like:
SELECT dayofmonth(dateofdown),
COUNT(IF(products=a,1,NULL)),
COUNT(IF(products=b,1,NULL)),
COUNT(IF(products=c,1,NULL)) from user_details where
month(dateofdown) = month(curdate()) and
year(dateofdown) = year(curdate()) group by 1;
SELECT dayofmonth(dateofdown),
COUNT(IF(products=a,1,NULL)),
COUNT(IF(products=b,1,NULL)),
COUNT(IF(products=c,1,NULL)) from user_details where
dn_from_email 0 and month(dateofdown) =
month(curdate()) and year(dateofdown) =
year(curdate()) group by 1;
Is this method optimized enough?
Also, if for some day dn_from_email = 0 for all the
products then the report goes awry as the number of
rows returned from first query != number of queries
returned from second query.
Am I on the correct path?
Regards,
Karam
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lost connection during query when using SSH tunneling
Hello, I have a MySQL database hosted with my ISP. They provide direction as well as thru SSH tunneling. I can very well connect to it diredctly from any app but I prefer to use SSH tunneling. So I use Putty to create the SSH tunneler and then connecting to the local port. Now the problem, is that whenever I execute a long query or something that returns big resultset, i get an error - Lost connection during query. If I use direct connection - everythings fine. Is this a known issue? Is this a bug with Putty? Regards, Karam __ Do you Yahoo!? Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection during query when using SSH tunneling
I am not sure of Putty as I am using plink.exe that is the SSH tunneler for tunnel. The thing is that I call up plink.exe from my app to create an ssh tunnel and then set the correct values for mysql_real_connect() in my app. What I am doing is that I am bundling plink.exe with my app and then ask the user for SSH info. Depending upon that I create a plink.exe process and then connect my app to the SSH process. I referred to Putty as many people seem to be using it and putty usese plink.exe which is the back end for it. Should I look into some options like what you suggested? Regards, Karam --- Adams, Pat 006 [EMAIL PROTECTED] wrote: -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Lost connection during query when using SSH tunneling So I use Putty to create the SSH tunneler and then connecting to the local port. Now the problem, is that whenever I execute a long query or something that returns big resultset, i get an error - Lost connection during query. If I use direct connection - everythings fine. Putty has an option in the Connection category of the configuration for Seconds between keepalives. It's set to zero (off) by default. If you set it to 0 number, putty will send a null packet at the server to try and keep the connection alive. Have you tried that? -- Pat Adams Applications Programmer SYSCO Food Services of Dallas, L.P. (469) 384-6009 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Jazz up your holiday email with celebrity designs. Learn more. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlcc
MySQL CC seems to be discontinued. Nowadays I prefer SQLyog (http://www.webyog.com) Karam --- Robin Lynn Frank [EMAIL PROTECTED] wrote: I'm obviously missing something. I can use mysqlcc to change data in a row of a table and save it. But, if I try to insert a row, add data and save it, it never gets saved. What am I overlooking? -- /\ ASCII RIBBON Robin Lynn Frank \ / CAMPAIGN Director of Operations X AGAINST Paradigm-Omega, LLC / \ HTML MAILhttp://www.paradigm-omega.com/ = Spambots visit http://paradigm-omega.net/cgi-bin/custmail.cgi = Don't mind me. I am having a bad (day|week|month|year). ATTACHMENT part 2 application/pgp-signature name=signature.asc __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Static library for MySQL C API
Thanks. We haev to compile it with mysqlclient.lib I just the binary distribution of MySQL 4.1.7 for Windows. The size of mysqlclient.lib is 1.5MB whereas libmysql.dll is 1.04MB and libmysql.lib is around 33K. Why is the difference in size? Regards, Karam --- Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. See: http://dev.mysql.com/doc/mysql/en/Windows_client_compiling.html Karam Chand [EMAIL PROTECTED] wrote: Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Static library for MySQL C API
Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql admin clients
Hello, Check out SQLyog at http://www.webyog.com/forums/index.php?s=94f4afb247fdfdfbd6435d793a56d60aact=STf=2t=977st=0#entry3909 Its FREE and very powerful. Regards, Karam --- leegold [EMAIL PROTECTED] wrote: newbie question about mysql admin clients. What are some good ones? And importantly can they access and allow me to edit the db record fields themselves? eg. I see a mis-spelled word in a field - I could go in there and edit the field. Thanks, lee G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Works with MySQL Logo
Hello, I searched MySQL.com but couldnt find the official Works With MySQL logo. Can somebody point me to the right direction. If they can send it to me as an attachment, will be helpful. Regards, Karam __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Works with MySQL Logo
I had checked google before posting. As you can see none of the images are original and the clarity is not good. They dont look good in my app. Can I get an original one from MySQL AB? Regards, Karam --- Aman Raheja [EMAIL PROTECTED] wrote: http://images.google.com/images?hl=enlr=q=%22Works+With+MySQL%22btnG=Search Aman Raheja Karam Chand wrote: Hello, I searched MySQL.com but couldnt find the official Works With MySQL logo. Can somebody point me to the right direction. If they can send it to me as an attachment, will be helpful. Regards, Karam __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: synchronizing mysql database in two diferrent places
Hello, You might try MySQL's inbuilt replication feature. If you want a more simple approach, might take a look at SQLyog's Data Sync Wizard. More information can be found at http://www.webyog.com I think they have a article on the same subject in SitePoint. You might google it. Karam --- Eko Budiharto [EMAIL PROTECTED] wrote: Hi, I a facing a situation where I have two database server in two different places that has exactly the same database. The thing is if the database is modified in either one of the places, both database has to be updated lively. Can someone tell me who done this already? Please help. I am looking forward to a favorable reply from you. Thank you. __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Should I change the MySQL client library
Hello, MySQL has released 4.1.7 http://lists.mysql.com/announce/226 As you can see there have been some bugfixes in libmysqlclient. I am using libmysql.dll provided with 4.1.1 in my app. Do I need to upgrade it to the one provided with 4.1.7? Regards, Karam __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Result returned by LOAD LOCAL...
Hello, When I execute a LOAD DATA INFILE statment.. mySQL returns a result with info like: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 How can I get more information about deletions, warnings etc? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transfering data from postgresql to MySQL
Hello, You can use SQLyog's ODBC Import Tool to import data from PgSQL to MySQL using PgSQL's ODBC driver. More information about SQLyog can be found at http://www.webyog.com Karam --- Jochem van Dieten [EMAIL PROTECTED] wrote: On Mon, 18 Oct 2004 18:08:24 +0800, 謝洪恩 Patrick Hsieh wrote: I am planing to transfer data from postgresql to mysql. Is there any useful tools, scripts or utilities to achieve this? pg_dump First dump the schema, edit that until you have something MySQL understands. Then dump the data using the -d option so you have full inserts instead of the usual COPY syntax and feed the file to the MySQL command line client. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create table....select * from table anomaly..
Hello, I have three databases 3.23.54 (production) 4.0.18 and 4.1.3 as test servers. I execute the following sqls: create database testdb; use testdb; CREATE TABLE `test` ( `example_col` varchar(100) default NULL ) TYPE=MyISAM; create table `test_copy` type=MyISAM select `example_col` from `test` where 1 = 0; In 3.23.54, the example_col of test_copy gets converted to char(100) whereas it remains same in i.e. varchar (which I want) in 4.0.18 and 4.1.1. Is it a known issue or it was a bug with 3.23.54 that has been solved? Regards, Karam ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best way to access field name in C
Hello,
In C you dont have named access to the columns as they
are returned as an array of char*. The only solution
would be to access it using its index value.
Like PHP, you have to do mysql_fetch_row() anyway.
After that access the row by its index.
If you prefer named access and dont mind a minute
perdformance hit, then you can write your own function
that takes FIELD_RES* structure and the name of the
column. The function then loops thru each colum name
and if found returns the char*.
But do keep in mind that the pointer for the currenly
FIELD structure changes in this way.
HTH
Karam
--- Matthew Boehm [EMAIL PROTECTED] wrote:
What is the best way to access a specific field in
C? Its really easy in
PHP...
PHP
---
$res = mysql_real_query($mysql,SELECT col1, col2
FROM table);
while($row = mysql_fetch_row($res)) {
print $row['col1'];
print $row['col2'];
}
Is the only way/best way to do the above in C by
using a nested for-loop?
Ex:
fields = mysql_fetch_fields(res);
while((row=mysql_fetch_row(res)) {
for(x=0;xnumFields;x++) {
sprintf(output, Column name: %s Column
Value: %s\n,
fields[x].name, row[x]);
}
}
Seems painful and extra-loopy to do it in C. Is
there a better way?
Thanks,
Matthew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Probably you should put it as a bug in SQLyogs forums. Karam --- Jose_Miguel_Pérez [EMAIL PROTECTED] wrote: Karam Chand said: I use SQLyog. It does allow you to create/delete FKs with ON UPDATE criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Yeah, I also tried SQLyog. It's a very good program indeed, a very nice feature is the structure syncronization tool. However, I said every program I tried has problems, and SQLyog is no exception. I downloaded SQLyog v3.71, I'm using MySQL 4.1.4-gamma-standard. When I manage relationships (F10 key), the FK's not even show up on the list... If I now press New.. to create a relationship, I can fill in the blanks and press Create, however SQLyog didn't show the new relationship either. I ended up creating 5 (five) equal relationships since SQLyog wasn't showing them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable to me. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
I use SQLyog. It does allow you to create/delete FKs with ON UPDATE criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Karam --- Jose_Miguel_Pérez [EMAIL PROTECTED] wrote: Hi All! Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem annoyed, but I have used for quite some time a few GUI clients, notably MySQL-Front, which I were relatively confortable with. Anyway, all GUI clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be some sort of shortcut to the MySQL command line. No problem with that, that's what I am looking for and not some high-level CASE tool. It's when looking for foreign keys and referential integrity where these tools fail miserably. None of them fully supports editing / creating / deleting foreign keys. If you are to reply to this message, please read again the FULLY supports statement. For example, with version 1.0.7-beta of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an ON UPDATE constraint... silly, huh? This is not a strange Fails when lib-foo v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night error, it's simply that the programmer (nor the bug-testing labs) have not tried the On Update: drop-down menu from the edit table dialog. I know foreign keys are a relatively new area in the MySQL field and maybe the programmers are slowly adding support for it, but it's quite annoying to see monumental bugs editing and changing foreign keys in ALL programs I've tried. Please, note that this message is not intended to flame anyone. I fully aknowledge the effort involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration tools/plan from oracle 7.3 to Mysql 4.0
Give a look to SQLyogs ODBC Import Tool. It can be found at http://www.webyog.com Regards, Karam --- [EMAIL PROTECTED] wrote: Hi, I have to migrate oracle 7.3 database to MySql , for oracle used Pro*C. In the front end used Java, JNI, RMI and Pro*C. In the migration process what will be the best equivalent of Pro*C in MySql. Ans also need to use XML, for the above environment what are the best langauge suit for XML handling( c++ or java) and what will be the best parsers for XML (like jaxp ..etc). Please advise me here. Thanks, Narasimha 91 98456 82459 -Original Message- From: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER) Sent: Tue 8/17/2004 3:08 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Subject: RE: Migration tools/plan from oracle 7.3 to Mysql 4.0 Hi, Thank you for your response. Could any one give more clarification on the alternatives for Views, Stored procedures, triggers and contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot support the InnoDB storage engine. Thanks, Narasimha -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tue 8/17/2004 12:59 PM To: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER); [EMAIL PROTECTED] Cc: Subject: Re: Migration tools/plan from oracle 7.3 to Mysql 4.0 First: please don't hijack threads... And don't quote them completely if you do. I am new to MySql. Could you please let me know the different migration tools avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. You could try the Schema Migrator tool in Database Workbench ( www.upscene.com ) - it supports ADO and ODBC connectivity to MySQL. Might not be perfect, but sure gives you a good start. Out of those which one is the best in performance and cost wise. As per my knowledge views, stored procedures and triggers are not supported in MySql 4.0. Is it correct?. That is correct. Add to that: no CHECK constraints either. Foreign Key Constraints and transactions are only supported with the InnoDB storage engine - read about that in the documentation. If so, what are all the alternatives for converting the views, stored procedures and triggers in oracle 7.3 to MySql 4.0. I will be very happy for giving me a very good explanation on this. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sql2000 to mysql
You can try SQLyog's ODBC Import feature. SQLyog can be found at http://www.webyog.com Regards Karam --- Tim Winters [EMAIL PROTECTED] wrote: Hi Victor, Just Tables and Data. Ideally scripted to create the tables and insert the data. will sql2000 product something similer to a .sql file which can simple be run as a script? Thx At 12:45 PM 24/08/2004, Victor Pendleton wrote: Are you wanting to move Foreign keys, Triggers, Stored procedures and the like as well or just the data? -Original Message- From: Tim Winters To: [EMAIL PROTECTED] Sent: 8/24/04 10:36 AM Subject: sql2000 to mysql Hello, Can someone advise me of the best/easiest way to move an entire DB (Tables and data) from sql2000 (my client) to mySQL (my System)? I need to advise someone on how I wish the data sent to me. Any help would be appreciated. Thanks, Tim -- 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] ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good MySQL database manager for newbies?
Take a look at SQLyog ( http://www.webyog.com ) Karam --- [EMAIL PROTECTED] wrote: I posted this a little while ago, but it faded out with very few responses due to my not posting the necessary information, so I seek to rectify my err now. Info: OS: Windows XP PHP: 5 Use: I'm looking for something that can easily create and manage databases, doing stuff like creating and editing tables. Something simple for newbies like me not seeking to do really complicated things. There that should be better. ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is the best MySQL manager?
I have been using SQLyog at http://www.webyog.com for quite some time. Karam --- [EMAIL PROTECTED] wrote: see topic. Ex: mysqlgui.exe, phpmyadmin, etc. I can't get phpmyadmin to work...but that's a different topic. ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Escaped BLOB data in XML
Hello, i have a table with a LONGBLOB column. We store some small images in it. I want to export them in XML format with schema like: cdata/c cdata/c ... ... Now the problem is even if I mysql_real_escape() and changing entities like , to lt; gt; the data some of the characters are of ascii value 12,13 etc. None of the XML parsers are able to recognise it and they throw up error? I googled but couldnt find a refernce on how to handle such characters in XML. Any pointersI am using Expat as my apps XML parser. Regards, Karam __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GUI for MySQL
Hello, You can try SQLyog at http://www.webyog.com/ . Its not free but it has got some really powerful features. Regards, Karam --- Kirti S. Bajwa [EMAIL PROTECTED] wrote: This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Escaped BLOB data in XML
Hello, Hmmm. I was figuring that out. mysql_escape_string() only escapes characters like \r, \n, \\, 0 etc. it still keep other non-character data same like it keep ascii 15 to ascii 15 that no parser is able to handle. Isnt there any better way then base64 to handle this. Just like replacin to lt; solves the problem in the data? Regards, Karam --- Keith Ivey [EMAIL PROTECTED] wrote: Karam Chand wrote: i have a table with a LONGBLOB column. We store some small images in it. I want to export them in XML format with schema like: cdata/c cdata/c ... ... Now the problem is even if I mysql_real_escape() and changing entities like , to lt; gt; the data some of the characters are of ascii value 12,13 etc. None of the XML parsers are able to recognise it and they throw up error? I googled but couldnt find a refernce on how to handle such characters in XML. This doesn't have anything to do with MySQL. XML isn't really designed for directly containing binary data, so people generally use Base64 encoding (or occasionally some other method of encoding binary data in ASCII). The XML parser isn't going to be able to return the raw binary data -- you'll have to decode it. -- Keith Ivey [EMAIL PROTECTED] Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Escaped BLOB data in XML
This leads me to another question. What are the valid ASCII characters that XML parser understands. Are they only a-1,A-Z,0-9,., etc or some other characters. Regards, Karam --- Karam Chand [EMAIL PROTECTED] wrote: Hello, Hmmm. I was figuring that out. mysql_escape_string() only escapes characters like \r, \n, \\, 0 etc. it still keep other non-character data same like it keep ascii 15 to ascii 15 that no parser is able to handle. Isnt there any better way then base64 to handle this. Just like replacin to lt; solves the problem in the data? Regards, Karam --- Keith Ivey [EMAIL PROTECTED] wrote: Karam Chand wrote: i have a table with a LONGBLOB column. We store some small images in it. I want to export them in XML format with schema like: cdata/c cdata/c ... ... Now the problem is even if I mysql_real_escape() and changing entities like , to lt; gt; the data some of the characters are of ascii value 12,13 etc. None of the XML parsers are able to recognise it and they throw up error? I googled but couldnt find a refernce on how to handle such characters in XML. This doesn't have anything to do with MySQL. XML isn't really designed for directly containing binary data, so people generally use Base64 encoding (or occasionally some other method of encoding binary data in ASCII). The XML parser isn't going to be able to return the raw binary data -- you'll have to decode it. -- Keith Ivey [EMAIL PROTECTED] Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
Probably I was late in replying (just busy with some stupid work). In all the API if you dont specify the dbname in the mysql_connect() functions. In C the connection function is mysql_real_connect(), in PHP its mysql_pconnect(), donno about other APIs. You can get a list of dbs by issueing show databases SQL. One thing you have to make sure is that you have the permission :) regards, karam --- Michael Seele [EMAIL PROTECTED] wrote: oh! sorry! i use java! [EMAIL PROTECTED] schrieb am 09.08.2004 14:33: Not which natural language, which programming language? We need to know in order to help you. C, C++, Java, Perl, PHP, Python... The answer will differ. Alec Michael Seele [EMAIL PROTECTED] 09/08/2004 13:20 To [EMAIL PROTECTED] cc Subject Re: connect to mySQL without database i use mySQL english version! why? Karam Chand schrieb am 09.08.2004 14:13: Yes. Which language you are using? Regards, Karam --- Michael Seele [EMAIL PROTECTED] wrote: hi, is it possible to connect to a mySQL-Server without entering a database and then check all available databases? thx mseele -- G H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- G H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mySQL without database
Yes. Which language you are using? Regards, Karam --- Michael Seele [EMAIL PROTECTED] wrote: hi, is it possible to connect to a mySQL-Server without entering a database and then check all available databases? thx mseele -- G H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-software.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Front-end for beginner trying to learn mysql
I always preferred SQLyog at http://www.webyog.com Karam --- Scott Hamm [EMAIL PROTECTED] wrote: To all, Is there any simplest front-end for beginner like me to learn how mysql run? I am intensive in html code and currently learning ASP. Is there anything else that I need to complete transactions between mysql and front-end application? Thanks in advance, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slight confusion about mysql_fetch_length() API - Internals
Hello, Probably this mail should go to the internals list :) I was looking into MySQL Client libaray and I could figure out the DATA are kept as linked list of MYSQL_ROW structure i.e. in MYSQL_ROWS being one node. Now MYSQL_ROW is typedefed as char** that is array of strings. Looking into the mysql_fetch_lengths() API code, the lengths are calculated from the offset between pointers. Forgive my C knowledge, but I was unable to understand how we are calculating thru offset. As far as I can understand this is what is happening: A MYSQL_ROW is allocated with field_count number of indexes. Each index is then again my_alloced() to store information about each each and so on. i.e. myrow = malloc ( sizeof (char*), field_count ); myrow[0] = malloc ( sizeof(char), field_data ); myrow[1] = malloc ( sizeof(char), field_data ); myrow[2] = malloc ( sizeof(char), field_data ); In this case how can we calculate lengths using offsets? Or I am missing something very stupid. A little clarity will do hell lot of good to me :) Any pointers... Regards Karam __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing Mysql using API's
I dont think so, but I might be wrong. I belive in your case u have to write a custom app that listens on port 3306 and checks for every data transfer. Karam --- Sheraz [EMAIL PROTECTED] wrote: Hello I need to access the mysql's connection handling ,, are there any exposed API's that can allow me to see what is being received on 3306 for serverand can i hold that data for some checks so that if my check goes perfrect ill let allow that data to pass on to server for further request ? Your help will be appriciated Thanks Sheraz __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL/PHP Tunneling
Hello, Recently lot of MySQL clients try to overcome host based privilege system of MySQL by using PHP tunneling method. In this method they call up a PHP file in the server and the PHP file executes a query and sends the data in XML format. I am using C API() and I was just wondering if somebody is working on such tunnels i.e. a PHP file and its corresponding C/++ code that will fill up MYSQL_RES structures correctly so that I can use them to C API() without any problem. Otherwise, i guess i have to write one for myself. Regards, Karam __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP/MySQL Tunneling
Hello, Recently lot of MySQL clients try to overcome host based privilege system of MySQL by using PHP tunneling method. In this method they call up a PHP file in the server and the PHP file executes a query and sends the data in XML format. I am using C API() and I was just wondering if somebody is working on such tunnels i.e. a PHP file and its corresponding C/++ code that will fill up MYSQL_RES structures correctly so that I can use them to C API() without any problem. Otherwise, i guess i have to write one for myself. Regards, Karam __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ` around object names?
Hello, That is what Paul Dubois book says but one of my customers running 3.23.27-beta-log the following query does not work: select * from `db`.`table`; but the following query works like cheese: select * from db.table; regards karam --- Egor Egorov [EMAIL PROTECTED] wrote: Karam Chand [EMAIL PROTECTED] wrote: Can somebody tell me the exact version from when ` around object names were allowed? It was introduced in version 3.23.6. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
` around object names?
Hello, Can somebody tell me the exact version from when ` around object names were allowed? Thanks in advance. Regards, Karam __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Usage of ` in objects?
Hello, Can somebody tell me the exact version of MySQL ( i think its one the 3.23.x series) from which ` around objects were allowed. Karam __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Webyog releases SQLyog 3.71 SJA 2.0
Webyog has released SQLyog 3.71 SQLyog Job Agent ( SJA ) v2.0 Some of the major features added in SQLyog 3.71 are - -- SQLyog Notification Services - This new feature allows delivery of formatted resultset(s) over email at scheduled intervals. -- SQLyog Database Synchronization Tool now supports 2-way synchronization. -- Now you can execute SJA jobs from SQLyog using Tools - Job Manager. -- Improved Online Help. -- Fully compatible with MySQL versions 3.23.58 to 5.x. You can download a full featured Trial version of SQLyog at http://www.webyog.com/sqlyog/download.html Regards, Karam __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Increase in size of 4.1.2 binary
Hello, The windows binary of 4.1.1 was around 20 MB. With 4.1.2 it has increased to 34 MB. Thats a big jump ? Karam __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Converting a different database to mysql
Hello, If the db has an ODBC driver then you can try SQLyog from www.webyog.com Karam --- Glenn McCord [EMAIL PROTECTED] wrote: Gidday. Is there anyway to convert an Advanced Revelations/Open Insight database into a mySQL database. Cheers, Glenn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC - SQLColAttribute with SQL_DESC_OCTET_LENGTH parameter
Hello, In my application, I am connecting to various RBDMS but primarily SQL Server and MySQL using ODBC 3.0 driver. In SQL Server, if I execute SQLCollAtrribute with SQL_DESC_OCTET_LENGTH, it is returning me the maximum number of bytes that the column can have irrespective of whether the column in the resultset has that much data or not. Whereas, the MySQL ODBC driver is returning the maximum data that a column has for that particular resultset. Why is the anomaly? Does this information differ from driver to driver. Is there any way to know the size of a perticular row in raw-bytes before doing an SQLFetch(). I would like to allocate the memory before I do SQLFetch(). Looking into Google Groups it seems that many people have the same problem but not much solution has been provided. What is the best way to know how much bytes the RDBMS takes in the disk to store that much information? __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant run MySQL embedded server
Hello,
I successfully compiled MySQL embedded library from
source. It resulted in libmysqld.dll and libmysqld.lib
created in lib_debug directory.
Compiling my test application after linking it with
libmysqld.lib and using libmysqld.dll it is never
going past mysql_server_init.
If I debug it by pressing F5, as soon as it reached
the function it exists saying:
User breakpoint called from 0xxx
If I remove the breakpoint then it just
exits...without doing anything. I created the test app
as shown in docs:
#include winsock.h
#include mysql.h
#include stdarg.h
#include stdio.h
#include stdlib.h
MYSQL *db_connect(const char *dbname);
void db_disconnect(MYSQL *db);
void db_do_query(MYSQL *db, const char *query);
static char *server_args[] = {
test, /* this string is not used */
--datadir=.,
--key_buffer_size=32M
};
static char *server_groups[] = {
embedded,
server,
test_SERVER,
(char *)NULL
};
int
main(int argc, char **argv)
{
MYSQL *one, *two;
if (mysql_server_init(sizeof(server_args) /
sizeof(char *), server_args, server_groups))
exit(1);
one = db_connect(test);
two = db_connect(NULL);
db_do_query(one, SHOW TABLE STATUS);
db_do_query(two, SHOW DATABASES);
mysql_close(two);
mysql_close(one);
This must be called after all other mysql functions
mysql_server_end();
exit(EXIT_SUCCESS);
}
My my.ini located in c:\windows\ has the following
value:
[embedded]
datadir=g:/my4015/data
Do I need to add anything extra?
There exists a data directory and there is a test
table. Actually this is the sample data directory
created by MySQL 4.0.18 binary.
What am I doing wrong? Or I am getting the embeddeble
library completely wrong...
Karam
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant compile embedded mysql server in Windows
Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... libmysqld.def : error LNK2001: unresolved external symbol max_allowed_packet libmysqld.def : error LNK2001: unresolved external symbol myodbc_remove_escape libmysqld.def : error LNK2001: unresolved external symbol mysql_affected_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_autocommit libmysqld.def : error LNK2001: unresolved external symbol mysql_change_user libmysqld.def : error LNK2001: unresolved external symbol mysql_character_set_name libmysqld.def : error LNK2001: unresolved external symbol mysql_close libmysqld.def : error LNK2001: unresolved external symbol mysql_commit libmysqld.def : error LNK2001: unresolved external symbol mysql_data_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_debug libmysqld.def : error LNK2001: unresolved external symbol mysql_dump_debug_info libmysqld.def : error LNK2001: unresolved external symbol mysql_eof libmysqld.def : error LNK2001: unresolved external symbol mysql_errno libmysqld.def : error LNK2001: unresolved external symbol mysql_error libmysqld.def : error LNK2001: unresolved external symbol mysql_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field_direct libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_lengths libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_row libmysqld.def : error LNK2001: unresolved external symbol mysql_field_count libmysqld.def : error LNK2001: unresolved external symbol mysql_field_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_field_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_free_result libmysqld.def : error LNK2001: unresolved external symbol mysql_get_client_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_host_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_proto_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_version libmysqld.def : error LNK2001: unresolved external symbol mysql_info libmysqld.def : error LNK2001: unresolved external symbol mysql_init libmysqld.def : error LNK2001: unresolved external symbol mysql_insert_id libmysqld.def : error LNK2001: unresolved external symbol mysql_kill libmysqld.def : error LNK2001: unresolved external symbol mysql_list_dbs libmysqld.def : error LNK2001: unresolved external symbol mysql_list_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_list_processes libmysqld.def : error LNK2001: unresolved external symbol mysql_list_tables libmysqld.def : error LNK2001: unresolved external symbol mysql_more_results libmysqld.def : error LNK2001: unresolved external symbol mysql_next_result libmysqld.def : error LNK2001: unresolved external symbol mysql_num_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_num_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_odbc_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_options libmysqld.def : error LNK2001: unresolved external symbol mysql_ping libmysqld.def : error LNK2001: unresolved external symbol mysql_query libmysqld.def : error LNK2001: unresolved external symbol mysql_read_query_result libmysqld.def : error LNK2001: unresolved external symbol mysql_real_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_real_query libmysqld.def : error LNK2001: unresolved external symbol mysql_refresh libmysqld.def : error LNK2001: unresolved external symbol mysql_rollback libmysqld.def : error LNK2001: unresolved external symbol mysql_row_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_row_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_select_db libmysqld.def : error LNK2001: unresolved external symbol mysql_send_query libmysqld.def : error LNK2001: unresolved external symbol mysql_server_end libmysqld.def : error LNK2001: unresolved external symbol mysql_server_init libmysqld.def : error LNK2001: unresolved external symbol mysql_shutdown libmysqld.def : error LNK2001: unresolved external symbol mysql_sqlstate libmysqld.def : error LNK2001: unresolved external symbol mysql_ssl_set libmysqld.def : error LNK2001: unresolved external symbol mysql_stat libmysqld.def : error LNK2001: unresolved external symbol mysql_store_result libmysqld.def : error LNK2001: unresolved external symbol mysql_thread_id libmysqld.def :
Re: Cant compile embedded mysql server in Windows
Hello, I want a debuggable compiled library. Is Deug version of embedded server available. Karam --- Victor Medina [EMAIL PROTECTED] wrote: Karam Chand wrote: Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... ---8 You can download the .zip (precompiled) file from mysql.com and save a lot of time. Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
Since you have used SQLyog, I will say you contact the SQLyog people about this. Karam --- Joshua J. Kugler [EMAIL PROTECTED] wrote: You can't? How are you trying to display? What are you using? A CGI script? A database utility? Something else? We need a bit more information to answer the question. j- k- On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: Hello list, Recently I've been in the job of migrating a large (about 1.5GB) database build in MSSQL Server to MYSQL. The migration was done OK, I used the SQLYog utility to do this. The problem is that one table has image column types ... I tried to view this column types (blob data types now) but I can't in the MYSQL migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQLyog with Notification Services
Hello, Just found out that Webyog has released a RC of the latest version of SQLyog. It includes Notification Services that allows you to send formatted resultsets over email. Find more information at http://www.webyog.com/forums/index.php?s=26b105e857a24ec61d9fb5138f17070bact=STf=2t=766st=0#entry2733 Regards Karam __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0 - What is really available?
Hello, I prefer SQLyog. www.webyog.com Karam --- Martijn Tonies [EMAIL PROTECTED] wrote: Hi Mike, I've downloaded and installed 5.0, it seems to be working fine. However, I need a graphical user interface to create tables and such (when I say I need, trust me, I need). I'm running on XP (that explains a lot I know) So: Is Control Center for 5.0 available? Is MyODBC 5.0 available? You might want to give Database Workbench a try - although it currently supports MySQL 4 and 4.1, it works fine with 5.0 - except for the Stored Procedures/Functions support, which will be added soon. Download a trial at www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
