Php is not working with MySQL

2005-11-27 Thread Mester József
Hy I installed a Debian Sarge. Everything worked but I needed newer verison of mysql (4.1.11) and since I installed newer MySQL (from deb package) the php is not working with mysql. Please help. Joe - Win a Yahoo! Vespa NE

Re: MySQL database design documentation

2005-11-27 Thread Ben Wilson
Relational Database Design Clearly Explained, Second Edition ISBN: 1558608206 The original edition was my first primer on relational databases. It was an excellent read. Ben Maurice van Peursem wrote: Hi, I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 10.3, which

Re: 5.0.15->5.0.16 upgrade dependency failure

2005-11-27 Thread SGreen
The only times MySQL server interact directly with each other are: a) during replication b) NDB cluster operations c) FEDERATED tables Options b) and c) are available only in v5.0+. If what you want to do doesn't fall into one of those three categories, you will need to open a second connection

Re: MySQL database design documentation

2005-11-27 Thread Ligaya Turmelle
A couple of good links for databases. Database Design (quick and dirty, but gets the points across): http://www.geekgirls.com/menu_databases.htm - the from scratch side SQL: Basics: http://www.sqlcourse.com (you probably already know this stuff - but just in case. semi-Advanced: http://s

Re: MySQL database design documentation

2005-11-27 Thread Rhino
- Original Message - From: "Maurice van Peursem" <[EMAIL PROTECTED]> To: Sent: Sunday, November 27, 2005 6:33 PM Subject: MySQL database design documentation Hi, I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 10.3, which was easy. I've installed Perl sup

MySQL database design documentation

2005-11-27 Thread Maurice van Peursem
Hi, I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 10.3, which was easy. I've installed Perl support for MySQL, which was suprisingly difficult. I've installed CocoaMySQL (http://cocoamysql.sourceforge.net/) to create, inspect and backup databases. And now I'm build

Newbie question: UPDATE

2005-11-27 Thread Joe Herman
To those thinking of answering this question, There is additional information. For some reason, I found out that the version of PHPMyAdmin at my web hosting provider was missing the "Insert data from a text file into the table" feature found at the bottom of the page after clicking on the name of

How-to Juggle Two Databases . . .

2005-11-27 Thread Ben Wilson
I don't know if this is the best forum to ask this question, but I thought perhaps somebody here could at least point me in the right direction. I am looking to create an application (Win32 at least). This app will need the ability to write to a central database, but also be able to pull a snapsh

Re: The most frustrating thing (correction)

2005-11-27 Thread Peter
--- Peter <[EMAIL PROTECTED]> wrote: > This has happened to me so many times I am finally going to ask. Why in > the hell when I follow the directions given immediately after installing > do I get an error? > > Here is what the thing says after installing (and I quote): > > " > PLEASE REMEMBER

The most frustrating thing

2005-11-27 Thread Peter
This has happened to me so many times I am finally going to ask. Why in the hell when I follow the directions given immediately after installing do I get an error? Here is what the thing says after installing (and I quote): " PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so,

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

2005-11-27 Thread AmirBehzad Eslami
Mohsen wrote: > But himself solved his problem. > with : mysql_query("SET NAMES utf8"); > Even 4.0.x Wrong. I decided to prepare two different versions for my software: - A MySQL 4.0-friendly version using Romanizing method (Hats off to you, Ehsan) - A MySQL 4.1-compatible

Re: minimum processes at startup

2005-11-27 Thread Ondrej Koala Vacha
On Fri, 25 Nov 2005, Gleb Paharenko wrote: > Hello. > > > I have mysql 3.23.55 without innodb and it has one process, with innodb > > it starts with 16 processes. > > Information about MySQL threads is available here: > http://dev.mysql.com/doc/internals/en/threads.html CONNECT_PRIOR is the r

Re: 5.0.15->5.0.16 upgrade dependency failure

2005-11-27 Thread Gary Richardson
I've also experienced this. The 5.0.16 RPMs for RHEL3 worked fine on a RHEL3 box. As for the RHEL4, I even tried recompiling the source RPM's and still got the dependency error! I ended up using the generic RPM's as those installed fine. For me, it's a moot point anyway as 5.0.16 isn't stable eno

Re: Two MySQL databases on different computers

2005-11-27 Thread Octavian Rasnita
From: <[EMAIL PROTECTED]> > > Hi, > > > > I have two databases. Database A is located on a server that I run my > web > > hosting from. The other database B is located on a computer with a fixed > IP. > > How can I configure database B so I can access database B from my web > > server? From my A sy

Re: ORDER BY two clauses

2005-11-27 Thread Rhino
Your PDF is not very clear at all to me. Is the first part trying to describe the original table and identify the columns? Or is is pseudo code of some kind? Is the table you present the table that the query will read or is it the expected result? Your example query has a WHERE clause that

Re: Select returning more than I want

2005-11-27 Thread Rhino
- Original Message - From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" Sent: Sunday, November 27, 2005 6:03 AM Subject: Select returning more than I want I am not sure why this is, perhaps some join I am doing wrong. I am getting back 2 results, or records, identical to each ot

5.0.15->5.0.16 upgrade dependency failure

2005-11-27 Thread Marcus Bointon
I have a happily working 5.0.15 installation on RHEL4, installed from the standard RPMs. I'm upgrading using rpm -Uvh to the new 5.0.16 release. -Server, -client and -devel packages install ok, but when I attempt to install -shared, I get a dependency failure on zlib. Of course I have zlib

Select returning more than I want

2005-11-27 Thread Scott Haneda
I am not sure why this is, perhaps some join I am doing wrong. I am getting back 2 results, or records, identical to each other, where I only want one record. SELECT o.id, o.s_first_name, o.s_last_name, u.email FROM orders AS o INNER JOIN users AS u ON (o.user_id = u.id) INNER JOIN order_items AS

ORDER BY two clauses

2005-11-27 Thread Jad Madi
guys, I have little question, but to make it more clear I wrote it with example of what i want on this pdf, http://www.easyhttp.net/files/query.pdf please advise. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC