Database backup empty

  • Resolved Adam Walter

    (@adamwalter)


    11 years, 11 months ago

    I’m trying to figure out the workflow for tracking database changes. I created a new post to add some new data to the database. Then, in the absence of a better approach, I made an empty commit and checked “Backup database”. The dump file was created, my commit logged, and I successfully pushed to Github.

    However, my SQL file is 0B and completely empty. Any ideas why?

    https://ww.wp.xz.cn/plugins/revisr/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Hi Adam,

    Can you please try running the following from command line?

    mysqldump -u YOURUSERNAME -pYOURPASSWORD YOURDB . " >revisr_db_backup.sql

    If it works, it may be a permissions error. Also, just to confirm, you’re using the latest version of revisr?

    Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Sorry, should be as follows:

    mysqldump -u YOURUSERNAME -pYOURPASSWORD YOURDB >revisr_db_backup.sql

    Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Sorry, should be as follows:

    mysqldump -u YOURUSERNAME -pYOURPASSWORD YOURDB >revisr_db_backup.sql

    Thread Starter Adam Walter

    (@adamwalter)

    11 years, 11 months ago

    That does work for me. And I’m up-to-date on WP and Revisr.

    Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Rolling out a possible fix for this tonight.

    Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Hi Adam,

    We just rolled out an update that may address this issue depending on the environment. If the backup still is empty for you, please try the following:

    – Verify that the correct permissions are set on the uploads folder
    – If using windows, set the path for mysqldump. This link should point you in the right direction.

    Plugin Author Expanded Fronts

    (@expandedfronts)

    11 years, 11 months ago

    Hi Adam,

    I haven’t head back from you on this so I’m marking this as resolved as we have tested on multiple systems and confirmed that this functionality is working (provided that the permissions are set correctly and the full path is provided if on windows).

    If you run into any further issues, please let me know and I will be glad to address them.

    Thank you.

    Thread Starter Adam Walter

    (@adamwalter)

    11 years, 11 months ago

    Sorry I haven’t had time to test but I will soon. I’m sure it works!

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

The topic ‘Database backup empty’ is closed to new replies.

Tags