Using Visio to diagram MySQL db, export SQL

2004-09-28 Thread Ari Davidow
is total toast for this purpose, is there a comfortable open source tool that works under windows that will let me/help me visually set up my entity diagrams as I work out my database schema? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list

two masters, one slave

2004-03-12 Thread Ari Davidow
Is it possible to have two masters and one slave? I'm trying to replicate two master databases so that I have a failover. The alternate, I guess, would be to have two instances of mysql listing on different ports on the slave server platform? ari Ari Davidow [EMAIL PROTECTED]

Re: user d/b access

2004-01-06 Thread Ari Davidow
At 01:56 PM 1/6/2004, you wrote: Just fired up mysql 3.23.53 * Created a d/b, and then created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION; Yup. Well known privileges problem. The short answer is that the defaul

RE: MySQL 4.1 Production Release

2004-01-06 Thread Ari Davidow
The usual solution to this problem is to always code for things that exist. Then you have a relatively predictable coding path and relatively reliable testing tools. In the best of circumstances, you have no control over when something will be sufficiently bug-free and reliable to move into pro

Reverse DNS question

2003-12-17 Thread Ari Davidow
At 10:55 AM 12/17/2003, you wrote: MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases) Suppose we wanted to associate

missing something obvious w/grant statement length?

2003-12-16 Thread Ari Davidow
RANT ALL ON *.* TO "[EMAIL PROTECTED]" IDENTIFIED BY "foo"; ERROR 1145: The host or user argument to GRANT is too long I must be missing something very obvious--how to incorporate a hostname with a hyphen, for instance. Can someone help? ari Ari Davidow [EMAIL PROTECTED] http://

stress testing

2003-12-02 Thread Ari Davidow
Any suggestions? stress testers that have matched up against specific types of configuration? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

practical MySQL database size limits

2003-11-06 Thread Ari Davidow
arge MySQL databases? What are the practical limits under Solaris 2.8? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

binding a domain name to a MySQL instance

2001-12-11 Thread ari davidow
launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

permissions for updating from one machine to another

2001-11-09 Thread Ari Davidow
NSERT? What would be a reasonable way to approach this? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manua

my_print_defaults: not found

2001-10-29 Thread Ari Davidow
the startup to terminate. Is this something that can just as easily be disabled, or is there some information that is being sought here that should be placed correctly somewhere? ari Ari Davidow [EMAIL PROTECTED] www.klezmershack.com -

@HOSTNAME@: not found

2001-10-26 Thread Ari Davidow
.internetfaxjack.com > === > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list a