Operating System - HP-UX
1844382 Members
3452 Online
110232 Solutions
New Discussion

Problems restoring mysql database backups

 
Aigini
Occasional Contributor

Problems restoring mysql database backups

Hi,

I tried to restore my decompressed database 'cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql'

using the command :

mysql -h localhost -u root -proot123 info < /backups/daily/cyberview_db_2809/cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql

but there was no restoration.

I checked the /var/lib/mysql directory where all restored databases are located, and in the 'info' folder, the only script that was available was 'db.opt'. Nothing else was created.

Why is this? Pls help.

Tqs.