Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Transferring Vanilla to a new database

My host will only let me create SQL databases that hold a maximum of 100 MB of info. I know this will hold me over for a long time, but is there a process to transfer everything to a new database down the road with a larger capacity if I need to?


  • Options
    You can just do a mysql dump to import back in somewhere else. Shouldn't be a problem.
  • Options
    Could you elaborate on that a little bit?
  • Options
    don't take my word for it without checking the syntax, but I think it's

    #mysqldump -u username -p databasename > databasename-dump.sql

    and then

    #mysql -u username -p emptybutexistingdatabase < databasename-dump.sql
  • Options
    Most of hosted Vanilla install does not have access to command line mysql and must dump using phpMyAdmin export/import features. It's easy to play with the export and look at the generated file. Importing is an easy step also but you cannot "play" it as it overwrites your database (or doubles it, depending of export option).
This discussion has been closed.