[Cartoweb-users] Howto restore MySQL tables

[Oliver Ishmael]

Hello,

I recently saved a backup of a WAMP installation i made for use with 
Cartoweb. The data i was using with Cartoweb was stored in a MySQL table 
using PHPMyAdmin. The folder structure looks something like this:
Wamp > Mysql > Data
and it contains several 10,000KB files called 'ib_logfile' and 'ibdata' as 
well as folders for each database. For example, the 'moor_simple' database 
folder contains:
db.opt
moor_facility.frm
lookup_table.frm

I tried simply copying these folders to the mysql folder under my new 
Cartoweb install and the database names are now visible under PHPMyAdmin and 
clicking on them displays the various tables contained within them. Browsing 
the tables, however, is not possible and instead i get the message below 
(from within PHPMyAdmin):


Error

SQL query:

SHOW INDEX FROM `moor_facility` ;

MySQL said:

#1146 - Table 'moor_simple.moor_facility' doesn't exist


Can someone please explain how i can restore my mysql data?


Many thanks,
Olly

_________________________________________________________________
Could you be the guest MSN Movies presenter? Click Here to Audition 
http://www.lightscameraaudition.co.uk