Re: BLOB images in Crystal Reports

tility > or it uses MyODBC? > > I think the main problem to me is how Crystal Report is accessing the > database. > I will try to access the database using ADO and see if there is any change. > > > Thanks > Emery > ----- Original Message - > From: "Danny

Re: Compression: Security or Zipping?

Hi, I think this is more of a "Security by Obscurity" approach. E.g. compressed credit card details flying down the wire are less obvious than their plaintext equivalent. I guess there may also be a case of increased difficulty when trying to decompress a single part of captured traffic, like you

Re: From Win2000/IIS to Linux/Apache ?

Joe Stump wrote: I would assume the Win version comes with mysqldump - just mysqldump -uuser -ppassword -hhost database. You *might* be able to copy the data directory (someone else should chime in on this). I known copying the data dir from Linux to Linux isn't a problem with MyISAM tables,

Re: Managing replication logs

I too would be interested in a good way of clearing the binary log files (preferably non disruptive to the server ;-) The only thing thats saving me so far is that the systems capacity is 320Gb. danny Anirudha Kukreti wrote: hi all i have established a two way replication setup my problem is th

Re: Query

David Lubowa wrote: hey guys ..i got a question here i need to do a query which will let me pull 3 fields from a table; below is the table now what i need from this table in one query that will give me all these: " Realm, AcctStartTime, AcctStopTime" SELECT Realm, AccStarTime, AcctStopTime FRO

Re: advice

João Borsoi wrote: I working in a project to be released 6 months from now. We are currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading it to mysql 4.0.5a because of some deadlock bugs. What is the risk of going to a development version? Is it stable? I've been living on th

Re: My big table is locking for few minutes

Renaud Raffier wrote: Hello, I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49. All messages are stored in one table (850 000 messages) and I have some other tables but smaller. My posts table is 500 Mo large, index is also big because of full text index. I now have problems

OT Re: Mysql, PHP and a wrapper

e option '--with-mysql' in the './configure' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNAT

Re: MySQL as a desktop DB

t, when dealing with large databases? Depends on your hardware, but in the MySQL world 300,000 records is considered "small". Either way, i think you'll get a lot more performance out of MySQL on a single user system than access. H

Re: How much stable is MySQL in a production environment?

db and a joy to work with. We have roughly 300 users, local and remote (spread all across the uk on broadband connections) and the system remains in use 24/7. It's been running solid now for seven months. danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

Re: Access denied in MyODBC

' IDENTIFIED BY "password"' allows access for that user and my testuser can use any database. danny Sándor Tamás wrote: | Sure I have. In fact if I use 'Grant', I don't have to 'flush'. But I've | done it too. It didn't help. | | SanTa | |

Re: Store pictures in DB

in the database that get used to "sign" the certificate by crystal reports. The database seems to run fine but the signature pics rarely exceed 10k. IMO, if you have large pictures its best to store the filename in the db and put the pics somewhere else. danny - -- Dan

Re: The Important question

to use pretty good parts. Anyway, I swapped the ram out for some nice Kingston ram and switched the FSB to 133Mhz again and still no problems. HTH Danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email

Re: Report writer

his thread, e-mail <[EMAIL PROTECTED]> | To unsubscribe, e-mail <[EMAIL PROTECTED]> | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 018

[Fwd: Re: MyISAM to InnoDB]

S and temporary tables. (keep it simple eh?!?) so i think the shift will be quick and easy. I have a windows of about 3 hrs to down the server make the changes and get it operational again so I though it wise to check first! Thanks again all, Danny - -- Danny Ha

MyISAM to InnoDB

id be pleased to hear from you! ;-) Many thanks and best regards, Danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Ve

Re: MySQL on Redhat 7.3

module installed. you may want to go find and install this. as with any (re)installation i recommend you make a backup of your database first (usually /var/lib/mysql) if you have important information there. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

Re: My Replication Story

started jumpin' under real load. I know this probably isn't of much use to you, i'll try writing up a few perl scripts to create some "virtual load" and see what happens then. If there's anything else i can provide for you to help trace this bug d

Re: How to use Auto Increment

. | | How can I do it in MySQL. after inserting into the auto_increment table, do a 'SELECT LAST_INSERT_ID()' which will return the last autoincremented value. You can use this value in your second insert statement. danny - -- Dan

My Replication Story

the master. any pointers gladly taken, however small.. best regards to you all, danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SI