Skip to content

Backup Sendy mySQL database

derivativemediaderivativemedia
edited November 2012 in Questions
What's the best way to backup the sendy database? I am changing hosts and need to export then re-import. I was thinking export through phpmyadmin -- and if so, do I need to add drop table, etc? Or is a command line dump a better solution?

Comments

  • jpanseljpansel
    I just wanted to share my experience.

    I moved Sendy twice - different hosting but same domain.
    I used phpMyAdmin to export the database with default settings.
    I imported the .sql file on the new host with phpMyAdmin, default settings as well.

    Then I opened the table "login" and updated the "cron" column for all records to show "0" instead of "1". This way, Sendy does not consider that cron is setup even if it's not, and instructions for cron setup are not hidden.

    Then you just have to edit include/config.php and put there your database information.
  • derivativemediaderivativemedia
    thanks that's perfect. I wanted to reset the cron to ensure when I set the cron script again, it works correctly and changes the value to 1 on its own.
This discussion has been closed.

© Sendy.co 2024