Operating System - HP-UX
1748011 Members
4040 Online
108757 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.