Can't restore MySQL database

Please please help with this. I am moving servers, I've moved the home directory however when I try restore the MySQL database I get the following:

root@icebox [/home/weak/www]# mysql -u weak_hgf1 -p weak_hgf1 < weak_hgf.sql
Enter password:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 6
When I try to force it to upload I get this;

[/home/weak/www]# mysql --force -u weak_hgf1 -p weak_hgf1 < weak_hgf.
Enter password:
ERROR 1146 at line 137: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 138: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 139: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 140: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 141: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 142: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 143: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 144: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 145: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 146: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 147: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 148: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
ERROR 1146 at line 149: Table 'weak_hgf1.ibf_admin_logs' doesn't exist
For every single table.

Please help, I'm desperate.

 

 

 

 

Top