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.

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

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

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?

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!

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

The virtual path was incorrect.

After correcting this, this site up again!


Thanx to anyone who helped!!!