1
kruno
Table 'xoops_avatar' already exists - how to move to new server?
  • 2004/8/19 18:34

  • kruno

  • Just popping in

  • Posts: 10

  • Since: 2002/9/8 2


I have to move my site to new server. I use XOOPS 2.0.7. I've created backup with backup module.

I've downloaded backup to my computer.

On my new server I've installed XOOPS 2.0.7.

I've tried to restore data with phpMyAdim but I got this message:

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

MySQL message:

Table 'xoops_avatar' already exists

What should I do to transfer data from my old server to my new server?

Tnx.


Kruno

2
djsckizo
Re: Table 'xoops_avatar' already exists - how to move to new server?
  • 2004/8/19 18:39

  • djsckizo

  • Just can't stay away

  • Posts: 401

  • Since: 2003/5/9 8


it's trying to make a table that already exists because you reinstalled xoops. it's probably much easier to just dump the data from the database on the other server into the new one, and connect XOOPS to it.

3
kruno
Re: Table 'xoops_avatar' already exists - how to move to new server?
  • 2004/8/19 19:04

  • kruno

  • Just popping in

  • Posts: 10

  • Since: 2002/9/8 2


Done! I've dumped the dat in empty database and it works now... Tnx!

Kruno

Login

Who's Online

54 user(s) are online (18 user(s) are browsing Support Forums)


Members: 0


Guests: 54


more...

Donat-O-Meter

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

Latest GitHub Commits