XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / mylinks - salvage rescue
Register
1
ukandrewf
mylinks - salvage rescue

  • 2007/2/4 22:54

  • ukandrewf

  • Friend of XOOPS

  • Posts: 198

  • Since: 2002/12/2


I have a site which was built to list cool software. I used the mylinks module to create the software database with ranks, comments etc.

My host (SpiderSaid.com) just vanished into thin air one day last july and I lost my whole site. I did have some backups but the site never restored properly.

I've now take the step of a fresh 2.0.16 install and then reinstalled the modules into this fresh install - but using the previousl sql database which has all the data. Some of this worked the forums for example are all back now.

I don't know enought about sql but i know the 3000+ software database is there but can't quite get it working in the new in stall. I suspect I need to move/rename/edit some of the tables to make it work but don't know which.

I suspect the mylinks data is somewhere:-

Quote:


xoops_groups
xoops_groups_system_link
xoops_groups_users_link 3,705
xoops_group_permission 365

or here

xoops_myh_act Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 3.0 KiB -
xoops_myh_cache Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_myh_cat Browse Structure Search Insert Empty Drop 152 MyISAM latin1_swedish_ci 10.2 KiB -
xoops_myh_gtu Browse Structure Search Insert Empty Drop 3,274 MyISAM latin1_swedish_ci 114.4 KiB -
xoops_myh_gtu_reg Browse Structure Search Insert Empty Drop 3 MyISAM latin1_swedish_ci 2.1 KiB -
xoops_myh_gtu_sm Browse Structure Search Insert Empty Drop 6 MyISAM latin1_swedish_ci 7.0 KiB -
xoops_myh_pd Browse Structure Search Insert Empty Drop 42 MyISAM latin1_swedish_ci 24.4 KiB -
xoops_myh_src

and should be here

xoops_mylinks_broken Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_cat Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_links Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_mod Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_text Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_votedata




can anyone help me fix this.

The other route is to examine the database backups and see if we can restore straight from them - maybe there's something simple wrong. When I try restoring from them I get a site but with no blocks - no login block and no users in db so can't access the site.

thanks in advance.

Andrew
2
tcnet
Re: mylinks - salvage rescue

  • 2007/2/5 5:17

  • tcnet

  • Friend of XOOPS

  • Posts: 297

  • Since: 2006/5/12


You can view the mylinks db dump by opening modules/mylinks/mysql/mysql.sql with notepad.

You can use myphpadmin (usually available in your host's control panel)to view the tables in your MySQL db.

Your db should contain these table names
mylinks_broken
mylinks_cat
mylinks_links
mylinks_mod
mylinks_text
mylinks_votedata

Hope this helps.
3
ukandrewf
Re: mylinks - salvage rescue

  • 2007/2/7 21:53

  • ukandrewf

  • Friend of XOOPS

  • Posts: 198

  • Since: 2002/12/2


thanks for the tip (and i wish i was in florida now ;)

the sql in the mylinks module wasn't that helpful but I did find a backup file I made just for the mylinks module which looks like this.

Quote:
-- phpMyAdmin SQL Dump
-- version 2.6.0-beta3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- 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`


SQL access visa MYsql Databases.

Do I simply import this backup? Anywhere? Anything I should know before it try it?
4
ukandrewf
Re: mylinks - salvage rescue

  • 2007/3/1 23:17

  • ukandrewf

  • Friend of XOOPS

  • Posts: 198

  • Since: 2002/12/2


I'm still struggling with this problem. I have a database backup of the tables i need for this module but can't seem to restore them correctly.

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

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

407 user(s) are online (316 user(s) are browsing Support Forums)

Members: 0

Guests: 407

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