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: 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: 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: 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]
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]
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]
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]
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]
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]
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]
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]
Re: migrate Access to MySQL
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=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?
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: > 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
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]
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]
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: 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: 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: 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: > 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 thi
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]
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: 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]
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]
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#= > 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]
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: 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]
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
> "free"ing 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 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#= > 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]
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]
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]
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]
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]
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]
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: 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]
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: 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=94f4afb247fdfdfbd6435d793a56d60a&act=ST&f=2&t=977&st=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]
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=en&lr=&q=%22Works+With+MySQL%22&btnG=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]
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: 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;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]
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 < 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: > > > > > >data > > >data > > >... > > >... > > > > > >Now the problem is even if I mysql_real_escape() > > and > > >changing entities like <,> to < & > 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: 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 < 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: > > > >data > >data > >... > >... > > > >Now the problem is even if I mysql_real_escape() > and > >changing entities like <,> to < & > 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: 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]
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: data data ... ... Now the problem is even if I mysql_real_escape() and changing entities like <,> to < & > 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: 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
#include
#include
#include
#include
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]
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]
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]
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 :
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=26b105e857a24ec61d9fb5138f17070b&act=ST&f=2&t=766&st=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]
