I got an Ubuntu 10.04 production MySQL database server where total size of database is 260 GB while size of root partition is itself 300 GB where DB is stored, essentially means around 96% of / is full and there's no space left for storing dump/backup etc. No other disk is attached to server as of now.
My task is to migrate this database to other server sitting in different datacenter.
I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial import before setting up replication (instructions here).
I've prepared the RDS instance as described and can connect to it from the EC2 instance using mysql.
I am running a AWS RDS large instance for the production. I am taking mysql every mid nite. But the thing is its taking too long to take the mysql dump and also the website will stop responding during the mysql dump process. What I am planning to do is, instead of taking the mysql dump, any how I am taking DB snapshot every day.
This MySQL Database Backup 1.2.1 is a free and open source software that will help us to automatically or manually backup the MySQL Database. I often confused on how to backup my existing MySQL database stored in my Windows XP box.
Hi to everyone someone know how to get an estimate about the size of one mysql table?
I mean I am planning to make a backup of all the mysql's table on all my server
but I'd like to know how big should be every dump table without make the physical dump.
There is some command which permit to do this one?
I am using mysql 5.1 on debian 6