Re: Backup problem from 5.0 to mysql 4.1

2006-07-18 Thread Stefan Hornburg
Amir Bukhari wrote: -Original Message- From: Addison, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 1:22 PM To: Amir Bukhari; mysql@lists.mysql.com Subject: RE: Backup problem from 5.0 to mysql 4.1 From: Amir Bukhari Sent: 18 July 2006 09:23 I have local mysql 5.0

Re: Speedup of database changes

2006-07-11 Thread Stefan Hornburg (Racke)
Brent Baisley wrote: > There will always be new requests, but many times you can store data > "vertically" in rows instead of "horizontally" in columns. You would > need a "label" column to indicate what type of data the row contains. > It's more work on the front end, but a lot more flexible. It's

Re: Speedup of database changes

2006-07-11 Thread Stefan Hornburg
Brent Baisley wrote: Changes to the database structure should be few a far between. If you are finding you need to change the structure regularly, you should probably look at a redesign. This customer regularly request new things, so I cannot avoid changes to the database structure. MyISAM

Speedup of database changes

2006-07-11 Thread Stefan Hornburg
Hello, one of my customers has a database with about 1.7 million records (52 fields, almost 1GB on amd64, MyISAM). This database is running on Debian sarge with MySQL 4.0.24. Changing the database structures and also large set of inserts/deletes take too long to be acceptable on a productions s

Re: Problem with INSERT

2006-07-03 Thread Stefan Hornburg
Duane Hill wrote: Can someone either answer or point me somewhere for the answer? I am attempting to store text lines from an e-mail message into a MySQL table through the use of Perl and DBI. Periodically I get the error that states there was an error in the statement and to check the syntax.