943,959 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 832
  • MySQL RSS
Nov 18th, 2008
0

mysql does not start now

Expand Post »
Hi,

I wanted to make use of a algorithm script for computing scores nd though i started doing it with a single database, i after testing script, decided to get a master and score databases both having same tables and data. I imported 2.5 GB of data dump to both databases.
Later when all was set up, I just dropped a table from both databases and tried importing that table and related data with a updated table dump. Unfortunately power went and since i didnt had any backup, my linux box got off.

I dont know why, my mysql server does not start after it. Did it crash as it was half way importing data... How should i go from here? Should i reinstall my mysql server...

Environment: LOCAL
Mysql : 5.0+
OS : LInux
PC used for do development and testing.
I request some pointer and suggestion from experts here..

With regards,

Harish
Similar Threads
Reputation Points: 10
Solved Threads: 0
Junior Poster
hbmarar is offline Offline
187 posts
since Apr 2005
Nov 18th, 2008
0

Re: mysql does not start now

did you try to start it manually

MySQL Syntax (Toggle Plain Text)
  1. /etc/init.d/mysql start
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Nov 20th, 2008
0

Re: mysql does not start now

did you try to start it manually

MySQL Syntax (Toggle Plain Text)
  1. /etc/init.d/mysql start
I think, linux on boot up tries to recover the crash but fails. I added safe mode to my.cnf and still, it starts and ends quickly. Finally, Ystrday evening , fed up, I kicked myself for a fresh installation.
Reputation Points: 10
Solved Threads: 0
Junior Poster
hbmarar is offline Offline
187 posts
since Apr 2005
Nov 20th, 2008
0

Re: mysql does not start now

so you got it all worked out now?
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Nov 20th, 2008
0

Re: mysql does not start now

so you got it all worked out now?
Yeah, it seems like innodb buffer memory increase configuration and power failure amidst import did the cheat. NOw again got a new server up.

Thanks buddy for concern.
Reputation Points: 10
Solved Threads: 0
Junior Poster
hbmarar is offline Offline
187 posts
since Apr 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Inserting new row in mysql
Next Thread in MySQL Forum Timeline: Different quote marks





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC