Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

What has happened? vi.recover ? and database disappeared?

Jun 12, 2002, 7:38 AM
cuppa
User (78 posts)
Jun 12, 2002, 7:38 AM
Post #1 of 7
Views: 2238
Shortcut
Quote Reply
What has happened? vi.recover ? and database disappeared?
hi Everyone

I used the search engine, driven by Links SQL, at my site and got this message

----------
A fatal error has occured:


Unable to query database: Could not connect to database. Reason: Unknown database 'the3gportal'

Please enable debugging in setup for more details.
------------

Errr?

I went to admin to try and re-build and got this message
-------

Building Category pages ...

A fatal error has occured:

Can't call method "prepare" without a package or object reference at /home/the3gportal.com/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 36.

Please enable debugging in setup for more details.

Can't call method "prepare" without a package or object reference at /home/the3gportal.com/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 36.

----

I went to look for my database in the SQL List and saw this but not my database

-----------
vi.recover

----------

I have no idea how this happened, even less to know how to recover.

Any suggestions with regards both points. Thanks!


Steve
the3Gportal.com
Jun 12, 2002, 7:46 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 12, 2002, 7:46 AM
Post #2 of 7
Views: 2162
Shortcut
Quote Reply
Re: [cuppa] What has happened? vi.recover ? and database disappeared? In reply to
Looks like your database has been deleted, or your user permissions have been changed Frown

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 12, 2002, 9:12 AM
cuppa
User (78 posts)
Jun 12, 2002, 9:12 AM
Post #3 of 7
Views: 2161
Shortcut
Quote Reply
Re: [Andy] What has happened? vi.recover ? and database disappeared? In reply to
Thanks for the previous post - the database isn't deleted and the news is GOOD. Nothing to do with LINKS SQL. The hosting company said they had restarted mysqld. And that fixed it it. Boy was I feeling suicidal!

I must ask them what restarting mysqld means. And why did it need re-starting? Anyone want to give me an idea about what they did?

Thanks

Steve Sly
the3Gportal.com
Jun 12, 2002, 9:15 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 12, 2002, 9:15 AM
Post #4 of 7
Views: 2176
Shortcut
Quote Reply
Re: [cuppa] What has happened? vi.recover ? and database disappeared? In reply to
mysqld is the MySQL server basically. It is what all the serving to the websites is done via. If that crashes, then weird stuff heppens to your site. Restarting it can also help to unclog 'unclosed' MySQL connections (which unfortunatly a lot of people still seem to do...Frown).

Well, I think/hope I'm right!

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 12, 2002, 9:37 AM
Alex
Administrator (9387 posts)
Jun 12, 2002, 9:37 AM
Post #5 of 7
Views: 2160
Shortcut
Quote Reply
Re: [cuppa] What has happened? vi.recover ? and database disappeared? In reply to
Hi,

Most likely MySQL died, and somebody manually started it up incorrectly, so that it's database directory was pointing to the wrong area (it could not longer find all the databases). To fix, they just started it up properly.

Cheers,

Alex
--
Gossamer Threads Inc.
Jun 12, 2002, 9:38 AM
Paul
Veteran (19537 posts)
Jun 12, 2002, 9:38 AM
Post #6 of 7
Views: 2159
Shortcut
Quote Reply
Re: [cuppa] What has happened? vi.recover ? and database disappeared? In reply to
mysqld is the mysql daemon.

There are a few reasons for needing to restart the daemon..it's nothing to worry about (unless they are restarting a lot)
Jun 12, 2002, 8:32 PM
cuppa
User (78 posts)
Jun 12, 2002, 8:32 PM
Post #7 of 7
Views: 2138
Shortcut
Quote Reply
Re: [Paul] What has happened? vi.recover ? and database disappeared? In reply to
Thanks for the all the information, I understand better what happened. It was the first time in 2 years of being with this hosting company it has happened. They have been forgiven :-)

Cheers
Steve
the3Gportal.com