Re: newbie config help needed

2009-01-31 Thread Guenther Boelter
Hi Dave, that's easy. Either install http://www.phpmyadmin.net/home_page/index.php on the server, the best tool to manage a mysql server. Or use XAMPP, a complete package from http://www.apachefriends.org/en/index.html Guenther Dave Stevens wrote: > Hello all, > > I have set up a little serve

Re: newbie config help needed

2009-01-31 Thread Baron Schwartz
Dave, Log in as the user you intend to set up for them. Issue the following: show grants; select @@sql_mode; If you aren't sure how to interpret the information I will direct you to the manual: http://dev.mysql.com/doc/refman/5.0/en/ Side note: I would upgrade. 5.0.45 has some pretty serious

newbie config help needed

2009-01-31 Thread Dave Stevens
Hello all, I have set up a little server and am pitching to an organization to host their upcoming new site. The box is Centos 5.2 up to date and mysql 5.0.45. The requirements below must be met but I don't know how to verify their status. Can someone point me in the right direction. Will read

Re: UPDATE ... where max(datecolumn)

2009-01-31 Thread Baron Schwartz
Is there ever more than one order per day? I also think you might mean "most current order per product", but you didn't say that. On Tue, Jan 27, 2009 at 8:38 AM, Adria Stembridge wrote: > I have a table like this: > > ID PRODUCT DATEORDERED > 152005-02-18 > 22

Re: /var/log/mysql is taking up a lot of diskspace

2009-01-31 Thread will
> this is what logrotate run before and after > > [ -e /var/lock/subsys/mysqld ] && /bin/kill -HUP `cat > /var/run/mysqld/mysqld.pid 2> /dev/null ` || /bin/true > > Assuming paths are the same I would run the above commands. Short of > that I would take down mysql, delete log, then bring mysql bac

Re: ERROR 1010 (HY000): Error dropping database (can't rmdir ./foobar

2009-01-31 Thread Claudio Nanni
Here is how I got out of it: # rm -f foobar/* (with server running! but not accessed by anyone, its a preprod slave ) mysql> drop database foobar; mysql> create database foobar; mysql> source foobardump.sql I think it was a mismatch in the data dictionary between the database and its