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
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
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
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
> 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
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