I'm trying to copy my live store to a different test server
Due to limit space on my test server, I need to reduce my DB file size when import DB
I got 2.5 GB DB file when I dump on live store and hope I can get less than 1 GB DB file
Which table has much space and safe to delete?
I already create and copy my live DB as other db on my live server, so it's safe to delete any tables (like customer, order)
I don't have to have all products on test serer (just few products is okay)
Is there good way I can reduce DB file size for creating test store?Is there good, safe way I can reduce DB file size for creating test store?