I am using a shared hosting for mysql and the databases are enlarging 0,5 MB per day.
1. What is the optimum size of the database? 10MB, 50MB or 500MB? Since I can chunk the database to smaller ones but I don't want to create a lot because of maintenance issues.
2. In mysql cpanel there is a limit of 50MB for file size to import. Is this a criteria?
4. Some tables are very big. 1 of the 20 tables has the 70% of the data volume. Is this a problem?