Getting rid of the intial comments in the .SQL file (or changing them back to the older comment character) prior to importing might be worth a try.

SQL-query:


-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
--http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 14, 2004 at 12:26 PM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
--
-- Database: `docuwedd_docuwedd`
--
-- --------------------------------------------------------
--
-- Table structure for table `xoops_avatar`
--
-- Creation: Feb 01, 2004 at 05:59 PM
-- Last update: Dec 14, 2004 at 11:28 AM
-- Last check: Dec 14, 2004 at 11:28 AM
--
DROP TABLE IF EXISTS `xoops_avatar` ;

CREATE TABLE IF NOT EXISTS `xoops_avatar` (
`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
) TYPE = MYISAM AUTO_INCREMENT =1


MySQL said:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'avatar_id` mediumint(8) unsigned NOT NULL auto_increment,
  `av

"It has become necessary for us to enable Safe Mode for PHP on your server. Safe Mode adds many security features to PHP that we unfortunately can no longer operate without. It was necessary for us to enable safe mode as a matter of urgency to prevent any potential further disruption to service for our clients.


Having looked into this it appears that you are running the xoopsgallery module and unfortunately this has not been coded to work in environments where safe mode is enabled. Therefore unless there are modifications for xoopsgallery to enable it to work in a safe mode environment, and for example to make use of PHP's built in GD image manipulation functions, it will not be possible to run your current gallery software on our servers."

We do of course understand that this causes problems for your script and we apologise for any inconvenience that this will cause, however unfortunately we are not going to be able to change the current setup to allow this functionality again. The changes that we have made are for
the increased security of your server and are vital for us to be able to continue to provide a secure and reliable environment for all of our clients."