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!
This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.
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.
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!
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.
You could spilt your database import file into multiple files.
Try using MySQL Workbench (http://www.mysql.de/products/workbench/), I never had problem even with 50MB DB dumps.
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.