Re: Oops... I think I deleted mysql.sock - WHAT CAN I DO?

2001-09-19 Thread Joshua M . Schmidlkofer
I think you should be safe to just restart MySQL On Wednesday 19 September 2001 08:32 am, Felipe Baytelman wrote: > Oops... I think I deleted mysql.sock - WHAT CAN I DO? > > I'm not a linux guy... I don't fly trough this OS... > > Could you help me? > > I'm really hurried! > > Felipe Bay

Re: UPDATE with automatic INSERT if not found..

2001-09-13 Thread Joshua M . Schmidlkofer
You COULD do what we do: select GET_LOCK(date) select & (update | insert) select RELEASE_LOCK(date) [I don't recall the exact syntax on the get lock) Anyway, all of our software uses this to emulate row-level locking. It is not as elegant as a 2 line SQL statement,but it is effect

Re: Mysql & SQL

2001-09-07 Thread Joshua M . Schmidlkofer
On Friday 07 September 2001 06:11 am, you wrote: > Giovanni Borri writes: > > hi all, > > > > i have a question. i would like to know if mysql has a sql'x' standard. > > my problem is that i would like to use UNION or MINUS or... but it seems > > not to work, another problem is that i would li

Re: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Joshua M . Schmidlkofer
I wanted to put in my 2 cents. Access is not an RDBMS.. It is a single user - small user, and frequent fix type system. I have never worked on a real database system that does not have a command line interface. It seems fearsome at first, but it's actually easy. SQL Server do doubt ha

Re: stability of replication?

2001-09-06 Thread Joshua M . Schmidlkofer
I have never tested with your magnitude - no where near that. You obviously would have one maching connected to the master per sub-network-cluster. [thus calling it tiered =]. I have tested over a network, using artificial packet destuction (for good measure), from a Linux box, running th

Re: Auto Importing

2001-09-06 Thread Joshua M . Schmidlkofer
Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames please] The advantage of Python, is that if you are using excel, you could go from excel [via python] into MySQL. Or you could use Python in much the same way that one could use Perl to process the log file. Of course

Re: safe_mysql not working properly, can any body help

2001-08-31 Thread Joshua M . Schmidlkofer
You need to look at the mysql error log, usually in your data directory. 99% of the time, if this is your first attempt to use MySQL you don't have the permissions tables created yet. There should be a mysql_install_db script that cam with your system, see if you have that, and try running