Answer the question
In order to leave comments, you need to log in
How to make a backup copy of the database in the absence of space?
The mysql database weighs 90 GB, 100 are available on the hosting. It will most likely not shrink to 10, and the question is not about that. Are there any options in this case? Replication to another server only? By tables to copy? What if it's all in one table?
Answer the question
In order to leave comments, you need to log in
mysqldumpbladb | gzip | ssh remotehost "cat > /backup/dump.sql.gz"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question