Re: BLOB images in Crystal Reports

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 Haworth [EMAIL PROTECTED] To: Director General: NEFACOMP

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

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

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 FROM

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

Re: MySQL as a desktop DB

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. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

OT Re: Mysql, PHP and a wrapper

' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using

MyISAM to InnoDB

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

[Fwd: Re: MyISAM to InnoDB]

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 Haworth

Re: Report writer

/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 | | - -- Danny Haworth

Re: The Important question

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 : [EMAIL PROTECTED] (mailto:[EMAIL

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

Re: Access denied in MyODBC

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 | | - Original Message - | From: Danny Haworth [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday

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

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 System Administrator Gas

Re: MySQL on Redhat 7.3

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 System Administrator Gas~Elec

My Replication Story

, danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla

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

Re: My Replication Story

' 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 down. let me know. danny - -- Danny Haworth