actual database filesizes

2002-07-08 Thread //mikezero/
track_log.frm 5940028 -rw-rw1 mysqlmysql6076641280 May 4 08:02 track_log.MYD 5725520 -rw-rw1 mysqlmysql5857197056 May 5 04:02 track_log.MYI //mikezero/ //radiotakeover - Before posting, please check

Re: A field named "change" can't be created

2002-08-01 Thread //mikezero/
you could always try dropping a 'd' on the end of 'change'... as in making the field 'changed' if it's a flag to see if the data has changed. Gerald Clark wrote: > It is not a good idea to use reserved words for field names. > If you must, then use back ticks ( below the ~ on my keyboard) . >

Re: Performance/Efficiency

2002-08-12 Thread //mikezero/
if you are using this while going through an API like perl,php,c,c++ then you could do a call like "select LogID from Log WHERE LogIP="10.0.0.22" ORDER BY LogID DESC LIMIT 100" and run mysql_num_rows() on the resultant mysql query object. hope this is at least somewhat helpful. Cummings, Sh

Re: Remote admin app?

2002-08-30 Thread //mikezero/
if a web based solution is possible for you, use phpMyAdmin. http://phpwizard.net/projects/phpMyAdmin/ //mikezero/ //radiotakeover neal wrote: >What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? >Other? > >What's most popular and why?

Re: how to make a MySQL server run and how to check

2002-10-18 Thread //mikezero/
try 'ps aux | grep mysql' rather than using top... i dont' think you can grep a top session. Jack Chen wrote: if the server is running? I tried to use: top | grep mysql - but not working. Any suggestions? Thanks! Jack Chen, Stein Lab, Cold S

Re: ERROR 2013: Lost connection to MySQL server during query

2002-10-18 Thread //mikezero/
are you getting this problem with an API like php or perl cgi.. or is this command line. i was having a similar problem, but i couldn't access anything. i was trying to remotely connect to the mysql via command line and it would boot me. even on the server itself if i included the '-h hostna

Re: i almost hate queires, please help!!!

2002-10-28 Thread //mikezero/
eck: 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 -- //mikeze