MySQL Forums
Forum List  »  MySQL Administrator

Re: Problem with backup.
Posted by: Lalit Shakya
Date: March 18, 2012 09:33PM

you back file large try to compress this

try like this mysqldump --add-drop-table -h dbhost -u dbuser -p dbname (tablename tablename ... ) | gzip -c > data.sql.gz


you can also lock the tables if your database is live

Thanks
Lalit

Options: ReplyQuote


Subject
Written By
Posted
February 29, 2012 05:05AM
Re: Problem with backup.
March 18, 2012 09:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.