RE: Now what's that called?
Thanks Jimmy - that's the one. -Original Message- From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 19:39 To: 'Alexander Shaw'; mysql@lists.mysql.com Subject: RE: Now what's that called? Hello, Are you think of Eventum? http://dev.mysql.com/downloads/other/eventum/ Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 Are you MySQL Certified? www.mysql.com/training//certification -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, October 31, 2005 1:37 PM To: mysql@lists.mysql.com Subject: Now what's that called? Evening All, I knew I should have been paying attention. A while back I received an email about a software product that runs with mysql for development error tracking/reporting and it's used by the mysql ab team. Can't or the life of me remember what it's called. Can anyone help please? Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Now what's that called?
Evening All, I knew I should have been paying attention. A while back I received an email about a software product that runs with mysql for development error tracking/reporting and it's used by the mysql ab team. Can't or the life of me remember what it's called. Can anyone help please? Alex
Replication question
Hi Is it feasible to use replication to keep the database which powers my website up-to-date? The database itself is on the hosting companies server and contacted via dialup so the connection isn't there all of the time. Naturally I keep a copy of the database on my local machine too. Alex Alexander Shaw Agricultural Stock and Assignment Photography www.Agri-Image.com sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access forms and auto numbers
Thanks Chris that was spot on. Also discovered by accident once it was working that Me.Refresh can have the same result. Alex -- Alexander Shaw Agricultural Stock and Assignment Photography -Original Message- From: chris lewis [mailto:[EMAIL PROTECTED]] Sent: 18 June 2002 00:45 To: Alexander Shaw Cc: [EMAIL PROTECTED] Subject: Re: MS Access forms and auto numbers Try using this in a code builder window: DoCmd.RunCommand acCmdSaveRecord Make sure that your table has a TimeStamp field configured. If it isn't there, Access will say that the record was deleted. I'm not sure if you need to requery the form or not. It's been 2 years since I last worked with a form like that. Chris - Original Message - From: Alexander Shaw [EMAIL PROTECTED] To: MySQL Win 32 List [EMAIL PROTECTED] Subject: MS Access forms and auto numbers Date: 15 Jun 2002 09:32:15 +0100 Hi, I'm trying to upsize an application to MS Access front-end and a MySQL backend. The problem I'm encountering is that some of the data written from a bound form depends on an auto-number field, which in the case of MySQL isn't updated from Null until the record is written by moving onto the next new record. So in effect what I would like to do is force the record to be written in the after-update event of an object on the form so that either the form or corresponding text box with the auto-number displayed can be updated so the data 'exists' for the later writes to take place. I'm sure this should be pretty simple but haven't been able to find anything about it. Any suggestions gratefully received. Alex -- Alexander Shaw Agricultural Stock and Assignment Photography --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access forms and auto numbers
Hi, I'm trying to upsize an application to MS Access front-end and a MySQL backend. The problem I'm encountering is that some of the data written from a bound form depends on an auto-number field, which in the case of MySQL isn't updated from Null until the record is written by moving onto the next new record. So in effect what I would like to do is force the record to be written in the after-update event of an object on the form so that either the form or corresponding text box with the auto-number displayed can be updated so the data 'exists' for the later writes to take place. I'm sure this should be pretty simple but haven't been able to find anything about it. Any suggestions gratefully received. Alex -- Alexander Shaw Agricultural Stock and Assignment Photography --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [Fwd: Add existing related data to a table]
Thanks for this response, it is one way round the problem but is going to require copying the tables, some of them very large a number of times over and over. Is their no way of simply adding the data alongside the existing columns? Alex -- Alexander Shaw Agricultural Stock and Assignment Photography -Original Message- From: Sabine Richter [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 23:12 To: [EMAIL PROTECTED] Subject: [Fwd: Add existing related data to a table] Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: Hello Alexander, your problem is near to Taylor Lewick's and I have a similar suggestion for you: 1) create newtab select tableA.*, tableB.SubcatID from tableA.*, tableB where ... 2) delete tablea 3) rename table newtab to tablea If there are more rows in tableB (1:n), you don't loose data. The data of tabA will be dublicated. Ok, that are 3 statements. Bye Sabine Alexander Shaw wrote: Hi, I'm looking for some suggestions of making a one time update to some of my tables to make them useable with new forms and queries I'm creating. I have a series of tables which hold related data and only the last part of the data is stored in a final table, which means to search data based on some of the information higher up the table structure is making some very complex and dodgy queries. I want to insert the related data into the final table but can't think of a way of doing it. The example below might help me explain better what I mean. Consider two tables - TableA which contains PicID and KeywordID TableB which contains SubcatID and KeywordID What I want to do is insert the corresponding values for relating to KeywordID for SubCatID into a new column in TableA. Any suggestions how to work this to add the extra information to existing records? Alex -- Alexander Shaw Agricultural Stock and Assignment Photography p.s. to get throught he spam trap - sql query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Add existing related data to a table
Hi, I'm looking for some suggestions of making a one time update to some of my tables to make them useable with new forms and queries I'm creating. I have a series of tables which hold related data and only the last part of the data is stored in a final table, which means to search data based on some of the information higher up the table structure is making some very complex and dodgy queries. I want to insert the related data into the final table but can't think of a way of doing it. The example below might help me explain better what I mean. Consider two tables - TableA which contains PicID and KeywordID TableB which contains SubcatID and KeywordID What I want to do is insert the corresponding values for relating to KeywordID for SubCatID into a new column in TableA. Any suggestions how to work this to add the extra information to existing records? Alex -- Alexander Shaw Agricultural Stock and Assignment Photography p.s. to get throught he spam trap - sql query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote mysqldump
Paul DuBois wrote I can think of a couple of different ways to interpret your question. Offhand, I'd say that you want to specify -h server_host on the mysqldump command line, but if that's not what you mean, perhaps you can be more specific. Sorry probably not so well explained, I'll try again. Using another machine (running windows) elsewhere on the network, is it possible to perform a mysqldump of the databases on the server? i.e. without having to go physically to the server machine and typing the commands at the command prompt. Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote mysqldump
A quick query to save some shoe leather. Is it possible to perform a mysqldump from a remote windows client? Is so how? Have searched the net and MySQL site but have found nothing definitive. Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Any ideas how to speed this up?
Hi, I'm currently developing an application with an Access 2000 front end and MySQL back end. I have coded in updates to a table (based on selections in a list box) with a work around for the lack of support for sub selects using a temporary table. The problem is that already with quite small amounts of data in the tables (already indexed) things are pretty sluggish and there is huge amounts of reading and writing to the database. Does anyone have suggestions of ways I could speed this up please? I have included the code from the after update event of the list box in question. Alex Private Sub lstSimilarFrameNo_AfterUpdate() Dim strSQL As String Dim rstCurrentSimilars As DAO.Recordset Set rstCurrentSimilars = Recordset strSQL = SELECT FilmID,FrameID FROM Frames WHERE FilmID = cboSimilarFilmNumber Set rstCurrentSimilars = CurrentDb.OpenRecordset(strSQL) Do If rstCurrentSimilars.BOF = True Then Exit Do CurrentDb.Execute INSERT INTO CurrentSimilars (FrameID, FilmID, SimilarID) VALUES ( txtFrameID , rstCurrentSimilars!FilmID , rstCurrentSimilars!FrameID ), dbFailOnError rstCurrentSimilars.MoveNext Loop Until rstCurrentSimilars.EOF = True rstCurrentSimilars.Close Set rstCurrentSimilars = Nothing CurrentDb.Execute DELETE SimilarsForFrames.* FROM SimilarsForFrames LEFT JOIN CurrentSimilars ON SimilarsForFrames.SimilarID=CurrentSimilars.SimilarID WHERE SimilarsForFrames.FrameID= txtFrameID AND SimilarsForFrames.SimilarID=CurrentSimilars.SimilarID, dbFailOnError CurrentDb.Execute DELETE CurrentSimilars.* FROM CurrentSimilars WHERE (CurrentSimilars.FilmID= cboSimilarFilmNumber ) AND (CurrentSimilars.FrameID= txtFrameID ) Me.Dirty = False Dim i As Integer For i = 0 To lstSimilarFrameNo.ListCount - 1 If lstSimilarFrameNo.Selected(i) = True Then CurrentDb.Execute INSERT INTO SimilarsForFrames (SimilarID,FrameID) VALUES ( lstSimilarFrameNo.ItemData(i) , Me!FrameID ) End If Next End Sub --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Any ideas how to speed this up?
Cheers Ken, will give that a try for a start. Alex -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: 03 May 2002 22:00 To: 'Alexander Shaw'; MySQL List Subject: RE: Any ideas how to speed this up? What version of the ODBC Drivers are you using? I had a VB app using the 3.5x versions of the ODBC driver manipulating very small tables and it was absolutley painful to run. I stepped back to the version 2.x drivers (2.9, I think - anyhow, the driver information is available on the web site) drivers and the thing screamed. So, before looking for SQL based solutions, try using the 2.x drivers first, if you can. Regards, Ken Hylton Programmer Analyst IV LEC Systems Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949-7261 -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 2:28 PM To: MySQL List Subject: Any ideas how to speed this up? Hi, I'm currently developing an application with an Access 2000 front end and MySQL back end. I have coded in updates to a table (based on selections in a list box) with a work around for the lack of support for sub selects using a temporary table. The problem is that already with quite small amounts of data in the tables (already indexed) things are pretty sluggish and there is huge amounts of reading and writing to the database. Does anyone have suggestions of ways I could speed this up please? I have included the code from the after update event of the list box in question. Alex Private Sub lstSimilarFrameNo_AfterUpdate() Dim strSQL As String Dim rstCurrentSimilars As DAO.Recordset Set rstCurrentSimilars = Recordset strSQL = SELECT FilmID,FrameID FROM Frames WHERE FilmID = cboSimilarFilmNumber Set rstCurrentSimilars = CurrentDb.OpenRecordset(strSQL) Do If rstCurrentSimilars.BOF = True Then Exit Do CurrentDb.Execute INSERT INTO CurrentSimilars (FrameID, FilmID, SimilarID) VALUES ( txtFrameID , rstCurrentSimilars!FilmID , rstCurrentSimilars!FrameID ), dbFailOnError rstCurrentSimilars.MoveNext Loop Until rstCurrentSimilars.EOF = True rstCurrentSimilars.Close Set rstCurrentSimilars = Nothing CurrentDb.Execute DELETE SimilarsForFrames.* FROM SimilarsForFrames LEFT JOIN CurrentSimilars ON SimilarsForFrames.SimilarID=CurrentSimilars.SimilarID WHERE SimilarsForFrames.FrameID= txtFrameID AND SimilarsForFrames.SimilarID=CurrentSimilars.SimilarID, dbFailOnError CurrentDb.Execute DELETE CurrentSimilars.* FROM CurrentSimilars WHERE (CurrentSimilars.FilmID= cboSimilarFilmNumber ) AND (CurrentSimilars.FrameID= txtFrameID ) Me.Dirty = False Dim i As Integer For i = 0 To lstSimilarFrameNo.ListCount - 1 If lstSimilarFrameNo.Selected(i) = True Then CurrentDb.Execute INSERT INTO SimilarsForFrames (SimilarID,FrameID) VALUES ( lstSimilarFrameNo.ItemData(i) , Me!FrameID ) End If Next End Sub --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.346 / Virus Database: 194 - Release Date: 10/04/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access MyODBC MySQL and #DELETED
Hello everyone, This is starting to drive me mad now and I can't find a way round. I have installed the service pack and updates suggested in the manual, am running MyODBC 3.51 and MySQL 3.23.46 have added timestamp fields and enabled return matching rows. But still when I add a new record an try to go back to it everything is filled with #DELETED. Does anyone out there have any words of wisdom or suggestions please? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL, MyODBC and MS Access
This seems to be a very common question that appears very frequently on the group, in fact one I have asked in the past too. Could I stick my head over the parapet and suggest a person or persons with experience of Access front ends and MySQL backend puts together an FAQ for this, or better still it's included in detail in the documentation? FWIW a very good utility for exporting tables and data is MyAccess (available from http://www.accessmysql.com/) it would appear that the latest version also supports synchronisation between the two databases. I have successfully used this to move an applications tables from Access to MySQL with very few problems except with new records causing problems in forms due to the way that Access queries the database and deals with the index information. HTH Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access to MySQL conversion
Have a look at MyAccess available from http://www.accessmysql.com it has worked for me Alex -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 09:14 To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utility? Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.338 / Virus Database: 189 - Release Date: 14/03/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I think I need to tweak something ......
Evening all, Apologies if this is more of an Access problem but am not sure which end of the system needs tweaking. I have an Access database that I have exported and linked the tables from MySQL. At present I am still using the previous forms in Access to input data but it is causing problems. Some parts of the form require information from primary key (shown in a text box) but it is not updating after input of data in a new record, also moving onto the next record causes Access to show #Deleted in a number of fields in the record which has just been completed even though the data is in the table. Reopening the form solves these. Any suggestions what needs tweaking please? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 28/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting text error
Hi, I have an application running under Access 2000 with linked MySQL tables. At the moment I m trying to run a query to populate a second table. Some of the data in the query is a text description and for some reason is throwing up an error when I try to insert into the table. The error itself seems to appear as soon as there is a space between words in the description. Is there something I have overlooked or something I am doing wrong to cause this? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 19/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting records from Access creates Automation Error
Hi all, I have an application that is running under Access 2000 connected to a MySQL backend (3.23.46) via ODBC 3.51. Currently I'm trying to run a query and then scroll through the results inserting into a table via the ODBC link. All is well with the fields which contain numbers, but the longer field holding text information is giving an Automation Error (440) or more specifically -2147217911 (80040e09). The data itself is a title for an image up to 80 characters and I'm inserting into a char field of 80 characters. The error itself seems to be saying there's an error in the SQL syntax, but the point it is flagging up is actually within the data after the first word. Any ideas or help gratefully received Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 19/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: **Backing Up A Database**
Hi Felix (or anyone), I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a question to ask Do I need to alter anything in Cron for it to run the logrotate script? What would I need to put into the hourly cron folder to make things happen more often to check they are working correctly? Alex -Original Message- From: Felix Richter [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 15:26 To: David yahoo; mySQL List Subject: Re: **Backing Up A Database** - create a file in /etc/logrotate.d, filename does not matter, take this as a template, fill in connection parameters in mysqldump call (): /home/backup/sqlback/mybackup.sql { daily nomissingok nocreate compress rotate 14 errors [EMAIL PROTECTED] prerotate mysqldump --opt --full /home/backup/sqlback/mybackup.sql endscript } - check syntax and options of this file: man logrotate - you're set: cron will call logrotate each night. logrotate processes each file in the dir, executes the prerotate script and then compresses the logfile (i.e. SQL-Dump), renames older ones and keeps at max 14 of them (rotate 14). nomissingok will let you know if the mysqldump failed Felix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query in Access with connected MySQL table
Hi all, I'm currently trying to construct a query in Access that references to a temporary table I'm creating and populating on the fly. All is going well until I try to create the query. Although I'm opening the connection to the table etc Access is claiming not to recognise the table, any ideas what I need to do to get the Jet Engine to recognise the table? Am I looking along the lines of creating some form of link like the permanently connected tables I have? TIA Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing a query to work with MySQL
Hi, I'm very new to database design and have developed an application running on M$ Access and am currently in the process of moving the back end to MySQL, mainly to make use with a website easier. All is fine except for one query which contains a sub select so therefore will not work. The query and associated VB code is shown below, could someone have a look at it and suggest a work around to get this part working with MySQL please? CurrentDb.Execute DELETE * FROM KeywordsForPicture WHERE (KeywordsForPicture.PicID= Forms!frmPhotographs!textPicID ) AND (KeywordsForPicture.KeywordID IN (SELECT KeywordID FROM Keywords WHERE Keywords.SubCatID= cboSubCategory )) While I'm here are there any other tweaks people would suggest while using the Access Front end? The Access front end is a semi temporary arrangement, next personal challenge is to create a php driven front end. Thanks Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access and ODBC - have I got this right?
seem to be half remembering hearing somewhere that when Access opens a form (from any database, be it a jet database or MySQL linked via ODBC) it pulls down all the records that the form may want to look at as opposed to the one record you are looking at. Is this correct? If so can some one point me in the right direction of what code to insert and where to ensure that the only data accessed is that for the current record. Thanks Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.310 / Virus Database: 171 - Release Date: 19/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing location of database files
I've tried searching for the file that gives the location of the database directory, but am unable to find it. Without physically altering that directory is there any other way of changing the location of the database directory? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Changing location of database files
Jonathon wrote: You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it. Only problem is that the server is up and running perfectly but there is no sign of a my.cnf file anywhere. Will just adding one into /etc cause problems? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Searching for the configuration file
Hi all, I've just changed over to Linux instead of running on windows and I'm looking for the configuration file so I can change the default location of the databases and I can't find the file. Can anyone tell me where it is please? The installation was a straight install from the rpms. TIA Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC Call Fails
Hi all, Not sure if this is the right place to ask this one but here goes! I'm trying to export an Access 2000 database to MySQL and remain using Access as the front end. Everything seems to be working fine, except for this one line of code which is giving me and ODBC call failed error. CurrentDb.Execute DELETE * FROM SpecialismForContacts WHERE (SpecialismForContacts.ContactID= Forms!frmPhotographingContact!txtContactID ) AND (SpecialismForContacts.SpecialismID IN (SELECT SpecialismID FROM Specialisms WHERE Specialisms.AreaID= cboArea )), dbFailOnError Does anyone have any insights to why this is? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I'm sure this should be simple but I can't get it
Hi all, I'm trying to create a query that returns a set of data based on two tables. A basic description is that If Column A in Table 1 is Equal to Column A in table 2 then it returns the data from Column B in Table 2. However, Column A in Table 1 may contain a list of words that need to be matched not just one single entry. If someone could point me in the right direction for some code or a solution I would be very appreciative. Thanks Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL newbie and confused
Hi, I've just downloaded and install mySQL on my server but only seem able to connect to the server across my network if the server is connected to the internet. Any ideas why and how to stop it. btw I'm running windows. TIA Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php