a value of "wp_users" is empty

  • Resolved hueblueblue

    (@hueblueblue)


    10 years, 9 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://www.ads-software.com/plugins/backwpup/

Viewing 13 replies - 1 through 13 (of 13 total)

  • how many user in ?

    Thread Starter hueblueblue

    (@hueblueblue)

    It’s only one user.

    Thread Starter hueblueblue

    (@hueblueblue)

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

    Thread Starter hueblueblue

    (@hueblueblue)

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

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

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

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

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

    Thread Starter hueblueblue

    (@hueblueblue)

    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 .
    https://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.

    Thread Starter hueblueblue

    (@hueblueblue)

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

    Thread Starter hueblueblue

    (@hueblueblue)

    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.

    Thread Starter hueblueblue

    (@hueblueblue)

    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.

    Thread Starter hueblueblue

    (@hueblueblue)

    Hi, Daniel

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

    Thread Starter hueblueblue

    (@hueblueblue)

    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 ?

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘a value of "wp_users" is empty’ is closed to new replies.

Tags