(In environment of [WordPress version 3.9.1][BackWPup version 3.1.2])
The same problem has been confirmed not only the “lollipop! rental server”, In other rental server.
The confirmation by “lollipop!”, The following was found.
◆When users of one
Only table structure is backed up for the “wp_users”, its contents are not included in the backup of the database.
◆When users of multiple
Users who have been added to the end is not included in the backup.
日本語でも記載しておきます。
ロリポップ!レンタルサーバー様にも現象を確認していただきました。
[WordPress version 3.9.1][BackWPup version 3.1.2]にて
◆ユーザーが1人のとき
「wp_users」テーブルについてはテーブル構造のみがバックアップされ、その中身はデータベースのバックアップに含まれない。
◆ユーザーが複数のとき
最後に追加されたユーザーがバックアップに含まれない。
ロリポップ!だけでなく、他社レンタルサーバーでもご確認いただき、同じ現象が確認されています。
There seems to be the case which a problem does not happen.
wp-content/plugins/backwpup/inc/class-mysqldump.php
at line:152 use
SHOW TABLE STATUS
.
http://dev.mysql.com/doc/refman/5.6/en/show-table-status.html
The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count.
The Rows value is NULL for tables in the INFORMATION_SCHEMA database.
If use InnoDB , may be not backed up wp_users
.
Thank you, rhykw.
I checked it in phpMyAdmin and it was InnoDB.
Does it mean that I cannot use backWPup?
If “wp_users” is empty, it is awkward that I cannot log in to WordPress after recovery.
Hi, Daniel
Is this right that backWPup does not support InnoDB now. Therefore it is necessary to use other plugin supporting InnoDB about the database backup for the moment.
And I’d like to know whether backWPup has the plan that will support InnoDB in the future.
Thank you.
Hello i have solved that in the beta https://github.com/inpsyde/backwpup/archive/master.zip
Thanks for the hint.
Hi, Daniel
I tried it and the value of wp_users was included properly.
Thank you!
Hi, Daniel
Though I checked [resolved], I am sorry.
About the beta, the hierarchy of the folder seems to be strange if I defrost .tar.gz file of the file backup.
There is no “wp_includes” folder.
A folder of the dozen including some plugins(contact-form-7,nextgen-gallery,etc) is made at the hierarchy same as “wp_admin” and “wp_content”.
Please open a new thread.
Did you have special wp_content_dir set ?