Jump to content


MySQL database

  • Please log in to reply
5 replies to this topic

#1 kasenarnold

  • New Members
  • 1 posts

Posted 28 January 2016 - 10:19 AM

Was the server worked well, it was a Windows Server 2008 R2, and one day the mother burned, move to another platform with Intel did not work, the Windows does not start, reinstall the screw on the other, now we need to pull the database from the old axis.

What actions can be solve the issue?

#2 Pasidon


    Splitting Hares

  • Network Admins
  • 8,905 posts
  • Location:Da Moon
  • Projects:YouTube
  •  Actual Celebrity
  • Division:Community
  • Job:Community Admin

Posted 28 January 2016 - 12:40 PM

The mother burned?  That's so... yikes.


You're going to have to tell me what game you're even talking about so I can move this topic to the right place.


#3 Phil


    Force Majeure

  • Network Leaders
  • 7,971 posts
  • Location:Switzerland
  • Projects:Revora, C&C:Online
  •  Thought Police
  • Division:Revora
  • Job:Network Leader
  • Donated
  • Association

Posted 30 January 2016 - 10:36 AM

Try replacing the failed motherboard with the same model?

In the worst case you can still just take the hard disk(s) and connect them to another PC/Server and then copy the database files to the new system manually.

My Political Compass

Sieben Elefanten hatte Herr Dschin
Und da war dann noch der achte.
Sieben waren wild und der achte war zahm
Und der achte war's, der sie bewachte.

#4 Pasidon


    Splitting Hares

  • Network Admins
  • 8,905 posts
  • Location:Da Moon
  • Projects:YouTube
  •  Actual Celebrity
  • Division:Community
  • Job:Community Admin

Posted 30 January 2016 - 10:39 AM

How did you figure any of their post out?  Amazing.


#5 Beowulf


    Anime Girl

  • Advisors
  • 7,217 posts
  • Projects:Red Alert X, YR: TG Redux, AR

Posted 31 January 2016 - 05:56 AM

Also pray that the system going down didn't corrupt a few files, rendering that database unusable.


Furthermore, why would you use mySQL on Server 2008? That's like trying to keep using JSP...

NZ.org | BBPCG
Discord: The Astronomer#1314

#6 dylanfrancis

  • New Members
  • 1 posts

Posted 08 February 2016 - 09:12 PM

Repairing tables with mysqlcheck or another variant to learn helpful topics about mysql databases





But in case your corruption can't be overcome, then I would suggest you more powerful instrument for such cases https://mysql.recoverytoolbox.com/ Recovery Toolbox for MySQL


If you, by any chance, forgot to create backup, you should do more work as the following:

  1. Edit my.cnf (usually located in /etc/my.cnf) and add this line into [mysqld] section


  1. Restart mysql (e.g: /etc/init.d/mysqld restart)
  2. Your MySQL log should tell you which table is corrupt. You can dump the table using “SELECT … INTO OUTFILE …” from mysql console or using tool like mysqldump
    • Example using MySQL query (you also need to dump the schema later)

mysql> SELECT * FROM corrupted_table INTO OUTFILE ‘/path/to/file’

  • Example using mysqldump

root# mysqldump –opt -u uname -p dbname corrupted_tablename > /path/to/out.sql

  1. Go back to my.cnf and comment the line you wrote from step #1
  2. Go intoMySQL console and drop the corrupted table

mysql> DROP TABLE corrupted_tablename;

  1. Import data dump, for sql dump you can use:

root# mysql -u uname -p < /path/to/out.sql

  1. Go back into mysql console, check and optimize all tables
  2. Done

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users