Page 1 of 1

VERY URGENT Help Pleeeeease I lost everything :(

Posted: Sun Sep 29, 2002 12:03 pm
by alsaffar
Help Guys,

I did a lot of work yesterday and I didn't backup my local database that I was working on. This mourning I tried to login to my localhost mysql db through MySQL-Front and MS-DOS but I couldn't and it gave me the following error:

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

and when I checked WinMySQLadmin in the Err File tab, I found the following errors:

020929 15:59:46 MySql: Table 'mysql.host' doesn't exist

020929 1:41:30 MySql: Shutdown Complete

020929 1:41:29 MySql: Normal shutdown
MySql: ready for connections

In phpinfo() page I looked at mysql section and I found that there's no section for MySQL support, only deravitives exist!

Please help me .... I'm lost ....

Posted: Sun Sep 29, 2002 1:48 pm
by twigletmac
Have you started the MySQL database? 'cause it looks like there was a shutdown but no subsequent restart.

Mac

Posted: Sun Sep 29, 2002 2:04 pm
by volka
hmmm...no table mysql.host anymore?
maybe it's just that simple that the mysql-server isn't started, but ....
in your mysql-configuration there may be an entry datadir = <path>. if not or commented it's the default path.
If you take a look at the directory <path>/mysql are there for these entries
  • columns_priv
  • db
  • func
  • host
  • tables_priv
  • user
corresponding files (.frm,.MYI.,MYD)?

Posted: Sun Sep 29, 2002 2:44 pm
by alsaffar
Thanx guys 4 help,

I found my dbs ubder data folder, so I made a backup and reinstall mysql.

Thanx again :)