Timeline for Which tables are safe to clear?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jan 22, 2019 at 22:26 | history | suggested | Bobík | CC BY-SA 4.0 |
Added link to that example.
|
| Jan 22, 2019 at 11:31 | review | Suggested edits | |||
| S Jan 22, 2019 at 22:26 | |||||
| Jan 26, 2013 at 15:24 | vote | accept | Nigel Waters | ||
| Feb 9, 2012 at 11:40 | comment | added | mpdonadio♦ | @BetaRide is correct, the default ones that BAM excludes are the safe ones. The others may or may not have actual data. | |
| Feb 9, 2012 at 6:52 | comment | added | Nigel Waters | The problem is not with the timeouts. I know I can easily run backups through ssh/drush. I would like to clean up the database as it has seen one to many hands over the last few years and there is a lot of unnecessary crud in there. I just need to know which tables I can safely clear out, (not know how to backup or move my site). | |
| Feb 9, 2012 at 6:49 | comment | added | BetaRide | If you have command line access your can use drush to start backup and migrate. Or access mysql on the command line (example: mysqldump --host=your.host.com --user=db_user --compress --password your_pw >dump.sql) This way you will not run into timeouts. In general clearing out without having a backup isn't very save. You can easily end up with a broken page and no way to go back. | |
| Feb 9, 2012 at 6:43 | comment | added | Nigel Waters | This is the first place I went. However, the database is over a gig and will not backup through this method. My intention is to clear out the database so that I can use backup and migrate on a regular basis. Essentially I am wondering if there are any more tables I can clear out (that aren't by default skipped by BAM). | |
| Feb 9, 2012 at 6:25 | history | answered | BetaRide | CC BY-SA 3.0 |