1
DobePhat
News Db files deleted?Restore!FIXED
  • 2003/11/9 3:55

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


MAN oh man Im an idiot!
I uninstalled my news module...reinstalled it and all my data with reference to the News module got deleted.

Fortunately I have a a Backup of sorts...I had exported from MYsql the data and tables awhile ago.....

I sifted through the very long text file and isolated the three areas I absolutely need...and created three seperate text files for import....
xoops_topics
Xoops_stories
Xoops_spotlight
Unfortunately MySQL front says I cant do it ref: an ini file...(im using ver3.23)

How can I import this important data back?
I use MySQL FRONT.

Any help would be great even I have to use myphpadmin...
Thank you ....


It says I need to upgrade to 2.26? mysql...can this be done without problems? I'm totally lost.....

2
Catzwolf
Re: HELP! Please :) News Db files deleted!!Restore!
  • 2003/11/9 6:31

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Hi DobePhat,

You will have to import them via the 'SQL Insert' Box.

You will have to copy and paste all the tables and information for the news module again to get the above to work correctly.

You should have something like this:

#
# Table structure for table `xoops_wfslinktous`
#

CREATE TABLE xoops_wfslinktous (
submenuitem int(10) NOT NULL default '10',
textlink varchar(255) NOT NULL default '',
linkpagelogo varchar(255) NOT NULL default '',
button varchar(255) NOT NULL default '',
logo varchar(255) NOT NULL default '',
banner varchar(255) NOT NULL default '',
mainpage int(10) NOT NULL default '1',
newsfeed int(10) NOT NULL default '0',
texthtml varchar(255) NOT NULL default '',
titlelink varchar(255) NOT NULL default '',
textlinkhtml varchar(255) NOT NULL default '',
buttonhtml varchar(255) NOT NULL default '',
logohtml varchar(255) NOT NULL default '',
bannerhtml varchar(255) NOT NULL default '',
newsfeedjs mediumint(10) NOT NULL default '0',
newstitle varchar(255) NOT NULL default '',
PRIMARY KEY (submenuitem)
) TYPE=MyISAM;

#
# Dumping data for table `xoops_wfslinktous`
#

INSERT INTO xoops_wfslinktous VALUES (1, 'http://localhost', 'linktous.png', 'poweredby.gif', 'logo.gif', 'xoops_banner.gif', 1, 1, '', 'Link to us', '\'><{$linktous.textlink}>', '\' target=\'_blank\'>/<{$linktous.path}>/<{$linktous.button}>\' alt=\'<{$linktous.sitename}>\'>', '\' target=\'_blank\'>/<{$linktous.path}>/<{$linktous.logo}>\' alt=\'<{$linktous.sitename}>\'>', '\' target=\'_blank\'>/<{$linktous.path}>/<{$linktous.banner}>\' alt=\'<{$linktous.sitename}>\'>', 1, '');


Just copy this and paste it into the SQL Insert box and that should restore your previously backed up information.

Remember for this to work, you will have to 'keep' the pefix at the start of each table

ie xoops_newstory and nit newstory

Hope this helps


3
DobePhat
Re: HELP! Please :) News Db files deleted!!Restore!
  • 2003/11/9 16:47

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


thanks...
things seem to be working
I need to learn PHPmyadmin better it seems pretty vaulable but also a little risky.

I was able to import the text files I created (from the exported file I had made as backup) into mysql, and execute them!

I hope this was the right thing to do...it seemed surprisingly easy, I guess I had the right kind of Back-up

It appears to be working, it was a rollback of sorts...of course but easy to update!
Thanks again for looking into this Catz!

Login

Who's Online

357 user(s) are online (109 user(s) are browsing Support Forums)


Members: 0


Guests: 357


more...

Donat-O-Meter

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

Latest GitHub Commits