Table 'mysql.host' doesn't exist
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 has been working ok for months, and it stopped suddenly. 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'. Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table 'mysql.host' doesn't exist
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 1 mysql root0 may 30 2005 func.MYD -rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm Where are 'host.frm', 'host.MYD' and 'host.MYI'? On 7/16/06, thomas Armstrong [EMAIL PROTECTED] wrote: 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 has been working ok for months, and it stopped suddenly. 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'. Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table 'mysql.host' doesn't exist
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 stored in /var/lib/mysql ; in particular the mysql database is stored in /var/lib/mysql/mysql/ where I see the files host.[frm,MYD,MYI] . -- Timothy Murphy e-mail (80k only): tim /at/ birdsnest.maths.tcd.ie tel: +353-86-2336090, +353-1-2842366 s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
arrays in stored procedures - pl. help
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 with (one address / one phone number) - with simple data types passed in as parameters. What alternatives / options do I have to accomplish storing multiple sets of data? I do not want to call the stored proc. multiple times from an external program. (avoid if possible) I do not want to write to a dump file, manage that, and use mysqlloader. I do not want incorporate split, join logic into the stored procedure. (avoid if possible) Thanks, listaction
Sum and Total Query
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 the customer service ID (csID), total number of a particular product sold, and the total of all products sold... within a date range. Sample Orders Table (heavily snipped): ORDER_ID CS_ID PRO_ID QTY_SOLD DATE - -- - 1 10 105 3 2008-07-06 2 12 105 4 2008-07-10 3 10 105 3 2008-07-10 3 10 120 2 2008-07-10 4 12 105 1 2008-07-11 When querying for the totals between July 8-July 11, the query should return something like: CS_ID PRO_ID PRO_TOTAL ALL_TOTAL - -- - - 10 105 6 8 10 120 2 8 12 105 5 5 I've tried various queries that work when I sum up individually, but when I include 2 sums for a row I'm getting duplicates and the sums are too high. This seems like it would be fairly straightforward but apparently I'm overlooking a key item. Oracle has a handy OVER() function that would work... Any thoughts? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
load-file() doesn't work
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 It *is* world readable. INSERT INTO photos (image) VALUES (load_file('/home/fleet/image.jpg')); Gives no errors; but all I get in the column is NULL. SHOW TABLE STATUS photos; Shows column width to be 30. I've tried every permutation of this statement I can think of, with NO success. MySQL Reference Manual for version 3.23.36. suggests: mysql UPDATE photos SET image=LOAD_FILE(/home/fleet/image.jpg) WHERE id=1; This produces exactly the same thing - no errors; but no data in the column. What am I missing? - fleet - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sum and Total Query
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 that customer service reps make. The reps place multiple orders per day for various products. I'm trying to pull a report that displays the customer service ID (csID), total number of a particular product sold, and the total of all products sold... within a date range. Sample Orders Table (heavily snipped): ORDER_ID CS_ID PRO_ID QTY_SOLD DATE - -- - 1 10 105 3 2006-07-08 2 12 105 4 2006-07-10 3 10 105 3 2006-07-10 3 10 120 2 2006-07-10 4 12 105 1 2006-07-11 When querying for the totals between July 8-July 11, the query should return something like: CS_ID PRO_ID PRO_TOTAL ALL_TOTAL - -- - - 10 105 6 8 10 120 2 8 12 105 5 5 I've tried various queries that work when I sum up individually, but when I include 2 sums for a row I'm getting duplicates and the sums are too high. This seems like it would be fairly straightforward but apparently I'm overlooking a key item. Oracle has a handy OVER() function that would work... Any thoughts? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help: PHP won't connect to MySQL
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. So I googled online and found out that I was missing php_mysql.dll and libmysql.dll. So I copied them into the C:\WINDOWS\SYSTEM32 folder. Then modified php.ini in the C:\WINDOWS by uncommented the php_mysql.dll extension and changed to extension_dir to C:\WINDOWS\SYSTEM32. Rebooted and now I'm getting the following error: PHP Warning: PHP Startup: Unable to load dynamic library 'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The specified procedure could not be found. in Unknown on line 0 I've checked the PATH in the System also, C:\WINDOWS\SYSTEM32 is there. So why does it work?? It's been a very frustrating day. Help anyone? Thanks. Kay
Review O'Reilly MySQL backup chapter?
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 experienced in backing up and recovering MySQL databases. Please reply via email. Thanks. (I've got a tight timeline, so please only reply if you think you can review a 10-page or so chapter very quickly.)