Blog Documentation Book a Demo

Numerous issue, headaches and concerns...

OreganoflowOreganoflow
edited August 2007 in Vanilla 1.0 Help
Is there a way to back up everything and start all over again? I would like to keep all the discussions and users and begin again with all new extensions.

I'm getting more and more errors and fixing one just makes the other worse.

Comments

  • MinisweeperMinisweeper New
    Just take a sql dump of your database and you'll be fine.
  • OreganoflowOreganoflow
    I have no idea how to do that. I'm assuming its through mysql? Any assitance would be greatly appreciated, I've got almost 1100 users who are depending on me fixing the site this weekend. Thanks!
  • MinisweeperMinisweeper New
    Do you have a mysql manager like phpMyAdmin?
  • MinisweeperMinisweeper New
    Otherwise you could try this: http://lussumo.com/addons/index.php?PostBackAction=AddOn&AddOnID=296
  • OreganoflowOreganoflow
    I do have a mysql manager, I believe its through my web host. I'll read over your link, I'm sure I'll have more questions. Thanks for your help.
  • OreganoflowOreganoflow
    So once I make a backup from the database, what's my next step? Again, my goal is to save the users and posts. I want to start from scratch with extensions.
  • MinisweeperMinisweeper New
    Then you need to make a fresh install of vanilla, then use your mysql manager to import the database backup you made. I'd suggest you install the new one into a seperate database just incase anything goes wrong with the backup.
  • OreganoflowOreganoflow
    Fresh install, meaning copying all the Vanilla files to the html directory all over again? That's easy enough. Using the mysql manager, if I create a new database and import the backup, is that all I need to do? Then will the users be able to login normally?
  • ithcyithcy New
    if you have shell access at your host, you can do this to backup:

    mysqldump -u your_mysql_username -p -h your.mysql.host your_vanilla_db_name > vanilla.sql

    and then this to restore:

    mysql -u your_mysql_username -p -h your.mysql.host your_vanilla_db_name < vanilla.sql
This discussion has been closed.