Jump to content


Photo

MySQL database


  • Please log in to reply
5 replies to this topic

#1 kasenarnold

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

Pasidon

    Splitting Hares

  • Network Admins
  • 8,839 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.


YT_Sig.jpgoutput_Fkd6it.gifFB_Sig.jpg


#3 Phil

Phil

    Force Majeure

  • Network Leaders
  • 7,969 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.


revorapresident.jpg
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

Pasidon

    Splitting Hares

  • Network Admins
  • 8,839 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.


YT_Sig.jpgoutput_Fkd6it.gifFB_Sig.jpg


#5 Beowulf

Beowulf

    Unknown Superstar

  • Advisors
  • 7,215 posts
  • Location:Equestria
  • 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 | NZ Gaming | RP
Skype: doctordestiny891
MSN: genkosygin@hotmail.com
Steam


#6 dylanfrancis

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

 

https://social.msdn....m=sqldataaccess

http://www.sqlserver...894-2893-1.aspx

 

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
     

innodb_force_recovery=4

  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