Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

Vanilla: Transferring Vanilla to a new database

Bottom of Page

1 to 5 of 5

  1.  
  1.  # 1
    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?
  2.  # 2
    You can just do a mysql dump to import back in somewhere else. Shouldn't be a problem.
  3.  # 3
    Could you elaborate on that a little bit?
    •  
      CommentAuthorscrawler
    • CommentTimeJan 27th 2008
     # 4
    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
    •  
      CommentAuthorMax_B
    • CommentTimeJan 27th 2008
     # 5
    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).

1 to 5 of 5

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page