
Quote:
#NAME?
-- version 2.6.0-beta3
-- http://www.phpmyadmin.net
--
#NAME?
-- Generation Time: Jul 15 2006 at 06:02 PM
-- Server version: 4.0.27
-- PHP Version: 4.3.9
--
-- Database: `andrew_xoops`
--
-- --------------------------------------------------------
--
-- Table structure for table `xoops_mylinks_links`
--
CREATE TABLE `xoops_mylinks_links` (
`lid` int(11) unsigned NOT NULL auto_increment
`cid` int(5) unsigned NOT NULL default '0'
`title` varchar(100) NOT NULL default ''
`url` varchar(100) NOT NULL default ''
`email` varchar(60) NOT NULL default ''
`logourl` varchar(60) NOT NULL default ''
`submitter` int(11) unsigned NOT NULL default '0'
`status` tinyint(2) NOT NULL default '0'
`date` int(10) NOT NULL default '0'
`hits` int(11) unsigned NOT NULL default '0'
`rating` double(6 4) NOT NULL default '0.0000'
`votes` int(11) unsigned NOT NULL default '0'
`comments` int(11) unsigned NOT NULL default '0'
PRIMARY KEY (`lid`)
KEY `cid` (`cid`)
KEY `status` (`status`)
KEY `title` (`title`(40))
) TYPE=MyISAM AUTO_INCREMENT=4484 ;
--
-- Dumping data for table `xoops_mylinks_links`
--
INSERT INTO `xoops_mylinks_links` VALUES (343 7 'Treepad: Personal Information Manager Organizer Word Processor PIM Search Engine Database 'http://www.treepad.com' 'nospam@freebyte.com' '' 549 1 1 0 0 0 0);
this should restore ok right (there's much more data this is just a sample for this forum.
I'm running phpmyadmin and running this backup as an sql script.
any ideaS?
Andrew