Re: Recreate Table With Sorted Data

2007-08-16 Thread Martijn Tonies
John, The solution was CREATE TABLE copyname SELECT * FROM originalname I was having problem with a PHP command that's not pulling what I want from the table Ruling out random order for the rows was narrowing the focus on the PHP problem. Have you not been reading what everyone said?

Re: Problem with a complex query

2007-08-16 Thread Baron Schwartz
Hello, I don't know how indexes work is something I hear often. I will try to answer in the form of a blog post when I have some time. It is too complex to really answer in a short form, but basically an index is a b-tree (look at wikipedia for a good explanation) built on top of the

possible bug: general logging not working with 5.1.20-beta-log

2007-08-16 Thread Paul Maunders
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, We have general logging enabled on our mysql server via a my.cnf setting. The log records an entry when the server restarts, but does not record any queries. Is this a bug? or have I missed something. In my.cnf [mysqld] log=query.log Contents

Re: Recreate Table With Sorted Data

2007-08-16 Thread Chris Boget
The solution was CREATE TABLE copyname SELECT * FROM originalname I was having problem with a PHP command that's not pulling what I want from the table Ruling out random order for the rows was narrowing the focus on the PHP problem. Why not just create a VIEW and leave your original table

JOB: MySQL DBA - London, UK

2007-08-16 Thread james benjamin
Hi, I am looking to hire a permanent MySQL Database Administrator to take control of our company#347; database architecture and overall data held within. We are a passionate company at the forefront of our marketing - innovative mobile communication. We have a superb office location