Review O'Reilly MySQL backup chapter?

2006-07-16 Thread Curtis Preston
I'm the author of the O'Reilly book "Backup & Recovery," due to be released in Q3 of this year. Among other things, it has a chapter on backing up MySQL. I'm looking for a few MySQL-knowledgeable folks to provide a technical review of this chapter. Obviously I'd want you to be experience

Help: PHP won't connect to MySQL

2006-07-16 Thread Kay C. Tien
Hi All, The simple script I'm testing works on a Linux server. I got tired of having to upload and test them, so I decided to install MySQL on my computer, which is running Win XP. MySQL works fine on it's own, I've set the the database and etc., but nothing happened when I tested the page.

Re: Sum and Total Query

2006-07-16 Thread Josh
Sorry... The dates were incorrect in my previous post. They are corrected below. --- Josh <[EMAIL PROTECTED]> wrote: > What's the proper way to query for a total for a > value > and also the total for all values for a particular > set > of parameters? > > For example, I have a table of orders

load-file() doesn't work

2006-07-16 Thread fleet
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in database album) with the following colums: ID NUM AUTO_INCREMENT PRIMARY KEY IMAGE MEDIUMBLOB I'm running mysql from the command line: mysql -u root 'root' has all privileges. The file I'm trying to load is /home/fleet/image.jpg

Sum and Total Query

2006-07-16 Thread Josh
What's the proper way to query for a total for a value and also the total for all values for a particular set of parameters? For example, I have a table of orders that customer service reps make. The reps place multiple orders per day for various products. I'm trying to pull a report that displays

arrays in stored procedures - pl. help

2006-07-16 Thread L P
Folks, say I have a need to add multiple rows at the same time. for instance, say I'm collecting customer information and I want to add 3 addresses and 3 phone numbers at the same time for a customer. The above is quite straightforward to accomplish when there is only one set of data to deal wit

Re: Table 'mysql.host' doesn't exist

2006-07-16 Thread Timothy Murphy
On Sunday 16 July 2006 12:34, thomas Armstrong wrote: > I don't've any idea about how to fix it, and I don't find any > '/etc/my.conf' file > into this machine. The install directory is '/usr/local/mysql'. I don't know anything about mysql, but on my system - Fedora 5 - the mysql databases are st

Re: Table 'mysql.host' doesn't exist

2006-07-16 Thread thomas Armstrong
I created this very-simple '/etc/my.conf': [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/var socket=/tmp/mysql.sock --- But it doesn't still work. '/usr/local/mysql/var' hosts the data, but within 'mysql' subdirectory, there are only two files: -- -rw-rw

Table 'mysql.host' doesn't exist

2006-07-16 Thread thomas Armstrong
Hi. Working with mySQL 3.23.58 on Linux, I get this error when trying to start mysqld: 060716 03:07:21 mysqld started 060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist 060716 03:07:21 mysqld ended - This Linux machine ha