mysql: read only (or something strange)

[raas]

Hi, after changing out my harddrive, mysql behaves a bit strang.

First:
I had a 500gb disc, divided into 2 partitions: 1 big for data/prog. (~499gb) and 1 small for swap (512mb) (made it, in case of my 256mb usb key burns out)

Now:
I have a new 500gb disk divided into 3 partitions 1 small for prog (~10gb), 1 small for swap (512mb) and 1 big for data (~489gb)

copied all from the 'old' disc to the 'new' disc with
cp -r /opt/* /mnt (had new disc mounted there temp..)

disconnected the old disk, connected the new disc, rebooted.

everything worked.. Content management system (using mysql) also.
but. when I log in to admin-site of CMS and want to update the page I get a ' this page cannot be displayed, DNS error'
First I thought of the CMS not functioning ok, but after loging into myphpadmin to directly update a record in the mysql db the same error message came up.

So I'm thinking, something is wrong in the rights of mysql, but I don't know what.

(strange thing is, I did the same when switching from an old 20gb drive to the 500gb disc with 2 partitions. then it worked ok.. now it doesn't ..)

I hope that anyone has some advice.

Thanks,

[raas]

hmm..

investigated a little more.
it seems I can execute select and delete commands, but no update or insert commands.

rights in myphpadmin seem ok, although i cannot alter them.
every time I get a dns error (from the web interfaces), but all the path are correct. .
I don't get it..
This was working ok, only after copy not anymore.

[raas]

Hi,

I switched from thttpd to lighttpd. now it all works again.