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
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 back up.
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
adrya.stembri...@gmail.com wrote:
I have a table like this:
ID PRODUCT DATEORDERED
15
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
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
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 server
