Blog Documentation Try Vanilla Cloud
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.
Options

Transferring Vanilla to a new database

QuizShowScandalQuizShowScandal
edited January 2008 in Vanilla 1.0 Help
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?

Comments

  • Options
    MinisweeperMinisweeper New
    You can just do a mysql dump to import back in somewhere else. Shouldn't be a problem.
  • Options
    QuizShowScandalQuizShowScandal
    Could you elaborate on that a little bit?
  • Options
    scrawlerscrawler
    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
    Max_BMax_B New
    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.