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

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

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

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 [

MS Access forms and auto numbers

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

RE: [Fwd: Add existing related data to a table]

B (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 s

Add existing related data to a table

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

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 agai

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

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 ha

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 am

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

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

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

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.

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

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 longe

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 work

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 idea

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 quer

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 poin

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 p

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-

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 Al

Thumbs Plus! and MySQL

Hi all, Just browsing through the windows application Thumbs Plus! and I see it can be linked via ODBC to external database servers. Seeing that all my other databases are there already I can see and opportunity to share some information. Is there anyone here with experience of using MySQL as th

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

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 matc

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