Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Upgrading SilverStripe /

Ask questions about upgrading SilverStripe to the latest version.

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

Database too heavy for import


Go to End


5 Posts   1878 Views

Avatar
rsilvajls

Community Member, 7 Posts

27 February 2013 at 9:26am

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!

Avatar
_Vince

Community Member, 165 Posts

28 February 2013 at 10:32am

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.

Avatar
Willr

Forum Moderator, 5523 Posts

28 February 2013 at 8:58pm

You could spilt your database import file into multiple files.

Avatar
johannes

Community Member, 20 Posts

1 March 2013 at 10:36am

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

Avatar
(deleted)

Community Member, 473 Posts

1 March 2013 at 7:22pm

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.