Pages

Wednesday, August 25, 2010

MySQL:Databases DUMP with only limit records

MYSQL:TAKING MYSQL DATABASE BACKUP ONLY LIMIT RECORDS -




./mysqldump -uXXXX -pXXXXX --host=hostIP -P3306 --opt --where="1 limit 10000" --all-databases > /home/anilalpati/Desktop/dbdump.sql




Cheers!!!

2 comments:

B.S.Mahi said...

Hi Anil, nice blogspot. it is worth reading all posts, keep doing. Best Wishes

Anil Alpati said...

Thx mahi - Cheers!!!