WordPress.org

Forums

BackWPup Free - WordPress Backup Plugin
[resolved] a value of "wp_users" is empty (14 posts)

  1. hueblueblue
    Member
    Posted 11 months ago #

    In "Settings for database backup", I checked all of "Tables to backup", but a value of "wp_users" is empty.
    I also open the output(sql file) in text editor, "wp_users" is empty.

    On the other hand, the database which exported from a server(lolipop in Japan) in phpMyAdmin contains a value of "wp_users" properly.

    What should I do?
    Thank you.

    https://wordpress.org/plugins/backwpup/

  2. Daniel Hüsken
    Member
    Plugin Author

    Posted 11 months ago #

    how many user in ?

  3. hueblueblue
    Member
    Posted 11 months ago #

    It's only one user.

  4. hueblueblue
    Member
    Posted 11 months ago #

    (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.

  5. hueblueblue
    Member
    Posted 11 months ago #

    日本語でも記載しておきます。

    ロリポップ!レンタルサーバー様にも現象を確認していただきました。
    [WordPress version 3.9.1][BackWPup version 3.1.2]にて

    ◆ユーザーが1人のとき
    「wp_users」テーブルについてはテーブル構造のみがバックアップされ、その中身はデータベースのバックアップに含まれない。

    ◆ユーザーが複数のとき
    最後に追加されたユーザーがバックアップに含まれない。

    ロリポップ!だけでなく、他社レンタルサーバーでもご確認いただき、同じ現象が確認されています。

  6. hueblueblue
    Member
    Posted 11 months ago #

    There seems to be the case which a problem does not happen.

  7. rhykw
    Member
    Posted 11 months ago #

    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.

  8. hueblueblue
    Member
    Posted 11 months ago #

    Thank you, rhykw.
    I checked it in phpMyAdmin and it was InnoDB.

  9. hueblueblue
    Member
    Posted 11 months ago #

    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.

  10. hueblueblue
    Member
    Posted 11 months ago #

    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.

  11. Daniel Hüsken
    Member
    Plugin Author

    Posted 11 months ago #

    Hello i have solved that in the beta https://github.com/inpsyde/backwpup/archive/master.zip
    Thanks for the hint.

  12. hueblueblue
    Member
    Posted 11 months ago #

    Hi, Daniel

    I tried it and the value of wp_users was included properly.
    Thank you!

  13. hueblueblue
    Member
    Posted 11 months ago #

    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".

  14. Daniel Hüsken
    Member
    Plugin Author

    Posted 11 months ago #

    Please open a new thread.
    Did you have special wp_content_dir set ?

Reply

You must log in to post.

About this Plugin

About this Topic