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! Mail

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

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: 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

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 oracle. Good

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 over

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

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

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

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

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 am

RE: [SPAM?]: Case issue in Information_schema

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

ALTER TRIGGER in MySQL

2005-08-05 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

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

Re: migrate Access to MySQL

2005-07-31 Thread Karam Chand
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027showtopic=1536view=getnewpost Karam --- Bing Du [EMAIL PROTECTED] wrote: Hello, I've been looking around for a while. Seems there are many options and tools that can help do it. Guidance and directions are highly

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 personal

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: 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, Mikhail

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 installed

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 database

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: 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 data

RE: Work / Home DB synchronization

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

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 working

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] wrote: Hi

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

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

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 site

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 directly

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 both

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 version of MySQL

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 a

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/mysql.

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

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

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: Hi

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: Serious bug (or my foolishness) with alter table and InnoDB

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

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

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

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

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

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: 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 ---

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

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. This is a normal behaviour

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: ALTER TABLE....with CHANGE syntax

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

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 Access

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

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

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 data

Re: FLUSH syntax query

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

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

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, 98 and

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 can

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',

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

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 query when using SSH tunneling So I use Putty to create the SSH

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 it,

Re: Static library for MySQL C API

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

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:

Re: mysql admin clients

2004-11-05 Thread Karam Chand
Hello, Check out SQLyog at http://www.webyog.com/forums/index.php?s=94f4afb247fdfdfbd6435d793a56d60aact=STf=2t=977st=0#entry3909 Its FREE and very powerful. Regards, Karam --- leegold [EMAIL PROTECTED] wrote: newbie question about mysql admin clients. What are some good ones? And

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

Re: Works with MySQL Logo

2004-11-02 Thread Karam Chand
+With+MySQL%22btnG=Search Aman Raheja Karam Chand wrote: Hello, I searched MySQL.com but couldnt find the official Works With MySQL logo. Can somebody point me to the right direction. If they can send it to me as an attachment, will be helpful. Regards, Karam

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 ---

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?

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

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, it does not allow you to create Fks in graphical manner like MS SQL

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 process

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 .sql

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'm

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!? Win

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: cdata/c cdata/c ... ... Now the problem is even if I mysql_real_escape() and changing entities like , to lt; gt; the data some of the characters are of ascii

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 if

Re: Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
to lt; solves the problem in the data? Regards, Karam --- Keith Ivey [EMAIL PROTECTED] wrote: Karam Chand wrote: i have a table with a LONGBLOB column. We store some small images in it. I want to export them in XML format with schema like: cdata/c cdata/c ... ... Now the problem

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_string() only escapes

Re: connect to mySQL without database

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

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)7451/53706-20

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 anything else

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 that can

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

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

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] wrote: Karam Chand

` 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

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

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

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 List For

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

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

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

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.1.1 source and unzipped. I opened up

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 to answer

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

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). I'm

  1   2   >