Please forgive my ignorance in this question, i know already I probably am going to sound like a retard for asking it.
HOwever, is there a way to add space to an existing partition without losing all of the files?
For example, i ordered a server, and the datacenter only put a 6GB partiion on my /var/. Now, i have like 5gb worth of databases in /var/lib/mysql and the partition is full.
If not, what are my options here?
Could I move all of the databases to another location and create a sym-link for msyql directory to point there? Or is there a better option?