Hello,
I am trying to restore a site that was hosted on another DA box. When trying to restore just the databases I get the following:
----
Unable to restore database wilds_affiliate.sql to wilds_affiliate : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_affiliate.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_billing.sql to wilds_billing : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_billing.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 29
Unable to restore database wilds_bot.sql to wilds_bot : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_bot.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Unable to restore database wilds_directory.sql to wilds_directory : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_directory.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Unable to restore database wilds_forum.sql to wilds_forum : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_forum.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 11
Unable to restore database wilds_help.sql to wilds_help : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_help.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_im.sql to wilds_im : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_im.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_jobs.sql to wilds_jobs : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_jobs.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_mail.sql to wilds_mail : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_mail.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
Unable to restore database wilds_members.sql to wilds_members : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_members.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_pages.sql to wilds_pages : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_pages.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
Unable to restore database wilds_panel.sql to wilds_panel : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_panel.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 34
Unable to restore database wilds_personals.sql to wilds_personals : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_personals.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_phpBB1.sql to wilds_phpBB1 : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_phpBB1.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 18
Unable to restore database wilds_processing.sql to wilds_processing : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_processing.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 34
Unable to restore database wilds_webmail.sql to wilds_webmail : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_webmail.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
----
My box is a standard install and I have been told the other box is also a standard install.
Any suggestions? Really trying to get this site moved tonight
Thanks!
Dale
I am trying to restore a site that was hosted on another DA box. When trying to restore just the databases I get the following:
----
Unable to restore database wilds_affiliate.sql to wilds_affiliate : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_affiliate.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_billing.sql to wilds_billing : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_billing.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 29
Unable to restore database wilds_bot.sql to wilds_bot : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_bot.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Unable to restore database wilds_directory.sql to wilds_directory : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_directory.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Unable to restore database wilds_forum.sql to wilds_forum : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_forum.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 11
Unable to restore database wilds_help.sql to wilds_help : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_help.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_im.sql to wilds_im : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_im.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_jobs.sql to wilds_jobs : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_jobs.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_mail.sql to wilds_mail : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_mail.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
Unable to restore database wilds_members.sql to wilds_members : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_members.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
Unable to restore database wilds_pages.sql to wilds_pages : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_pages.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
Unable to restore database wilds_panel.sql to wilds_panel : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_panel.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 34
Unable to restore database wilds_personals.sql to wilds_personals : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_personals.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6
Unable to restore database wilds_phpBB1.sql to wilds_phpBB1 : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_phpBB1.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 18
Unable to restore database wilds_processing.sql to wilds_processing : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_processing.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 34
Unable to restore database wilds_webmail.sql to wilds_webmail : ERROR 1064 at line 20 in file: '/home/wilds/backups/backup/wilds_webmail.sql': 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12
----
My box is a standard install and I have been told the other box is also a standard install.
Any suggestions? Really trying to get this site moved tonight

Thanks!
Dale