I work for a small company made up of a salesman, a graphic artist, and an engineer.
The engineer writes and maintains all of his own software to run a network of interactive kiosks around the globe.
As artist, I use his tools to maintain and update the network content.
Last month, the engineer died of a heart attack - leaving me and the salesman to keep the network running.
The power supply went out on the pc hosting the mysql server and corrupted the db. I am trying to recover the db, but I am flying blind.
All I have to go on are the instructions on how to reboot the server should it go down.
This tells me where the db is located the user name and password.
When I run the start up, I get errors such as:
InnoDB: Error: page XX log sequence number 0 36808 is in the future!
InnoDB: Current system log sequence number 0 8204.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but not the InnoDB log files. See blah, blah for more
At home, I have a testing server using XAMPP and have a basic knowledge of how to use it.
Here at work, I cannot tell what server is running and how to even access it. In my notes I have the two lines:
mysqladmin -uroot -address ping
mysqladmin -uroot -password ping
so I'm assuming that he was using mysqladmin to administer the db
This is hosted on a windows xp machine and only used on the local network.