?mysql Database

Their database Mysql. After I threw it on the stick and opened on the laptop, stopped running properly, I guess that after the transfer of the card have problems, copies of the file never left, never thought about it. In addition, how can I restore it?

I Know the Answer!

I have the same question
Request More Information

Current Answers

Answer #1: Posted by TommyKervz on January 23rd, 2016 2:38 PM

This answer was accepted by the poster of the original question.

TommyKervz

Member since:
January 10th, 2013

Points: 17,776,833

1,100
points

Please follow the instructions on the link below.

https://docs.oracle.com/cd/E35328_01/E35330/html/vmiug-manager-mysql-restore.html

Hope that is helpful.
Kervz at www.satechhelp.co.za

Answer #2: Posted by masonwillis on February 8th, 2016 9:43 AM

masonwillis

Member since:
February 8th, 2016

Points: 100

100
points

More helpful resources with many various solutions you may see on following topics

http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196415

But if you can't handle the issue, then your mysql database has hard corruption and you may refer to more powerful solution Repair Toolbox for MySQL

To fix this do the following please:

1. Open a command line by clicking start, type "cmd", hit return/enter.

2. Stop the TV Service: Type (or Copy/Paste) net stop TVService 3. Type (or Copy/Paste) cd C:\Program Files\MySQL\MySQL Server 5.1\bin (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter. 4. Type (or Copy/Paste) mysqlcheck mptvdb --auto-repair -e -u root -p ,and hit return/enter. 5. A password prompt should appear. The default password is MediaPortal (case sensitive).

6. Start the TV Service: Type (or Copy/Paste) net start TVService

Note: mysqlcheck must be used when the mysqld server is running.

Caution: It is the best practice to make a backup of database before performing repair operation; under some circumstances the operation might cause data loss.

Note: When you have a different version of MySQL installed (for example when you updated to the 5.6 install), you'll have to adjust the Program Files path (step 3). For 5.6 that would become cd C:\Program Files\MySQL\MySQL Server 5.6\bin