mysqld problem

I am having difficulty stopping and starting my mysql server. The mysqld is currently running as all of the client machines can access the database. If I try to invoke the mysql command from the server box (linux 7.2) I get the following - error: 'Can't connect to local MySQL server through

RE: mysqld problem

2003 14:31 To: Mark Colvin Cc: MySQL Mailing List (E-mail) Subject: Re: mysqld problem Pick/Create a different directory. Make it owned by mysql:mysql, and set it mode 775. Mysqld can not write to /usr/local/bin. Mark Colvin wrote: I am having difficulty stopping and starting my mysql server

RE: mysqldump query

I should have been more specific in my previous post. I am actually after the syntax to get the data out of a table and into a file. I couldn't quite work this out from the stuff I read in the manual. mysql This e-mail is intended for the

mysqldump query

I would like to export the full contents of one particular table in a database to a csv file once every day. I will then email this file I am running MySQL 3.21 on a RedHat 7.2 server. Is there an automated way of doing this? This e-mail is

MySQL Left Join Query

I have a two table query where I want to return records from the first table and if they have corresponding details in my second table I wish to return those as well. A sample sql statement I am using is as follows: select decheader.code, decheader.height, decheader.width, decplacement.position,

MySQL Left Join Problem

I am having some problems seeing posts to the list so if anyone has already received this mail I apologise. Anyway, I have a two table query where I want to return records from the first table and if they have corresponding details in my second table I wish to return those as well. A sample sql

MySQL Left Join Query

I have a two table query where I want to return records from the first table and if they have corresponding details in my second table I wish to return those as well. A sample sql statement I am using is as follows: select decheader.code, decheader.height, decheader.width, decplacement.position,

RE: MySQL Left Join Query

An update to my earlier post. I'm getting a bit closer but still not there. In the following query: select decheader.code, decheader.height, decheader.width, decplacement.position, decplacement.product from decheader left join decplacement on decheader.code = decplacement.code and (decheader.code

DATE_FORMAT PROBLEM

I run the following query from a php script - select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock, d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price, d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr, d1.usr, d1.cusname, d1.colours, d1.stitchcount,

Changing datatypes

Can I change the data type of a column in a table from varchar(10) to smallint(5) unsigned zerofill. The column that is set to varchar(10) is populated with values from a primary key column in another table that has a datatype smallint(5) unsigned zerofill and I need to make them both the same. I

Select Problem

I want to select from three tables where there may or may not be a record in the third table. Table 1 and 2 have a one to one relationship and table 1 and 2 both have a one to many relationship with table three. All three tables have a column called 'code' and I want to select where code is in