Re: SSH tunnel for Mysql

2005-12-08 Thread Karam Chand
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!

Table design question

2005-11-02 Thread Karam Chand
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 pla

Re: converting access (.mdb) files...

2005-09-18 Thread Karam Chand
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

RE: Mysql to Oracle migration

2005-09-05 Thread Karam Chand
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 ora

Re: Migrating MySQL users

2005-09-05 Thread Karam Chand
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 kee

Re: Data sync offline

2005-08-24 Thread Karam Chand
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 >

Error no: 12 (

2005-08-11 Thread Karam Chand
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 a

RE: [SPAM?]: Case issue in Information_schema

2005-08-10 Thread Karam Chand
ROM > 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 >

Re: mysql 5.0.10 compilation error

2005-08-10 Thread Karam Chand
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

mysql 5.0.10 compilation error

2005-08-10 Thread Karam Chand
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 V

MYSQLDUMP and Triggers, Functions and SP

2005-08-10 Thread Karam Chand
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 Gen

Case issue in Information_schema

2005-08-10 Thread Karam Chand
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

DROP VIEW Syntax

2005-08-05 Thread Karam Chand
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

ALTER TRIGGER in MySQL

2005-08-04 Thread Karam Chand
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 ___

Re: migrate Access to MySQL

2005-07-31 Thread Karam Chand
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 > ar

Re: SQLyog Enterprise

2005-07-20 Thread Karam Chand
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 perso

Re: simple data GUI editor?

2005-06-18 Thread Karam Chand
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, M

Re: simple data GUI editor?

2005-06-18 Thread Karam Chand
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

Re: Migrating from IBM Universe to mySQL

2005-06-14 Thread Karam Chand
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 databa

Re: Mysql Backup/Dump

2005-06-14 Thread Karam Chand
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 insta

Re: Export from Access

2005-05-18 Thread Karam Chand
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

Re: Restoring mySQL dump

2005-05-18 Thread Karam Chand
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

RE: Work / Home DB synchronization

2005-05-06 Thread Karam Chand
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 /

Re: How to export a table to a CSV file?

2005-05-05 Thread Karam Chand
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 > inc

Re: How to backup and restore database

2005-05-05 Thread Karam Chand
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]> wro

Re: Work / Home DB synchronization

2005-05-05 Thread Karam Chand
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 work

Re: C API: Storing is easy; How do you retrieve?

2005-05-01 Thread Karam Chand
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, >

Re: backup databases one to another

2005-04-13 Thread Karam Chand
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 su

Re: Need help coverting MDB > SQL

2005-03-27 Thread Karam Chand
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 s

Re: How to import data from Dbase3?

2005-03-23 Thread Karam Chand
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 dire

Re: MySQL and phpMyAdmin

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

Re: Remote Connection via Toad for MySQL

2005-02-25 Thread Karam Chand
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 vers

Re: How to send queries to a database periodically

2005-02-24 Thread Karam Chand
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

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
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 nittygrittie

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
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/

List of connection error

2005-02-02 Thread Karam Chand
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 Mai

Re: MySQL win32 and SSL

2005-01-25 Thread Karam Chand
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

RE: Serious bug (or my foolishness) with alter table and InnoDB

2005-01-25 Thread Karam Chand
e`), > CONSTRAINT `child_ibfk_1` FOREIGN KEY (`id`) > REFERENCES `master` (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | > +---+---- > - > > > -Original Message- > > From: Karam Chand [mailto

Re: Serious bug (or my foolishness) with alter table and InnoDB

2005-01-25 Thread Karam Chand
es > > 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 > assu

Re: Serious bug (or my foolishness) with alter table and InnoDB

2005-01-25 Thread Karam Chand
e 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` ( > >

Serious bug (or my foolishness) with alter table and InnoDB

2005-01-25 Thread Karam Chand
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`)

RE: Where can I download The MySQL C API??

2005-01-25 Thread Karam Chand
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:

Re: Importing data from MS Access

2005-01-11 Thread Karam Chand
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 Acces

Re: ALTER TABLE....with CHANGE syntax

2005-01-11 Thread Karam Chand
eck 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 >

ALTER TABLE....with CHANGE syntax

2005-01-11 Thread Karam Chand
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 --

Re: mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Karam Chand
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. > > > >

Re: mysql_use_result issue: useless iterating over unused results

2005-01-11 Thread Karam Chand
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_us

Re: mySQL C++ API (which libraries)

2005-01-11 Thread Karam Chand
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 --- An

ALTER TABLE....with CHANGE syntax

2005-01-10 Thread Karam Chand
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 th

FK Id in Innodb

2005-01-10 Thread Karam Chand
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 Inn

Re: FLUSH syntax query

2005-01-06 Thread Karam Chand
> > 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.htm

Re: MySQL insert with PHPMyAdmin

2005-01-06 Thread Karam Chand
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

FLUSH syntax query

2005-01-05 Thread Karam Chand
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 Yo

Re: MySQL Query Browser

2004-12-15 Thread Karam Chand
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, 9

Re: Mysql client that does export and import

2004-12-14 Thread Karam Chand
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 c

Getting monthly download report

2004-12-13 Thread Karam Chand
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', `pro

Re: mysqlcc

2004-12-10 Thread Karam Chand
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

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Karam Chand
, 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 q

Lost connection during query when using SSH tunneling

2004-12-10 Thread Karam Chand
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 th

Re: Static library for MySQL C API

2004-11-18 Thread Karam Chand
TED]> 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() &g

