MySQLGUI help file

2002-02-28 Thread Thi Cao
Hi everyone, I recently unpacked the Mysqlgui static binary distribution for windows and placed the MySQL.help file along with the my.cnf.win file in the c:/ root directory. I have the line help_file=c:/MySQL.help (also tried c:\\MySQL.help) in the my.cnf.win file. However, when I start up

Creating tables in MySQL++

2002-03-04 Thread Thi Cao
All, Using MySQL++, how do you check to see whether or not a specific table exist before you go ahead and create it? TIA Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL++

2002-03-04 Thread Thi Cao
All, Other than the MySQL++ documentation found at the mysql home site, where else can I find more examples and/or tutorials of using MySQL++? Thi - Before posting, please check: http://www.mysql.com/manual.php (the

MySQL Database Replication

2002-03-05 Thread Thi Cao
Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
Yes, I did flush the privileges when nothing else worked but that didn't do the trick either. Thanks for trying. -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
-Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work

MySql Database Replication Question

2002-03-07 Thread Thi Cao
All, How can I notify an application running on the slave server that the slave database has just updated itself by means of replication. The reason I ask is that I know MySql currently doesn't support triggers, but my application needs to be notified when an update on the slave has just taken

RE: MySql Database Replication Question

2002-03-07 Thread Thi Cao
PROTECTED]] Sent: Thursday, March 07, 2002 10:42 AM To: Thi Cao Cc: MySQL Subject: Re: MySql Database Replication Question On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote: All, How can I notify an application running on the slave server that the slave database has just updated itself

RE: MySQL Database Replication

2002-03-07 Thread Thi Cao
11:02 AM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication On Wed, 2002-03-06 at 14:26, Thi Cao wrote: When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE

Running a script using MySQL++

2002-03-12 Thread Thi Cao
All, I tried to run a script using MySQL++, but the procedure threw an exception stating that there's something wrong with the syntax. I did the following: Connection conn; Query query(conn); Result result; conn.connect(dbase,host,user,passwd); query source batch.sql; //most likely the

RE: Running a script using MySQL++

2002-03-12 Thread Thi Cao
sorry, careless typing, but that's just a typo -Original Message- From: Thi Cao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 10:48 AM To: MySQL Subject: Running a script using MySQL++ All, I tried to run a script using MySQL++, but the procedure threw an exception stating

RE: Running a script using MySQL++

2002-03-12 Thread Thi Cao
that's just a typo in the email message, however the script itself is correct -Original Message- From: Thi Cao Sent: Tuesday, March 12, 2002 11:00 AM To: Thi Cao; MySQL Subject: RE: Running a script using MySQL++ sorry, careless typing, but that's just a typo -Original Message

MySQL++ dll linkage warnings

2002-03-15 Thread Thi Cao
Compiler - MSVC 6.0 OS - Windows 2K MySQL++ 1.7.1 Whenever I perform a build of my project and link against the static mysql++.lib library, I often get the following warnings. Because I don't want to disturb the mysql++ source code, is there anything I can do to resolve the dllexport implicit

RE: MySQL++ dll linkage warnings

2002-03-15 Thread Thi Cao
PROTECTED]] Sent: Friday, March 15, 2002 11:10 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL++ dll linkage warnings Thi Cao writes: Compiler - MSVC 6.0 OS - Windows 2K MySQL++ 1.7.1 Whenever I perform a build of my project and link against the static mysql++.lib library, I

RE: MySQL++ dll linkage warnings

2002-03-15 Thread Thi Cao
Thanks again. -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 11:37 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL++ dll linkage warnings Thi Cao writes: Sinisa, I downloaded and am currently using the binary

URGENT: Update Error with MySQL++

2002-03-19 Thread Thi Cao
All, I can't seem to perform an update on my database with MySQL++. The execution of the query always throws an exception. Here's a snippet of what I did. Query query(conn); query update employee set children = 3 where id = 9; query.execute(); The above code throws an exception everytime.

RE: URGENT: Update Error with MySQL++

2002-03-20 Thread Thi Cao
thank you very much -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 8:25 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: URGENT: Update Error with MySQL++ Thi Cao writes: All, I can't seem to perform an update on my

RE: MySQL concept question

2002-04-12 Thread Thi Cao
an auto-increment/identity field to your table schema and when you select, use ORDER BY on that field. This is the only guaranteed way to retrieve records in the order in which they were inserted. -Original Message- From: Thi Cao [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 6:09

Inserting a BLOB using MySQL++

2002-04-22 Thread Thi Cao
All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it

SUMMARY: Inserting a BLOB using MySQL++

2002-04-23 Thread Thi Cao
- From: Opus [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:14 PM To: Thi Cao; MySQL Subject: Re: Inserting a BLOB using MySQL++ Probably the best bet would be to write the individual attributes to respective database columns. It keeps a few things simpler. It would also allow

mysqldump utility through MySQL++

2002-05-28 Thread Thi Cao
All, Is there a mysqldump utility routine that I can call using the mysql++ api? Thanks, Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

MySql Database Compare

2002-05-28 Thread Thi Cao
All, Is there a good GUI application out there that allows me to compare two mysql databases and view the differences? Thanks, Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual)