I have several backups of my website's database.
I was able to import from one of my backups, but I have a problem importing the two newer ones.
Apparently it has some sort of a problem with data about liasie module. It says something about a NULL string.
Why does that happen? and how can I fix this?
Thank you.

what exacly "it" says?
see on the structure of database!
I allays export it via MySQL database nor XOOPS backup.
Than before import to new one I delete some lines on the begoinign (that says about database name etc).

Well, This time the error was different.

"Error
SQL query:

# Backup for MySQL
#
# --------------------------------------------------------
#
# Table structure for table dif_avatar
#
CREATE TABLE dif_avatar(

avatar_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
avatar_file varchar( 30 ) NOT NULL ,
avatar_name varchar( 100 ) NOT NULL ,
avatar_mimetype varchar( 30 ) NOT NULL ,
avatar_created int( 10 ) DEFAULT '0' NOT NULL ,
avatar_display tinyint( 1 ) unsigned DEFAULT '0' NOT NULL ,
avatar_weight smallint( 5 ) unsigned DEFAULT '0' NOT NULL ,
avatar_typechar( 1 ) NOT NULL ,
PRIMARY KEY ( avatar_id ) ,
KEY avatar_type( avatar_type, avatar_display )
);



MySQL said:

#1050 - Table 'dif_avatar' already exists

"

What does this error mean?

Hi,

as it says the table exists and can not be created. You may delete it (drop it).
It may also be a good idea to make a new backup before deleting table(s)!

Or you can edit your sql backup and delete the lines


and import only data.

I have tried a "clean" database import.
I imported into a new database.
However, I get an error, and if I comment the lines with this error, I get another error and etc.
The error is:

"
#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 'form_title varchar(255) NOT NULL,
form_submit_text varchar(50) NOT NULL,
' at line 1

"