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,

to restore them you need to use

--databases DB_NAME1 DB_NAME2 DB_NAME3

instead of --all-databases

I used the above command iam getting the below same error

[root@itsupport ~]# mysql -u root -pecare2@ --databases networkinfo systeminfo > alldatabases.sql
mysql: unknown option '--databases'

Thanks

That's because that switch doesn't exist with the mysql command.

For this command the databases need to exist or the alldatabases.sql script needs to contain the CREATE DATABASE queries for the databases.

Thank u very much,The above command is working for restore