Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

What database tables can I purge before exporting? 
 
Shpigford
Sr. Member
 
Avatar
Total Posts:  171
Joined:  2007-09-03
Denver, CO
 

I’m needing to move my magento database to another server and right now it’s a whopping 500+ MB. I was wondering what database tables I could possibly purge to reduce the size.

For instance, the following tables make up over 400MB of the total 500 and they just seem to be log tables...which seem like they could be purged.

log_url
log_url_info
log_visitor
log_visitor_info

 
Magento Community Magento Community
Magento Community
Magento Community
 
Shpigford
Sr. Member
 
Avatar
Total Posts:  171
Joined:  2007-09-03
Denver, CO
 

Anybody have any ideas on this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Daim
Sr. Member
 
Total Posts:  172
Joined:  2008-01-08
Germany
 

When you will you can truncate the log tables. But you can compress the export from your database and save filesize

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top