mysql database

Discussion in 'Computer Programming, Emulation, and Game Modding' started by robertokidd, Jan 22, 2016.

  1. robertokidd
    OP

    robertokidd Newbie

    Newcomer
    1
    0
    Jan 22, 2016
    United States
    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?
     
  2. FAST6191

    FAST6191 Techromancer

    pip Reporter
    23,363
    9,164
    Nov 21, 2005
    So you have a mysql database you put on a USB drive. When you go where you were going the thing did not work for whatever reason. Afraid I will have to know what happened to the file to figure it out -- if it was an all 00 filled file from a bad copy (seen that a few times) then it is gone, however if it is just headers or some kind of scratch space that is messed up you can fix that easily enough.

    What program/site is this database for? If you have to fully reverse engineer something then it takes time, however if you know you are looking at a known format that you can pull apart then it is easy enough to start fitting things back together.
     
  3. masonwillis

    masonwillis Newbie

    Newcomer
    1
    0
    Feb 8, 2016
    United States
    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 https://www.repairtoolbox.com/mysqlrepair.html 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