Re: copy blob between tables may get in consistent data?

See Thread at: http://www.techienuggets.com/Detail?tx=78262 Posted on behalf of a User I have no problems in copying MEDIUMBLOB type data from one table to another. Under either 5.0 or 5.1 community editions. In Response To: hi, I found this: http://bugs.mysql.com/bug.php?id=34300 in the

Upgrading MySQL from 5.0 to 5.1

See Thread at: http://www.techienuggets.com/Detail?tx=78654 Posted on behalf of a User This has proved to be quite challenging. I wasn't able to do the upgrade and basically created another instance of 5.1 and took a backup of my database from 5.0 and restored it to 5.1. Then added all my users

Re: Replication error 1236

See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of a User HI, first check the error log and find the position where the replication was terminated.Now run the mysqlbinlog utility on the binarylogs file. Now when you run the query will get the text format as a result

Typical Maintenance for InnoDB Tables

See Thread at: http://www.techienuggets.com/Detail?tx=48414 Posted on behalf of a User I have a MySQL 5.0 InnoDB database that's about 1 GB in size so it's still pretty tiny. Is there any performance enhancement maintenance that should be done on the tables? I do a weekly Optimize through the M

Re: Moving Database from Windows to Linux

See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of a User Because of the fundamental difference between binary data files under Windows and under Linux. In Response To: At 07:09 PM 6/26/2008, you wrote: >See Thread at: http://www.techienuggets.com/Detail?tx=42035

Moving Database from Windows to Linux

See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of a User Hi, I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized database that I'd like to move from a Windows 2000 based server to a Linux server. What's the best way to do this? I normally ta

Re: A SQL Query Question

See Thread at: http://www.techienuggets.com/Detail?tx=32975 Posted on behalf of a User select userId, picture, MAX(datePosted) from A order by datePosted; In Response To: Hello everyone, I have a table A: userId long picture MeduimBlob datePosted DateTime A userId can have many pictures

A SQL Query Question

See Thread at: http://www.techienuggets.com/Detail?tx=32975 Posted on behalf of a User Hello everyone, I have a table A: userId long picture MeduimBlob datePosted DateTime A userId can have many pictures posted. I want to write a query that returns a distinct userId along with the most recent

Re: Server Crash

See Thread at: http://www.techienuggets.com/Detail?tx=24273 Posted on behalf of a User Help! I'm still facing this problem. I can run a check error successfully but when I try to dump the database using MySQL Administrator halfway through one table the server crashes. See message at the end. I

Server Crash

See Thread at: http://www.techienuggets.com/Detail?tx=24273 Posted on behalf of a User Hi I'm running 5.0.51a on Windows machine. The server crashes with: 080210 15:56:38 InnoDB: Page checksum 2545965801, prior-to-4.0.14-form checksum 1667729874 InnoDB: stored checksum 1195984440, prior-to-4.0