Re: database modelling tool
hi, there is such a tool from thekompany (i think www.thekompany.com) but it is commercial. Am Don, 2002-06-13 um 12.03 schrieb Veysel Harun Sahin: Hello, Is there any database modelling tool for mysql? -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - 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
Re: ERD for MySQL?
Its not open source, but I think theKompany.com has a good one. Am Fre, 2002-02-22 um 04.55 schrieb Jeff Kilbride: Are there any open source ERD programs for MySQL for doing basic data modelling? I tried myERD at sourceforge and it couldn't parse the sql dump from my database. It died with a parse exception on the unsigned attribute for my int columns. Any other choices out there? Thanks, --jeff - 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
Re: Question about SQL...
Hi Subselects doesn't work at time. Am Fre, 2002-02-22 um 12.47 schrieb Guillaume BABIK: Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me.. Thks a lot.. BABIK Guillaume Développeur Web [ http://www.absolut.fr/ ]ABSOLUT Reality - 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
Re: Problems compiling PHP with mysql support as a apache DSO on aHPUX11.x box
Do you have also recompiled apache after compiling php ? Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka: Hi, mmh, maybe it's not a mysql-problem... Yes, I read through the numerous threads about this topic but I can't solve my problem After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO (./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47 --with-apxs=/opt/apache-1.3.23/bin/apxs) apache complains with the following error: bin/apachectl start /usr/lib/dld.sl: Unresolved symbol: __umoddi3 (code) from /opt/mysql-3.23.47/lib/mysql/libmysqlclient.sl.10 Syntax error on line 236 of /opt/apache-1.3.23/conf/httpd.conf: Cannot load /opt/apache-1.3.23/libexec/libphp4.so into server: No such file or directory bin/apachectl start: httpd could not be started I compiled all the stuff with gcc version 2.95.2 19991024 (release) Here are the options I used to compile MySQL CXX=gcc CFLAGS=-fomit-frame-pointer -O6 -fpic CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O6 ./configure --prefix=/opt/mysql-3.23.47 --with-low-memory --with-innodb chatr Any idea?? - 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
HA mysql DB
Hi List I have to set up a HA-Linux Server with Apache and mysql running on two machines over load balancing. Apache isn't a problem. But mysql. AFAIK it is impossible to cluster mysql - it only supports replication. As I've said already, we have only two machines, and two firewalls of course, for web and mysql server - but this two machines should for the best work load balanced and failsafe. So, if one machine fails because of a hardware fault - the other machine must be able to overtake the whole work. So it is necersary to install Apache and mysql on both server's. And, to get the best performance out of it, I've got the following idea: The whole WebApplication has an own db interface so that it should be possible to... First Server runs: apache and mysql master - all write Operations are done one the master - read operations from the first server are also done one the master. Second Server runs: apache and mysql slave - gets synchronized by the master - read operations from the second server are done on the slave - write operations are getting directed to the master - which then synchronize the slave. Because of dynamic load balancing this should get a nice average load. If then one machine fails - then you have on both machines everthing you need to work in standalone mode. The only thing is, that you need some scripts which switches the databases from slave to master mode, doing synchronization after the are working again, redirecting all the read/write operations to one machine, and some additional work. So, after a long paragraph, what to you think - should this be possible or have you any better ideas ? With what I'am wrong ? - 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