Re: BLOB images in Crystal Reports
Crystal was pulling the data through MyODBC, Mascon was just used for inserting the image into the database. hth danny On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote: I want to ask you one thing: Is your Crystal Report accessing the database through the Mascon Utility 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 [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports I've had no problems with MySQL, crystal reports and blob images. Main differences here are the following: Crystal Reports 8.5 (not 7) Myodbc 2.x (haven't tried 3.x yet with images) Images were also inserted into the MySQL database using a third party utility called Mascon (http://www.scibit.com/). They do a free, unlimited, version (annoying nag screens but still) if you want to try that out? If that works, you can see the differences between the way mascon stores them, and the way you are storing them.. I'm assuming if crystal is reading happily from mssql then that cant be at fault. hth danny On Thu, 2003-10-09 at 13:08, Director General: NEFACOMP wrote: It was a good idea but it is not feasible for my case since I will be displaying many images coming in a recordset with many records. If it was only one record, then I would follow your advice. When I get the images from a MS SQL 2000, Crystal Reports displays them without problems. But when I switch to MySQL, I fail. Thanks Emery - Original Message - From: DenBaguse MasRodjie [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:44 Subject: Re: BLOB images in Crystal Reports You can manually get that BLOB binaries from MySQL and copied to local file. And from CR get that file. Rgds, Roji - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mike Hillyer [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:23 PM Subject: BLOB images in Crystal Reports Hi group, has anyone tried to display BLOB pictures from MySQL through MyODBC in Crystal Reports? I have tried everything but I failed. Any ideas on how to achieve this is highly appreciated. I am using: MySQL 4.1.0 or MySQL 4.0.14 MyODBC 3.51.06 Crystal Reports Ver 7 (7.0.1.192) Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 would get when trying to decompress a 10k part of a large zip file. hth danny On Tue, 2003-10-07 at 10:49, Director General: NEFACOMP wrote: Hi group, I have read in the MySQL manual that the client/Server Compression protocol adds some security to the application. Does anyone have more information on this? Thanks, __ NZEYIMANA Emery Fabrice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, i've never managed to get a straight InnoDB file copy to work though and im also not sure about Win - Linux. -Original Message- From: Theisen, Gary [mailto:[EMAIL PROTECTED]] I'm wondering if it's a hassle, or even possible, to move the MySQL database from the windows/IIS box to the Linux/Apache box? Any corruption, or other problems associated with this type of move? I'd still use MySQL dump, if the win version doesn't come with mysqldump, just use the linux version ;-) P.S. I also have the option of leaving Win2000 in place but switching to Apache service. Would this be worth it? In other words, would that setup be a better web server environment (for PHP MySQL) than the Win2000/IIS setup? I started off using IIS + MySQL a couple of years back... about 10 months ago I made the move to Linux + PHP (i've been a long time Linux fan) because the IIS boxes were driving me up the wall (poor reliability, inflexibility and the torrent of fixes and patches). Ever since then i've been a devout LAMP (Linux, Apache, MySQL PHP) fan. The platform is rock solid and extensible beyone belief ;-) HTH danny - 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: 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 that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files mysql, queries - 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: 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 the edge of a knife, running a production system on 4.0.1/2/4/5 for the last few months, had some minor problems with 4.0.3 but every other release has been quite solid. So, no, I dont think you'll run into any problems ;-) regards, danny - 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: 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 radacct; danny - 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: 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 with my board: the posts table is locking for fews minutes and all tasks are waiting to be executed until max_connections is at the limit. It seems that post table is locket by an INSERT of a message. After minutes, INSERT is done and all others requests are done bit server is very loaded and some user have Too many connections error. I've solved problem with wait_timeout=120 instead of 28800 but this is not a good solution. I assume you are using mysql_pconnect()? That way, PHP will reuse old connections instead of opening up a brand new one each time. danny - 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 as a desktop DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I currently use MS Access as a single-user desktop database. The database is | getting quite large. The largest table has 300,000 rows. Definately a case when an upgrade would help, but maybe it's not essential. We used to use a system here that maintained all its data in a shared access database on a winnt server box. It needed constant maintenance but i think we pushed to mdb up to about 700mb before it finally exploded ;-) | I am considering upgrading the database. How suitable is MySQL as a | single-user desktop database? How does it compare to Access when it is used | like this? Very suitable. Simmilar to Brian in his previous post I use MySQL as a desktop db under Linux. The MyODBC connector also provides a good way of accessing data through other applications. When the old system exploded, we initially moved all the data to a MySQL database and then used the old front end by linking the tables into a dummy access db through MyODBC! | Obviously MySQL would have advantages if I intended to use it as a server | database with concurrent users. But is it faster than Access in the | single-user environment, 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. 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 GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWo3UKf+497XC3QRAhYyAJ4zv1bJiPXHA7G2uheSoJ61ANW7zQCgi+Fu /X8BthNnRHBASz/RgTHPg0Q= =SuSt -END PGP SIGNATURE- - 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
OT Re: Mysql, PHP and a wrapper
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | I'm running apache-1.3.23-14 on a redhat 7.3 system. | I have installed the php-rpm and the php_mysql.rpm from Redhat. | installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. | | Cannot connect to my mysql-3.23.49-3 database. | | If I use mysql_connect() only, I get Fatal error: Call to undefined | function: mysql_connect() in /var/www/html/admin.php on line 9 I had massive problems with the redhat php rpm's.. get the source from the php homepage and include the 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 SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWukUKf+497XC3QRAhU6AJ0eK4hnb8ARkJ1QJHTLg24mN5nV2gCeJl4M Bbd+8gXfFtsDpu2HCu/DgjI= =ZBdO -END PGP SIGNATURE- - 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
MyISAM to InnoDB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Just needing a little advice really, we have a (now) very large mysql database thats keeping track of gas/electrical safety inpection data. Since it was meant to just report on this data to produce very complex safety certificates and reports we chose the MyISAM table type. Unfortunately things never stay the same for long and the company decided to bolt in a bunch of other stuff ;-) Now we have a lot of reads and a lot of writes to the database and i'm seriously considering moving to InnoDB tables. Question is, will this require any SQL code changes to our application? We make heavy use of features like temporary tables, autoincrement columns etc. Would if be as simple as dumping the database and restoring it to InnoDB tables? If anyone has any experiance of doing this and/or knows of any issues i may run into 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- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kCxpUKf+497XC3QRAk9KAJ400Uot3GLyzf4yMV0V+ybE1BvL/QCfXeTS FOQfHoCMPqTSOKIdfPkdZ8E= =w6Se -END PGP SIGNATURE- - 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
[Fwd: Re: MyISAM to InnoDB]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 grr: sql,query,mysql ;-) Hi Guys, Thanks to everyone that gave a response there, i feel much better now ;-) I'm not using any of the features listed in the recent posts just pain simple boring INSERTS, UPDATES, SELECTS 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 - http://enigmail.mozdev.org iD8DBQE9kESMUKf+497XC3QRAp2RAKDDeRmvHB2Eayr74X1Ku+d2cqdd6QCeOHN7 Olm4Bg6VxheM0elhN/xf+wY= =+KyX -END PGP SIGNATURE- - 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: Report writer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Hey dude, I've been through this problem too. Unfortunately, short of writing your own module (we did some experimentation using html and pdf) there are very few options i know of. Here we are using a dedicated crystal reports server and crystals passthrough module on the webserver which redirects requests to the report server. The whole thing works really well and keeps load on the webserver down. But it will require that you write some stuff in ASP first. (I've been using PHP for ages now and going back to ASP seemed a little like going back to dialup after having months of time on broadband ;-) danny NZEYIMANA Emery Fabrice wrote: | Can you please help me? | | If you can help direct me where to get a report writter running on Windows. | By reading your post, you know some report writters that run on windows. | | | Thanks | Emery | - Original Message - | From: Derek Scruggs [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, September 24, 2002 6:12 AM | Subject: OT: Report writer | | | |Hi All, | |This is a little OT, but I'm looking for a report writer/server for |Apache/MySQL. There are lots of report writer/servers out there, but the |ones I've found so far either 1) work only on Windoze or 2) cost a lot of |money. I'm just looking for a basic tool that allows me to design | | relatively | |simple reports on a Windoze desktop and upload the report schema to a |Linux/Apache web server, which generates the reports on the fly. It would | | be | |great if it used PHP so I could tweak the internals, but I'm not holding | | my | |breath on that. | |I'll probably end up writing my own module, but it would be nice if there |were something available that automated some of the more mundane stuff | | such | |as pagination, parameters etc. | |TIA, |Derek | | |- |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 | | - -- 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 - http://enigmail.mozdev.org iD8DBQE9kEzgUKf+497XC3QRApDPAKCiNDc9Jc4OBbbiWJd61tAHsVSR7wCfRytq JU0nK1zLZ/4yvpcYiLeyYKc= =n8OD -END PGP SIGNATURE- - 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: The Important question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 filter: mysql sql query Hi! |I installed mySql 3.23.49 on a Dell PowerEdge 2400 with 1Gb RAM, |dual processor, RAID 3 and Windows 2000 Server. Unfortunately, the |machine was freezing every day, and some times twice a day. Some |times, and really frequently, mySql was stopping execution showing |the message on the screen: The memory could not be |read ... mysqld-max-nt.exe. Well, it was clear for me that the I had a simmilar problem with a low-end server a while back. Seem's the manufacturer (also dell in this case) used resonably cheap ram. I managed to get the thing going by reducing the FSB speed down a notch (in this case is was from 133Mhz to 100Mhz) and immediately the freezing stopped. Have only had this problem once will a dell machine. Usually they seem 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 : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kHU9UKf+497XC3QRAlN6AJ99CocTIv/LfFeKdEEf64gQhwHgkwCfYmdx 0B+1adngtVdzR2CmjToM5M4= =mk5c -END PGP SIGNATURE- - 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: Store pictures in DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roland Perez wrote: | Can I use MySQL to store pictures as part of a record? | Should I just try to store the name of the picture? Yep but it depends on the size of the pictures. We produce certificates here and we hold images of engineer signatures 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 - http://enigmail.mozdev.org iD8DBQE9kHYwUKf+497XC3QRAh//AKCzZVjBfIzmWa0Cgi6ZfEVg4oSLgQCglyLU giYX43u7ACg2DbvCK4gr7O8= =BfZB -END PGP SIGNATURE- - 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: Access denied in MyODBC
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi SanTa, I think i may have an idea, have just tested this on my server. Granting 'USAGE' on all databases allows my 'testuser' account to connect to the server through the mysql cli. HOWEVER, if i try and issue a 'USE {database}' command I get access denied because the user has only 'USAGE' privileges on all databases. Since MyODBC connects to a single database, it would get an access denied error with the USAGE priv. issuing a 'GRANT SELECT ON *.* TO testuser@'%' 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 | | - Original Message - | From: Danny Haworth [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, September 24, 2002 12:56 PM | Subject: Re: Access denied in MyODBC | | | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |Have you issues a 'FLUSH PRIVILEGES' to reload the privilege tables and |pick up on the new grants? | |danny | |Sándor Tamás wrote: || I gave privileges with NetUser@'%'. But I still can't connect. || And through mysql command line I can connect, but with MyODBC, I can't. || || SanTa || || - Original Message - || From: Bryan [EMAIL PROTECTED] || To: 'Sándor Tamás' [EMAIL PROTECTED]; [EMAIL PROTECTED] || Sent: Tuesday, September 24, 2002 11:21 AM || Subject: RE: Access denied in MyODBC || || || Did you give netuser privileges for an i.p address (netuser@ip address || or netuser@%(anywhere), if not then then Netuser probably only can || connect as a localhost. || || -=Bryan=- || || || || -Original Message- || From: Sándor Tamás [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, September 24, 2002 12:59 AM || To: [EMAIL PROTECTED] || Subject: Access denied in MyODBC || || || Hi, || || I have a problem. I created a user called NetUser, and gave only usage || privilege on all databases. I can connect through mysql command line, || but I can't with ODBC. Is there anybody who know why it is? I need to || know this to higher the security of my tables. || || Thanks, || SanTa || || || || || || - || Please check http://www.mysql.com/Manual_chapter/manual_toc.html; | | before | || posting. To request this thread, e-mail | | [EMAIL PROTECTED] | || || To unsubscribe, send a message to the address shown in the || List-Unsubscribe header of this message. If you cannot see it, || e-mail [EMAIL PROTECTED] instead. || || | | | |- -- | |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 - http://enigmail.mozdev.org | |iD8DBQE9kETfUKf+497XC3QRApHIAJ9iVnPPiydiqnkSPPEkAE3ggiwgzACfRbOY |ACADl+ztMq7Zbrvua5eE1UA= |=+I9q |-END PGP SIGNATURE- | | |- |Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before |posting. To request this thread, e-mail [EMAIL PROTECTED] | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail [EMAIL PROTECTED] instead. | | | | | | - | Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before | posting. To request this thread, e-mail [EMAIL PROTECTED] | | To unsubscribe, send a message to the address shown in the | List-Unsubscribe header of this message. If you cannot see it, | e-mail [EMAIL PROTECTED] instead. | | - -- 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 - http://enigmail.mozdev.org iD8DBQE9kIwBUKf+497XC3QRApkpAJ9vJkTYspL1yddhRO6KE3njqONGggCggrKz vqW5iDWmuxFXeIuqiirvPCo= =cAYh -END PGP SIGNATURE- - 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: How much stable is MySQL in a production environment?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, | I would like to use MySQL in a production environment | (now I am using it in a development environment). Do | you know if is a frequent problem that the mysql | database damages suddenly? Have you experience with | this type of problems? I've been living life on the edge of a knife recently by using MySQL in a production environment since version 4.0.1 ;-p However although it was classified as alpha i have had no problems at all (apart from a small issue with 4.0.3 and temporary tables). So far mysql has been a solid 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 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 - http://enigmail.mozdev.org iD8DBQE9kI0RUKf+497XC3QRAqq7AJwJTDjBB3hmecB9E2rLW2h1OzmdFwCgnkfV JVMWRNiBqx0bMHcvZ1Gymf4= =w26b -END PGP SIGNATURE- - 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 on Redhat 7.3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Goggin wrote: | I followed the advice given but get these errors: | If I use rpm -Uvh MySQL-3-23-52-1.i386 I get; | error failed dependencies | MySQL-server conflicts with mysql-server-3.23.49-3 | followed by a list of dependencies on libmysqlclient.so.10 | If I use rpm -Uvh MySQL*.rpm I get: | error failed dependencies | MySQL-server conflicts with mysql-server-3.23.49-3 | MySQL-DBI-Perl-bin is needed by MySQL-bench-3.23.52-1 | | Do I need to deinstall all of the old rpms first or is there some form of | force command I should use? Looks like you have a conflict between packages installed with your distro and the official mysql packages. Personally i would remove the origional packages first. Do an 'rpm -qa | grep -i mysql' which should list all the currently installed packages. remove these using rpm -e {package name} where {package name} is each package listed from the 'rpm -qa...' that is equivalent to the packages you want to install (e.g. mysql-server. for MySQL-x). you should then be able to install the newer packages. MySQL-bench is also saying it wants the mysql perl dbi 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 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 - http://enigmail.mozdev.org iD8DBQE9iHM2UKf+497XC3QRAjHVAJ9KOxIJISpb2mBw2LyH1GkYxRTvUgCeI65B bn5hA+o3PvQcW1/WVzLLMr4= =omjO -END PGP SIGNATURE- - 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
My Replication Story
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result + 4035 0x80a3a86 handle_select__FP3THDP6st_lexP13select_result + 102 0x807ceda mysql_execute_command__Fv + 946 0x8080af5 mysql_parse__FP3THDPcUi + 557 0x807bfe3 dispatch_command__F19enum_server_commandP3THDPcUi + 1495 0x8081eae do_command__FP3THD + 94 0x807b1be handle_one_connection__FPv + 682 0x8278e9c pthread_start_thread + 204 0x82ae29a thread_start + 4 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8728558 = SELECT DISTINCT job_headers.*, job_threads.access_timeslot, job_threads.access_comments, job_threads.access_timeslot_details, job_threads.date_of_inspection, job_threads.access_type, job_threads.engineer_comments FROM job_headers, job_threads WHERE job_threads.jid_ptr=job_headers.jid AND cmpid=18874 thd-thread_id=1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Im not a database expert so the above really doesn't mean much to be honest. But all other errors in the file are virtually identical. If anyone needs any more information i'd be quite happy to post the full log files on the net (am reluctant to fill up everyones mailbox!) or by email. something i forgot to mention is the above logfiles came from 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 SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9iFCXUKf+497XC3QRAo4bAJ9R90nfFCn60zDDIvVQ3b/fiZLPhwCfU3q+ y26N/gXC2TFbe9atAz2tyNY= =Cdcz -END PGP SIGNATURE- - 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: How to use Auto Increment
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I am writing a script where I will have 2 insert statements | The first insert is into a table which has an Auto_Increment field. | I want to know the value which was inserted in this Auto_increment field and | use it in the second INSERT statement. | | 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 - http://enigmail.mozdev.org iD8DBQE9iGENUKf+497XC3QRAinfAJ0dgODNkRypaa/5D9R4VA8LAwoalQCfTwnm YOkwrvwm7ZWfvH8rwVhcDFc= =k+A3 -END PGP SIGNATURE- - 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: My Replication Story
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Victoria Reznichenko wrote: | As far as I remember there was found and fixed the similar bug in | 4.0.3. Could you provide output of SHOW CREATE TABLE for testing? Hi Victoria, When you say 'SHOW CREATE TABLE' I assume you mean during the creation of the temporary table (SHOW CREATE TEMPORARY TABLE)? In which case mysql politely informs me that i have an error in my SQL syntax ;-) I cant afford to take down the master database since it is in use round the clock but i have upgraded the slave server to 4.0.3 with an identical copy of the data restored from dds. I was unable to reproduce the problem either, probably because the database wasn't under load just merely hosting my single connection. Strangely this is the same behaviour I got from the main database after its upgrade, worked fine with 2-3 connections but 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 down. let me know. 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 - http://enigmail.mozdev.org iD8DBQE9iJstUKf+497XC3QRAneNAJ996eZ7vYchyQ/VTffyvgPP4WZklACeOi6b o2M29ZjPj7bBHt0kC8amLQI= =aXgE -END PGP SIGNATURE- - 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