I want to take forceful database backup for mysql .I am using
mysqldump -f --all-databases >file.sql
command but it was showing me error .
How should i take forceful database backupwhat errors are you getting?
have you tried running phpMyAdmin (<!-- m --><a class="postlink" href="http://phpmyadmin.net">http://phpmyadmin.net</a><!-- m -->)I have a table with name database .It is giving error that information not found about table database.
And also i have to do automated backp system so every time it is not possible for mr to check weather a error occur or not.So i want to take forceful database backup.
Also I want to know that when I take a backup at the same time if someone want's to add something to database then what will hapen.If backup locks the table then will it allow to add something to database or not.
Thanking you.you have a table called "database" then that is your problem. database is a reserved word in mysql. try this
mysqldump --add-locks --quick
that will prevent people from adding to the db, also will back up the whole database.
if you don't have --quick in there it will load into memory and ig it is a big database then it will cause problems.
mysqldump -f --all-databases >file.sql
command but it was showing me error .
How should i take forceful database backupwhat errors are you getting?
have you tried running phpMyAdmin (<!-- m --><a class="postlink" href="http://phpmyadmin.net">http://phpmyadmin.net</a><!-- m -->)I have a table with name database .It is giving error that information not found about table database.
And also i have to do automated backp system so every time it is not possible for mr to check weather a error occur or not.So i want to take forceful database backup.
Also I want to know that when I take a backup at the same time if someone want's to add something to database then what will hapen.If backup locks the table then will it allow to add something to database or not.
Thanking you.you have a table called "database" then that is your problem. database is a reserved word in mysql. try this
mysqldump --add-locks --quick
that will prevent people from adding to the db, also will back up the whole database.
if you don't have --quick in there it will load into memory and ig it is a big database then it will cause problems.