Moved from win to linux. Need help please :)

[Spaz]

Hi everyone.  I've set up a Mandrake 10 box, with Apache2, Php and MySQL installed.  Have an existing working install of coppermine running under win-xp with apache, php and mysql.

I've copied all website files/folders to the linux box.   I've copied all data files from mysql\data on win box to var\lib\mysql - the pics directory (the name of the database) and the ib_* files.

When pulling up the website, I get the normal theme loading, with the heading etc.  And it tells me "Critical Error : There was an error while processing a database query"

I assume I've missed a step somewhere.

Running mysql connects me to the database and I can query some mysql tables fine.  (Dont know any names of the coppermine tables).

So, database seems to be running, httpd and php seem to be running.

Can anyone help please?

[Joachim Müller]

never tried that before, but I guess the error lies in directly moving the sql file over - I'd rather create a dump on the win box and import it on the linux box.
Did you make sure the file include/config.inc.php has got the correct mysql access data. Try using a tool like phpMyAdmin to browse coppermine's config db table, and enable debug mode there. Then post the actual query that failed.

Joachim

[Spaz]

Problem fixed, thanks.

The config file was fine (used root/pw and I had kept them the same on both machines).   Running phpMyAdmin, and trying to update the config table gave me a "read only" error.  I reset the permissions on the database files, bounced the server and now it works.

Moving was very easy.  Install Mandrake 10 with apache2, mysql and php. No other config changes (told them to run at install time).  Copied all files/directories from win-webserver to lin-webserver.  copied all files and directories from win-mysql to lin-mysql.  Set permissions () And complete site up and running.

Thanks for you help

[Joachim Müller]

using root for your mysql operations is not recommended at all (security risk), as the root password resides in a file within your web path then. I strongly recommend setting up another account for mysql use only.

Joachim