collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: [resolved] restoring db from crashed server  (Read 3367 times)

0 Members and 1 Guest are viewing this topic.

Offline motoislo

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
[resolved] restoring db from crashed server
« on: April 19, 2009, 03:38:08 am »
Hello bot masters,

I had bebot v0.4.3 setup using mysql. The computer died and no longer boots, but I have some of the data off the hdd, including all of the bebot files and a copy of the mysql directory.
Is there a way to "import" this data to a new install of mysql on another machine? I do not have a dump file because the computer no longer runs to create one. I installed mysql on the new machine and the bot is working, I just want to restore all the alts, news, ect. that was in the db.
If there is no way without the dump, I guess I can put the hdd (if it works x.x)in another computer and try and get it to boot, then dump the db.

Is that my only option?

Thanks,
Moto

(edit: added resolved to title)
« Last Edit: April 19, 2009, 04:21:47 pm by motoislo »

Offline motoislo

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: restoring db from crashed server
« Reply #1 on: April 19, 2009, 05:18:20 am »
Well the hdd is not bootable.   >:(
I am trying to repair the windows install, but I don't know how that will effect the sql already on it. What a day. I just got done rebuilding a carburator and was about to pull off a top end, now im stuck inside working on this mess.  :-X

Offline motoislo

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: restoring db from crashed server
« Reply #2 on: April 19, 2009, 04:19:56 pm »
I was able to repair the OS enough to get into sql and create a backup.sql file to restore from. So my problem is solved.

Still wondering if this is the only way to recover a database. So any info would be great.

Also, thanks for bebot and these forums, keep up the good work.  ;D

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 501
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal