We fixed the error problem. Looked like the server couldn't handle this line:
ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =164;
We changed it to:
TYPE = MYISAM AUTO_INCREMENT =164;
But now when i call my site (from the browser) -> www.boxkeeper.nl i get a blank page.
Are there more files/tables that need to be edited?
For your info:
My new database is called Boxkeeper (used to be xoops).
The password for the database admin has changed.
The tablenames start with with xoops_ (eg. xoops_avatar)
Hope u can help!