Re: Strange problem with mysqldump / automysqlbackup (ERROR 1300)

2009-11-20 Thread René Fournier
Yes, still exhibits this problem -- although at a different line in the file. (Seems random.) I should also mention, the backup is running across a local network. The machine the starts automysqlbackup (and internally, mysqldump) connects over TCP/IP to the database server. I am going to try run

RE: Strange problem with mysqldump / automysqlbackup (ERROR 1300)

2009-11-20 Thread Gavin Towey
Have you tried dumping that table manually using mysqldump on the command line to confirm it's not an issue with automysqlbackup? Regards, Gavin Towey -Original Message- From: René Fournier [mailto:m...@renefournier.com] Sent: Friday, November 20, 2009 8:31 AM To: mysql Subject: Strange

MySQL Community Server 5.0.88 has been released

2009-11-20 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.0.88, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts. The release is now av

Strange problem with mysqldump / automysqlbackup (ERROR 1300)

2009-11-20 Thread René Fournier
I've been using automysqlbackup 2.5 for years on a particular database, and it's always performed great. Recently, however, I've become encountering problems when trying to re-import one of its dumped sql files. (Not sure if it matters, but the database file in question is large and growing -- a

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
Don Thanks for your response. The issue I have is that the password for our database is stored either in the ODBC registry or within our ASP page as plain text. One option I have is to encrypt the password in the database connnection string and have a function with a key in a external file that

Re: Foreign Keys Problem

2009-11-20 Thread Victor Subervi
On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan wrote: > Hi Victor, > > It looks to me the foreign key syntax is wrong. Can you create the > Relationship table on your database by using below ddl? > > create table if not exists Relationship > (ID integer auto_increment primary key, > Parent integer not

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
I wondered if anyone else had any thoughts on this issue ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess wrote: > Tompkins Neil wrote: > >> Following my previous email. I've now configured my database connection >> using a ODBC DNSLESS SSL connection. However the problem still remains,

Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Wang Zi Feng
hi there, thanks for your reply. the mysql server is running on windows xp sp3, every time I use root user to log in. the command line i use for mysqldump is mysqldump --user=root --password=pass test>test.sql phpmyadmin is with following checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION /

Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Mark Goodge
Wang Zi Feng wrote: Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb