ERROR 1046 (3D000) at line 22: No database selected

[neuronetv]

I can't import a recent backup into zoneminder 1.30. I use the command:

Code: Select all

mysql -u root -p <zoneminder-backup-name>.sql

but it throws the error "ERROR 1046 (3D000) at line 22: No database selected". What can I do here?

[rockedge]

Try:

Code: Select all

mysql -u username -p database_name < file.sql

so ->

Code: Select all

mysql -u root -p zm_database_name < zm-database-backupfile.sql

or from the mysql command line :

Code: Select all

mysql> use db_name;
mysql> source backup-file.sql;

[neuronetv]

rockedge thankyou for your feedback