none
Trying to import 16mb innoDB sql dump causes error RRS feed

  • Question

  • Hi!

    I've just setup Azure Database for MySQL server and trying to import my Prestashop 1.6 MySQL InnoDB .sql dump to the server. Trying with this command: mysql -u myUser -p -h myHost.mysql.database.azure.com databaseName < myDump.sql runs for about minute and a half and then throws this error: ERROR 1030 (HY000) at line 30463: Got error 1 from storage engine. It creates most of the databases but then does not ever finish. Is there a bug in the system?

    Monday, May 29, 2017 3:53 PM

Answers

  • Nevermind, figured it out! Took a look at that line and had myIsam engine table there, changed it to InnoDB and all went fine :)
    • Marked as answer by Sunil Kamath Monday, May 29, 2017 4:56 PM
    Monday, May 29, 2017 4:14 PM