1
Sargon
Database backup restore problem
  • 2008/6/27 16:14

  • Sargon

  • Just popping in

  • Posts: 21

  • Since: 2008/4/26


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.

2
red_Slider
Re: Database backup restore problem

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).

3
Sargon
Re: Database backup restore problem
  • 2008/6/28 10:02

  • Sargon

  • Just popping in

  • Posts: 21

  • Since: 2008/4/26


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?

4
stefan88
Re: Database backup restore problem
  • 2008/6/28 20:49

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


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
CREATE TABLE ****(

...

);


and import only data.
..

5
Sargon
Re: Database backup restore problem
  • 2008/6/29 18:49

  • Sargon

  • Just popping in

  • Posts: 21

  • Since: 2008/4/26


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

"

Login

Who's Online

170 user(s) are online (126 user(s) are browsing Support Forums)


Members: 0


Guests: 170


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits