Copied MySQL Database Files but Tables are not Showing in PhPMyAdmin -


i tried restore wordpress site using backed files. put faith in wordpress "export-all content" function in fact exports little.

i kept backups of wamp files , have read several posts copy backed database files new location , database works fine:

reinstalled wamp, wordpress tables not found in phpmyadmin

restore mysql database .frm files

the annoying thing these not working me. have tried 2 things:

  1. copied database folder , backed ibfiles places. once , open php admin, wp tables listed error message not exist. see attached screenshot. screenshot of copied files , problem

  2. i created new database same name , did fresh wordpress install created empty tables. copied backed folder containing .frm files newly created folder , replaced ib files. problem time wamp not start , denied access phpmyadmin. error message 2002 actively refused.

one thing have noticed. in backed file ibdata1 file had not been backed since 13/08/14. whereas ib_logfile1 , iblogfile() 29/03/2015 , 19/04/2015. possible backup program (wd smartware) not doing sufficient job @ backing files? if wasting time , should start rebuilding scratch.

thanks help.

your ibdata1 file contains metadata database, tablespaces, indexes, table structure etc... should coincide last date else touched appears 04/19/2015 you. if ibdata1 file has not been backed since 08/13/2014 means metadata out of wack table (.frm , .ibd) files. while can see tables in database cannot access data because tablespaces misaligned. in case have infamous case of schrodinger's mysql table. briefly explained, mysql believes table exist , doesn't exist @ same time. refer stackoverflow more information.

i not believe innodb_force_recovery work in case guess can't hurt give shot. percona has recovery tool innodb fix metadata (tablespaces) has become out of sync. can give shot. experience not easy work with, can fire in linux, not necessary going work, , there little on web in terms of working tool.

my recommendation scrap can , start over.


Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more