Scheduled Backups Issue...
I am attempting to set and and schedule automated MySQL backups using the MySQL Administrator Tool downloaded from mysql.com. All of my back ups work fien when I perform them manually. However none of the scheduled backups ever get done. I am not sure where the glicth is but here is what the details are... I have a remote server (*nx box colocated at an offsite location). MySQL 5.0.21 is on the box. Logged in as root to the MySQL. Created a Backup Project. Added Schema to it. Under Advanced left all options at default EXCEPT changed to Lock All Tables. Set a local path to save the back ups. Set backup to run daily. Saved and said to use the root as the user to perform the back up. Nada... Please advise if I am being a toal DFU or what. Thanks, DB - Yahoo! Music Unlimited - Access over 1 million songs.Try it free.
Delphi Six w ADO MySQL - Query 2003048.
Greetings,
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the other to MySQL.
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Using the DbNavigator 'post' button, Attempts to write to Access succeed
where attempts to write to MySQL fail, all other things being equal. The
MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
My Ref is Query 2003048.
With thanks in anticipation,
john
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delphi MySQL
Hello lists,
Hello list,
This is my third re-mail on this topic.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the other to MySQL.
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Attempts to write to Access succeed where attempts to write to MySQL fail,
all other things being equal. The MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
Please can you quote my Ref 'Query 2003048'.
With thanks in anticipation,
john
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delphi MySQL
Hello lists,
This amends my third re-mail on this topic.
Sorry about that: A point to clarify is that the writes are done using the
update button of the DbNavigator.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the other to MySQL.
Briefly:
The project connects with TADOConnection, TADOTable and TDataSource, and
consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only),
and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
this with full read/write options.
Attempts to write to Access succeed where attempts to write to MySQL fail,
all other things being equal. The MySQL error return states:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near ','detail' SET '('
So far as I can see, all MySQL permissions exist for read/write access to
the DB.
My confusion arises from the fact that to give entry level experience, I
chose data aware controls which I presumed would not need coding to function
at a basic level. This works with Access but apparently not with MySQL.
Clearly I am missing something fundamental regarding differences between
MySQL's and Access's interactions with data aware components.
Can anyone suggest what it is that I am missing and how can I coax my
project to write to MySQL?
Please can you quote my Ref 'Query 2003048'.
With thanks in anticipation,
john
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
