dqzpt40064
dqzpt40064
2014-12-03 10:09

表从phpMyAdmin中消失,但通过命令行可见

已采纳

I'm using MAMP and OS X 10.10.1 and use Time Machine to backup my local environment. I've recently had several occurances where a database disappears from phpMyAdmin and is inaccessible to my local site but is visible if I connect through mysql on the command line. I do however see that some of the databases are conflicted and are listed like so:

wp_commentmeta     
#mysql50#wp_comments (MacBook Pro de...conflicted
wp_comments 

What is the best way to get rid of these conflicted files? I think the conflicted file contains the most recent information so I would prefer to keep that if possible.

I'm guessing this is the reason for the tables disappearing from phpMyAdmin?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • doubi7496 doubi7496 7年前

    The error that keeps the databases from appearing indeed seems to be the message itself. Removing the #mysql50# and the conflict message as well as the less recent version of the table will leave the database in its most recent state before the conflict occurred.

    点赞 评论 复制链接分享