31 Jan 11 How to backup/restore huge mysql tables in mysql?

In general i have seen people using GUI tools like MySqlYog to take backup and restore them. Point of consideration is that the table size are sometimes near 5GB.

Unimaginable, right!!

This process will take more than 4 hours to backup and even more to restore it.

So here is a very simple solution to do the stuff, use MySql console to do so.

mysqldump -u USER_NAME -p DB_NAME TABLE_NAME > LOCATION/BACKUP.sql

Above, code will let you take the backup of the table of specific database.

Once the your task is done, and you want to restore the table.

mysql -u USER_NAME -p DB_NAME < LOCATION/BACKUP.sql