1
boxkeeper
Site moved to different server, database problems!
  • 2006/2/20 18:56

  • boxkeeper

  • Just popping in

  • Posts: 28

  • Since: 2005/1/29


Hi,

My website has recently been moved to another server by my ISP. If i try to create a database called XOOPS the following message appears: XOOPS already exists on this server... grrrrrrrrrr
(can u believe this, my friend is on the same server)!!

So, i made a database called: boxkeeper.
Offcourse restoring my backup database isn't working.

What can i do to fix this problem?

I have a file called: boxkeeper.sql

Plz help my site really has been down to long....

ps. I found that he had the same problem: https://xoops.org/modules/newbb/viewtopic.php?topic_id=37344&viewmode=flat&order=ASC&start=0

Only i'm not able to make a backup b'cause my site don;t longer excist.

2
gestroud
Re: Site moved to different server, database problems!
  • 2006/2/20 19:06

  • gestroud

  • Home away from home

  • Posts: 1538

  • Since: 2004/12/22


Aren't you able to go into phpmyadmin and drop the XOOPS tables?

3
boxkeeper
Re: Site moved to different server, database problems!
  • 2006/2/20 19:21

  • boxkeeper

  • Just popping in

  • Posts: 28

  • Since: 2005/1/29


No, b'cause I can't even create a database called Xoops. Before my site was moved i made a total backup.
My database name was Xoops.

When i make a database (called boxkeeper) in phpmyadmin and try to upload my boxkeeper.sql the system returns this error:

SQL-query:

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` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =164

4
Bender
Re: Site moved to different server, database problems!
  • 2006/2/20 21:41

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


You did only post the querrie that was not accepted but did leave out the actual error message.

Could be a MySQL version problem. Which MySQL version is installed on that server?

How big is the database file?
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

5
boxkeeper
Re: Site moved to different server, database problems!
  • 2006/2/21 9:11

  • boxkeeper

  • Just popping in

  • Posts: 28

  • Since: 2005/1/29


Thank you for the reply...

We fixed the error problem. Looked like the server couldn't handle this line:

ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =164;

We changed it to:

TYPE = MYISAM AUTO_INCREMENT =164;

But now when i call my site (from the browser) -> http://www.boxkeeper.nl i get a blank page.
Are there more files/tables that need to be edited?


For your info:
My new database is called Boxkeeper (used to be xoops).
The password for the database admin has changed.
The tablenames start with with xoops_ (eg. xoops_avatar)

Hope u can help!

6
boxkeeper
Re: Site moved to different server, database problems!
  • 2006/2/21 10:10

  • boxkeeper

  • Just popping in

  • Posts: 28

  • Since: 2005/1/29


Finaly it works!!!!!!!!!!!!!!!!!!!!!!!

The virtual path was incorrect.

After correcting this, this site up again!


Thanx to anyone who helped!!!

Login

Who's Online

94 user(s) are online (25 user(s) are browsing Support Forums)


Members: 0


Guests: 94


more...

Donat-O-Meter

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

Latest GitHub Commits