Operating System - HP-UX
1846617 Members
1721 Online
110256 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.