MySql Database Compare

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) http://lis

mysqldump utility through MySQL++

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 arch

SUMMARY: Inserting a BLOB using MySQL++

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

Inserting a BLOB using MySQL++

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 w

RE: MySQL concept question

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 1

MySQL concept question

All, When I insert records into a database, the records will be inserted in the order that I have them listed in my insert statement. So my question is, will the MySQL database always return the records in the order of insertion when I perform any type of select query in the future? Of course,

RE: URGENT: Update Error with MySQL++

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 perfor

URGENT: Update Error with MySQL++

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 everyti

RE: MySQL++ dll linkage warnings

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 t

RE: MySQL++ dll linkage warnings

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

MySQL++ dll linkage warnings

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 de

RE: Running a script using MySQL++

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

RE: Running a script using MySQL++

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 st

Running a script using MySQL++

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 lik

RE: MySQL Database Replication

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

RE: MySql Database Replication Question

[mailto:[EMAIL 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 > slav

MySql Database Replication Question

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 p

RE: MySQL Database Replication

hanks everyone. Thi -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 replica

RE: MySQL Database Replication

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

MySQL Database Replication

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 0,ser

MySQL++

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 manual

Creating tables in MySQL++

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) http://lists.mys

MySQLGUI help file

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