Blog Documentation Book a Demo
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

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

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