This page looks plain and unstyled because you're using a non-standard compliant browser. To see it in its best form, please upgrade to a browser that supports web standards. It's free and painless.

Paul's Time Sink

| Main | Albums |

Moving mysql database

Paul Westbrook | 07 January, 2006 22:35

In the process of moving to a Fedora Core 2 server, I have had to move some databases from one machine to another.  At first, I tried to just copy the database files, and then restart mysql.  This didn't work.  I then realized that Fedora Core 2 has version 3.23 of mysql, while Fedora Core 4 has version 4.1.

I then tried to run mysqldump, and then run that .sql file on Fedora Core 2, but I kept getting messages like this:

ERROR 1064 at line 21: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 11

I was able to work around this by removing the "ENGINE=MyISAM DEFAULT CHARSET=latin1" string from each of the CREATE TABLE commands.  I knew that this wouldn't cause a problem since in mysql version 3.23 and later MyISAM was the default engine type.

Technorati Tags: ,

Computer :: Comment (0) :: Permalink :: Trackbacks (0)

Configuring cyrus imapd

Paul Westbrook | 07 January, 2006 20:31

It has been a long time since I configured cyrus imap.  I found these instructions that worked pretty well.

Also, a while ago I posted some instructions that I used to setup ssl for imap.  I just found that the cyrus-imapd rpm includes a Makefile that can create the ssl certs.

Technorati Tags:

Computer :: Comment (0) :: Permalink :: Trackbacks (0)

building db4 for Fedora Core 2

Paul Westbrook | 07 January, 2006 18:52

I am in the process of setting up a VPS to host my web and mail server.  With Tektonic, the latest version of Fedora that is available is Fedora Core 2.  The version of db4 that was included with Fedora Core 2 had a problem with non Intel CPUs.  Bug 91933 at Red Hat's Bugzilla system describes this problem.

This bug report also has a work around.  It requires rebuilding db4 with
spec file that doesn't use posix mutexes.

Here is the spec file

Here is a patch file

Here is a needed wrapper script.

Technorati Tags: ,

Computer :: Comment (0) :: Permalink :: Trackbacks (0)
Powered by LifeType
Design by Book of Styles