Jump to:

1161 Posts in 2632 Topics by 409 members

Upgrading SilverStripe

SilverStripe Forums » Upgrading SilverStripe » Database too heavy for import

Ask questions about upgrading SilverStripe to the latest version.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 650 Views
  • rsilvajls
    Avatar
    Community Member
    7 Posts

    Database too heavy for import Link to this post

    Hi, I am a SS newbie and I am trying to upgrade a site but I am stuck backing up the database. I am trying to bring my site back into my MAMP server but the database seems to be too large for import.

    Can anyone help?

    Thanks!

  • _Vince
    Avatar
    Community Member
    161 Posts

    Re: Database too heavy for import Link to this post

    You've tried zipping up the database export file, right?

    If that doesn't solve it, do you have a lot of versions of each page?

    There's an SQL script somewhere that deletes the older versions of each page and this might reduce the size of the database somewhat. I can't google it now, but I remember it worked quite well.

  • Willr
    Avatar
    Forum Moderator
    5508 Posts

    Re: Database too heavy for import Link to this post

    You could spilt your database import file into multiple files.

  • johannes
    Avatar
    Community Member
    20 Posts

    Re: Database too heavy for import Link to this post

    Try using MySQL Workbench (http://www.mysql.de/products/workbench/), I never had problem even with 50MB DB dumps.

  • simon_w
    Avatar
    Forum Moderator
    473 Posts

    Re: Database too heavy for import Link to this post

    Alternatively, you can just pipe the SQL dump directly into MySQL. I can't remember where MAMP keeps its binaries, but the command to run from Terminal will be something like:
    /Applications/MAMP/.../bin/mysql -u root -p databasename < /path/to/file.sql

    If the root MySQL user doesn't have a password, drop the -p and if the database hasn't been created but the sql file has a CREATE DATABASE line at the top, then you can drop the databasename.

    650 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.