MySql Lost...

[Robert Brockway]

On Mon, 24 Jan 2005, Lance F. Squire wrote:

> It appears that a server someone else set-up has lost one of it's MySql 
> databases.
>
> Some time back, they set-up a Tomcat server talking to MySql using a database 
> called Library.
>
> Today MySql reports no such DB...

Can you login to mysql using the username/password that your app is using?

eg:

mysql -u bob -p

See if you can see the database:

show databases;

If so, try to go into the database:

use yourdatabasename;

If it is really gone then you can recover from a mysql dump file if you 
have one.  I normally run mysqldump daily to get a text dump of the DB and 
then make sure it is caught in the backup.

Rob

-- 
Robert Brockway B.Sc.
Senior Technical Consultant, OpenTrend Solutions Ltd.
Phone: 416-669-3073 Email: rbrockway-wgAaPJgzrDxH4x6Dk/4f9A at public.gmane.org http://www.opentrend.net
OpenTrend Solutions: Reliable, secure solutions to real world problems.
Contributing Member of Software in the Public Interest (www.spi-inc.org)
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml