Support Forums - All Posts - XOOPS Web Application System

121

Need True Xoops Expert...

2005/7/28 11:55
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

So... I screwed up my XOOPS website trying to upgrade to upgrade to 2.2 While attempting a recovery my webserver company crashed and burned and I've had to completely start over.

That being said, I had created a back up of my SQL database shortly before the fall.

I would like to recover 3 things from this database:

1.) My user/passwords list
2.) Past articles written
3.) Forum History

I would think recovering the username/password file would be the easiest since I didn't make any changes to the format or structure of them.

The old articles were written using the "news" module, which I have jetison in the rebuild instead going with "article" module. I also have changed the catogory descriptions, so I'm assuming this isn't going to be an easy recovery... any ideas ?

Lastly.. the forum (while still the default XOOPS newbb) I've completely changed the forum names... any chance of recovery here ?

Any assistance would be GREATLY appreciated !

Patrick

122

Re: I screwed up bad.. HELP !

2005/7/25 12:33
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

I am getting these instructions from my hosting company, but they don't seem to work:

It is possible to modify the current installation to work on this server without resinstalling. You simply have to check the config files that were created during the initial install to reflect the new username.

To reinstall, you would do the following:

-backup your database so you don't lose data, this can be done with cpanel->backups, click on the database name to download it

-remove XOOPS installation

-reinstall using Fantastico (or manual, although Fantastico is easier)

-reupload your database, you may have to manually add the database entries to your new database using these steps :

(1) Create a MySQL database in cpanel (this is already done by xoops, skip)
(2) Login to phpmyadmin (bottom cpanel MySQL page)
(3) Once in phpmyadmin, click on the database
(4) Click on SQL (top menu)
(5) Open your MySQL database file with notepad (the backup you downloaded to your local machine)
(6) copy a 1mb or smaller peice of the database
(7) paste what you copied in the sql dump text field
(8) repeat process, breaking database into small peices, pasting one peice at a time, starting each peice on a new line.

This is how to popular a large MySQL database.

123

Re: I screwed up bad.. HELP !

2005/7/20 22:08
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

I am way over my head...

I tried to copy the backup copy of the mainfile.php back and that just made the whole website non-accessible.

I have not figured out how to restore the backed up copy of the database I have.

I thinking this is just going to be a complete loss.

124

Re: I screwed up bad.. HELP !

2005/7/18 18:36
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

Herko,

I'm afraid that since I also erased the xoop.sql database, that even if I restore the mainfile.php, I'll need to also restore the database before I get everything back ?

Patrick

125

Help Restoring Database ?

2005/7/18 18:17
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

I think I screwed up bad.. and I'm looking for help.

I tried to upgrade to the newest version of Xoops, but I did something wrong..

So when I tried to load the website, an installation page came up, I followed the instructions and through this process (not exactly sure how) everything which existed in my old website got lost.

I tried to recover by reverting back to the old version of Xoops.. but that didn't help either.

Now... as luck would have it.. I did create a back up before I managed to screw everything up.. but several attempts at reinstalling the back up have failed.

At this point, I'd like to just save back my orginal .sql database (to get my users list, forum archive, story archive) back active...

Is this possible ?

Anyone have any ideas ??

Any help would be appreciated.

Patrick

126

I screwed up bad.. HELP !

2005/7/18 17:11
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

I think I screwed up bad.. and I'm looking for help.

I tried to upgrade to the newest version of Xoops, but I did something wrong..

So when I tried to load the website, an installation page came up, I followed the instructions and through this process (not exactly sure how) everything which existed in my old website got lost.

I tried to recover by reverting back to the old version of Xoops.. but that didn't help either.

Now... as luck would have it.. I did create a back up before I managed to screw everything up.. but several attempts at reinstalling the back up have failed.

At this point, I'd like to just save back my orginal .sql database (to get my users list, forum archive, story archive) back active...

Is this possible ?

Anyone have any ideas ??

Any help would be appreciated.

Patrick

127

Re: Sports Community Website -- Requesting Review

2005/6/29 1:37
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

Glad to see the Spartan Nation is alive and well !!

I'm sure even if you never set foot inside Spartan Stadium (or Breslin or Munn either) you still wear GREEN on Saturday's and I'm sure you'll email all your Spartan alumni friends and tell them to visit lansingsportsrage.com !

128

Re: Sports Community Website -- Requesting Review

2005/6/28 0:18
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

RC -- that's some good advice.. I'm going to move the menu up some and move the calendar & events closer together.

The Welcome Page I don't know how to work with... I want the welcome page to appear to new users who aren't registered, thus it needs to be on the home page.

How can I make the block visible to unregistered new users and not visible to members ?

129

Re: Sports Community Website -- Requesting Review

2005/6/24 16:30
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

Thanks guys..

I agree with you about the flash.. I think most repeat visitors just bookmark the home page and jump past the flash on follow up visits.

We struggled with the decision to make the site viewable to unregistered viewers... but we make the call that since we are suppose to be a "community" and since registeration is free (and its only a 2 line form) that it would be that big of deal.

If a person can't invest 15 seconds into registering then they aren't really joining our community anyhow..

I hope you used the guest membership I created (see above post) to gain entry for yourselves --

Thanks to all who like the layout.. I think our site looks a little bit different then the standard XOOPS site and I'm hoping you all will like it too.

Patrick

130

Re: Sports Community Website -- Requesting Review

2005/6/24 4:46
pmcnamara
Friend of XOOPS
Posts: 147
Since: 2004/12/3

41 views and not one comment ?

Ouch.

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Need True Xoops Expert...

Re: I screwed up bad.. HELP !

Re: I screwed up bad.. HELP !

Re: I screwed up bad.. HELP !

Help Restoring Database ?

I screwed up bad.. HELP !

Re: Sports Community Website -- Requesting Review

Re: Sports Community Website -- Requesting Review

Re: Sports Community Website -- Requesting Review

Re: Sports Community Website -- Requesting Review

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}