Hi!

I have a little problem. I am running XOOPS locally at my computer with MySQL 4.1. I want to export the database, because I want to use it on my Webspace, too. Unfortunately, there's only MySQL 4.0 available. I tried to export and import the database via Phpmyadmin, and I get the following error:

Error number: 1064
Error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax [....].

Is there a tool with which I can export the database AND convert it into the 4.0 Syntax? I am running Xampp under Windows. But if there are Linux tools, I can also export the database for running it under Linux and convert it there.

THX in advance