1
Hi All,
I know this has been covered before, but I just can't seem to find anyone with the same stumbling block.
I have been hosting my XOOPS site on my own server, and as my ISP offers 50MB of webspace and 1 free MySQL database as a part of my internet account I wanting to duplicated my existing XOOPS site to my ISP's servers (with a slightly different URL) for testing.
I've managed to install XOOPS without too much trouble, and as I've only got the 1 MySQL database to work with I've installed the XOOPS version of the PHPMyAdmin 2.5 module. It is somewhere here that I miss something.
I use MySQL-Fron 2.5 to do a full export of my database (structure and data) to an SQL file. I then goto the SQL tab of PHPMyAdmin in my new XOOPS site and select to run this SQL file. However, it seems that it only tries to import the first table then quits with the follwing errors:
Quote:
Error
SQL-query :
CREATE TABLE `wfs_article` (
`articleid` int( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`categoryid` int( 8 ) unsigned NOT NULL default '0',
`uid` int( 5 ) NOT NULL default '0',
`title` varchar( 255 ) default NULL ,
`maintext` text NOT NULL ,
`counter` int( 8 ) unsigned NOT NULL default '0',
`created` int( 10 ) NOT NULL default '0',
`changed` int( 10 ) NOT NULL default '0',
`nohtml` tinyint( 1 ) NOT NULL default '0',
`nosmiley` tinyint( 1 ) NOT NULL default '0',
`summary` text NOT NULL ,
`url` varchar( 255 ) NOT NULL default '',
`page` int( 8 ) unsigned NOT NULL default '1',
`groupid` varchar( 255 ) default NULL ,
`submit` int( 10 ) NOT NULL default '1',
`published` int( 10 ) NOT NULL default '0',
`expired` int( 10 ) NOT NULL default '0',
`notifypub` tinyint( 1 ) NOT NULL default '0',
`type` varchar( 5 ) NOT NULL default '',
`ishtml` int( 10 ) NOT NULL default '0',
`htmlpage` varchar( 255 ) NOT NULL default '',
`rating` double( 6, 4 ) NOT NULL default '0.0000',
`votes` int( 11 ) unsigned NOT NULL default '0',
`hits` int( 11 ) unsigned NOT NULL default '0',
`urlname` varchar( 255 ) NOT NULL default '',
`offline` int( 10 ) NOT NULL default '0',
`weight` int( 4 ) NOT NULL default '1',
`noshowart` int( 10 ) NOT NULL default '0',
PRIMARY KEY ( `articleid` ) ,
KEY `categoryid` ( `categoryid` ) ,
KEY `uid` ( `uid` ) ,
KEY `changed` ( `changed` )
) TYPE = MYISAM AUTO_INCREMENT = 1
MySQL said:
Table 'wfs_article' already exists
I have even tried dumping from PHPMyAdmin on my main site incase it was something to do with the SQL file the MySQL-Front created. I can't think for the life of me what it is that I'm doing wrong, as I've migrated databases between sites before, just never between servers.
Anyone got any ideas?