Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
Trying to restore database but it's creating an empty database. Here is the command:
mysql -uusername -ppassword databasename < file.sql
Also tried importing the .sql file using phpMyAdmin but it's still a blank database. Is there anything missing?
Any help is appreciated.
1. Make sure the backup is not empty (tip from "basicprogrammer" in open discussion)
2. If so, check the permissions of the MySQL account used for backup
3. Start mysqldump manually with the option -log-error=name invoked, where name ist the full path to a logfile (e. g. ~/dump.log)
You can also check syslog for mysql messages.
It seems to be more an issue with mysql than automysqlbackup.
There's an option to include the database drop and create statements into the backup - CREATE_DATABASE.
If this is set to "no" you might need to create the database (sometimes aka schema) before you can restore the dump into it.
For troubleshooting try flipping whatever you have it set to now and see if you get a more helpful error.