D
D
DarkMatter2016-07-01 12:02:47
Database
DarkMatter, 2016-07-01 12:02:47

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

2 answer(s)
V
Vlad Zhivotnev, 2016-07-01
@darkmatter

mysqldumpbladb | gzip | ssh remotehost "cat > /backup/dump.sql.gz"

C
chupasaurus, 2016-07-01
@chupasaurus

mysqldump from another host where there is enough space.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question