Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

How to recover MySQL database with new MySQL and XBMC installation


Best Answer govordguver , 30 September 2015 - 04:29 AM

You have many options!!! If you don't get to connect on database, you will have to restore it. The basic restore command for restoring a full database from a disk backup image is db2 RESTORE DATABA... Go to the full post »


  • Please log in to reply

#1
maxlorenc8

maxlorenc8

    New Member

  • Member
  • Pip
  • 1 posts

Hoping someone can help with my problem.

I recently lost my Windows 7 installation which had XBMC Eden and MySQL installed. When I say lost the installation, Windows will no longer boot and Windows repair isn't working but that's a separate issue, however all my data is accessible. Whilst I wasn't happy that I couldn't recover Windows 7 I wasn't too concerned as I had been working on a parallel installation of Windows 8 and this has accelerated my migration plans.

I need some help with recovering my database, as I don't want to scrape everything from scratch.

I have tried the following steps:
- Installed same MySQL version into Win 8, then copied the data files from previous installation program files\mySQL\data
- Installed XBMC Eden, then copied previous Users\appdata\roaming\xbmc into Win 8 equiv preserving sources and advanced settings, db files etc
- Run XBMC - no libraries are present

When I check the database using the SQL Command line (show databaseswink.png, myvideos60 is present but the row count is 0, so obviously the data from the previous implementation is not in the table. How do I get it in?

Or is there a better way to do this? Bear in mind I no longer have access to the previous MySQL server, but do have access to the data files.

Thanks


  • 0

Advertisements


#2
govordguver

govordguver

    New Member

  • Member
  • Pip
  • 2 posts
✓  Best Answer

You have many options!!!
If you don't get to connect on database, you will have to restore it.
The basic restore command for restoring a full database from a disk backup image is
db2 RESTORE DATABASE dbname FROM directory TAKEN AT timestamp
To restore from TSM use:
db2 RESTORE DATABASE dbname USE TSM TAKEN AT timestamp
The timestamp represents the time the database
was backed up (it's the timestamp you see when the backup completes and
it also exists in the recovery history file and for backups to disk you
can see it in the filename or path)
download https://www.restoret...sqlrestore.html
or
http://qa.site5.com/...up-and-restore/


  • 1






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP