How to restore mysqldump --all-databases backup
Dear all,
Iam trying to take all datbases backup using the below command
mysqldump -u root -pecare2@ --all-databases > alldatabases.sql
The above given command was working fine without any problem.The problem is i
was not able to restore all the databases.Iam using the below command to restore
all the databases.
mysql -u root -pecare2@ --all-databases < alldatabases.sql
But,when i execute this command iam getting the below give error .
[root@itsupport ~]# mysql -u root -pecare2@ --all-databases < alldatabases.sql
mysql: unknown option '--all-databases'
Can any one help me on the command how to restore all database
Thanks in advance,
Last edited by ramecare; 07-21-2011 at 06:05 AM.
|