Forum Replies Created
-
AuthorPosts
-
September 27, 2012 at 9:45 am in reply to: Migrating db from Windows server to Linux server loses products and categories #49766ciacobMember
Ok, so just to keep you posted: I dropped all the tables starting with “eStore” and renamed the old ones from “estore” into “eStore”, and now I have access to my old data.
Still, I’m really keen to find out why this thing happens. And a fix in a next version would be nice also
Peace,
Claudius
September 27, 2012 at 8:28 am in reply to: Migrating db from Windows server to Linux server loses products and categories #49765ciacobMemberThanks wzp, been there before starting the thread.
Maybe I can shed some light on that myself:
1) The tables that got transfered via mysqldump/restore (well, in fact created from scratch, because that’s how the thing works are the following) (copy/paste from the mysql monitor prompt):
| wp_wp_estore_tbl |
… and a few others
For some reason, the plugin couldn’t read from any of these, so after deactivating and re-activating it, has created a brand new set of tables, with these names:
| wp_wp_eStore_tbl |
… and a few others
That is, an uppercase “S” in “eStore”, as oposed to a lower case “s” in “estore”.
Now, my question is: why did the plugin expected to find a table named “…eStore…” instead of “…estore…” as soon as the website moved to Linux? Key Master, do you have a word on this?
Thanks
September 26, 2012 at 9:54 pm in reply to: Migrating db from Windows server to Linux server loses products and categories #49763ciacobMemberP.S.:
Looked into the “wp_wp_estore_tbl” and found that my old products (the ones that I defined on my Windows box) are still there.
However, I defined a test product here, on Linux, and this one does not show in this “wp_wp_estore_tbl” table, although it does show in the admin panel.
I must specify that I used the same MySQL user to consult the tables as WordPress does.
PLease shed some light on that.
-
AuthorPosts