VERY URGENT Help Pleeeeease I lost everything :(

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
alsaffar
Forum Newbie
Posts: 16
Joined: Sun Sep 29, 2002 12:03 pm

VERY URGENT Help Pleeeeease I lost everything :(

Post 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 ....
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Have you started the MySQL database? 'cause it looks like there was a shutdown but no subsequent restart.

Mac
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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)?
User avatar
alsaffar
Forum Newbie
Posts: 16
Joined: Sun Sep 29, 2002 12:03 pm

Post by alsaffar »

Thanx guys 4 help,

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

Thanx again :)
Post Reply