Static library for MySQL C API

2004-11-17 Thread Karam Chand
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:

Re: mysql admin clients

2004-11-05 Thread Karam Chand
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 >

Re: Works with MySQL Logo

2004-11-02 Thread Karam Chand
=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 d

Works with MySQL Logo

2004-11-02 Thread Karam Chand
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 Ya

Re: synchronizing mysql database in two diferrent places

2004-10-31 Thread Karam Chand
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

Should I change the MySQL client library

2004-10-27 Thread Karam Chand
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 _

Result returned by LOAD LOCAL...

2004-10-25 Thread Karam Chand
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!

Re: Transfering data from postgresql to MySQL

2004-10-18 Thread Karam Chand
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:

create table....select * from table anomaly..

2004-10-15 Thread Karam Chand
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

Re: Best way to access field name in C

2004-10-11 Thread Karam Chand
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 mi

Re: In search of a good MySQL GUI client

2004-09-09 Thread Karam Chand
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, i

Re: In search of a good MySQL GUI client

2004-09-08 Thread Karam Chand
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! >

RE: Migration tools/plan from oracle 7.3 to Mysql 4.0

2004-08-25 Thread Karam Chand
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 proce

RE: sql2000 to mysql

2004-08-24 Thread Karam Chand
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

Re: What is a good MySQL database manager for newbies?

2004-08-20 Thread Karam Chand
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

Re: What is the best MySQL manager?

2004-08-19 Thread Karam Chand
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!

Re: Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
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_

Re: Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
< 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 > >forma

Re: GUI for MySQL

2004-08-12 Thread Karam Chand
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 i

Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
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,1

Re: connect to mySQL without database

2004-08-10 Thread Karam Chand
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: &g

Re: connect to mySQL without database

2004-08-09 Thread Karam Chand
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)74

Re: Front-end for beginner trying to learn mysql

2004-08-05 Thread Karam Chand
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 anythi

Slight confusion about mysql_fetch_length() API - Internals

2004-07-14 Thread Karam Chand
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

Re: Accessing Mysql using API's

2004-07-11 Thread Karam Chand
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 tha

MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
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 somebo

PHP/MySQL Tunneling

2004-07-09 Thread Karam Chand
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 somebo

Re: ` around object names?

2004-06-16 Thread Karam Chand
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]>

` around object names?

2004-06-15 Thread Karam Chand
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 G

Usage of ` in objects?

2004-06-14 Thread Karam Chand
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/

Webyog releases SQLyog 3.71 & SJA 2.0

2004-06-09 Thread Karam Chand
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 suppor

Increase in size of 4.1.2 binary

2004-06-05 Thread Karam Chand
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 Maili

Re: Converting a different database to mysql

2004-06-02 Thread Karam Chand
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 Li

MyODBC - SQLColAttribute with SQL_DESC_OCTET_LENGTH parameter

2004-05-30 Thread Karam Chand
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 i

Cant run MySQL embedded server

2004-04-06 Thread Karam Chand
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 p

Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Karam Chand
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 >

Re: Cant compile embedded mysql server in Windows

2004-04-05 Thread Karam Chand
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

Cant compile embedded mysql server in Windows

2004-04-05 Thread Karam Chand
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

SQLyog with Notification Services

2004-03-31 Thread Karam Chand
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#

Re: MySQL 5.0 - What is really available?

2004-03-30 Thread Karam Chand
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

  1   2   >