MySQL tables "in use" on Mac, work on Windows -
I am trying to share my WordPress MySQL database to use Dropbox between Mac and Windows PCs.
Database is on Dropbox and on PC and Mac and XMPP, both MMPs have been symlinked.
Everything works perfectly fine on Windows, but some tables on Mac will not be loaded in Apache / MySQL version but I think this is not the case? Basically it was important if the database was created on Windows.
What it looks like on the Mac:
Similar DB on Windows:
wp_users, wp_posts, wp_comments, wp_links tables - they are broken up notice. In addition, there is something weird about the size of other tables ...
Repair tape ends with wp_users:
"Your SQL query has been executed successfully"
And below I get some error (phpmyadmin):
table | Sahara | Msg_type | Msg_text mydbname.wp_users | Repair | Error | Incorrect information in file: './mydbname/wp_users .... mydbname.wp_users | Repair | MySQL, some data about Mac first: Database server server: localhost unix socket server type: mysql server version: 5.5.33 - source distribution protocol version: 10 user: root @ localhost Server charset: UTF-8 Unicode (UTF 8) and Windows:
: 127.0.0.1 via TCP / IP server type: MySQL Server version: 5.6.16 - MySQL Community Server (GPL) Protocol version: 10 User: Root @ Localhost Server Charset: UTF-8 Unicode (UTF 8) What's wrong? Any help hand? :)
MySQL data files have not been trusted back and forth between different versions of MySQL If you want to share your database file between the system, make sure that they are running the same version of MySQL.
Comments
Post a Comment