mysqldump access denied error

2005-01-17 Thread Tait Sanders
- I connect fine. Does anyone have any suggestions?? thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
yes the user can see the databases with 'show databases;' I was thinking that there might be a permissions issue... but it doesn't seem so. thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 9726 australia e

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
be the problem with the password here? I really want to include the password in the script as I don't want to be prompted for it at say 3 in the morning when cron runs it. thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith

SOLVED:RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
denied for user ' [EMAIL PROTECTED]' (Using password: YES) when trying to connect When I log into mysql - user#mysql -u user -p password - I connect fine. Does anyone have any suggestions?? thanks, tait tait sanders computer support technician element IT services information services gold

mysqldump error

2004-03-21 Thread tait sanders
password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02

Re: mysqldump error

2004-03-21 Thread tait sanders
mtweblog BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog

Re: can't install DBI on panther

2004-01-27 Thread tait sanders
Folly wrote: On 27 Jan 2004, at 00:37, tait sanders wrote: i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back reporting heaps of errors like the following: from Perl.xs:1: /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 380:30: sys/types.h: No such file

can't install DBI on panther

2004-01-26 Thread tait sanders
OS10.3?? please help ta tait On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote: i've never used MT, but this kinda sounds as if you dont have the DBI installed: $ perl -MCPAN -eshell install DBI cheers, M. tait sanders wrote: hi all, not sure if this is the appropriate place

Re: can't install DBI on panther

2004-01-26 Thread tait sanders
gd_jpeg.Plo in the .deps directory. I'm sorry, I don't know what a .Plo or .lo file is. The .Plo file just contains #dummy. This is a bit off-topic from mysql or the original question, I'm afraid. tait sanders wrote: i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back

unsupported driver trouble

2004-01-20 Thread tait sanders
the following error: Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC... I've checked in my mt.cfg file and I have added: ObjectDriver DBI::mysql Database /var/mysql/mtweblog DBUser labadmin so I don't understand what's going on. please help ta tait tait sanders computer

mysql will not start

2004-01-18 Thread tait sanders
the DNS name. i.e. 'media' instead of 'media.arts.unsw.edu.au'. The article goes on to explain that this 'prevents the database from being created'. It has the fix. just wanted to post it here as someone might find it useful. ta tait tait sanders computer technician sir robert webster bldg trc

newbie - connect error

2004-01-15 Thread tait sanders
database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw

Re: newbie - connect error

2004-01-15 Thread tait sanders
to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start

Re: newbie - connect error

2004-01-15 Thread tait sanders
'mysql_config --socket' to recreate it. this produces a new mysql.sock but then trying to start mysql produces the error of before. can i uninstall mysql rather than deleting it. I've tried the 'rpm' utility but it's not on my os. thanks heaps for all your help. ta tait tait sanders computer