MySql Lost...

Lance F. Squire lance-5ZoueyuiTZhBDgjK7y7TUQ at public.gmane.org
Mon Jan 24 18:19:44 UTC 2005


Robert Brockway wrote:
> 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;
> 

Shows no such database...

> 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
> 

I normly keep dumps of my Postgres dbs too. Unfortunatly, I inhereted 
this situation.

Lance
--
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





More information about the Legacy mailing list