locked
error : MySQL #1030 - Got error 1 from storage engine RRS feed

  • Question

  • It has been about three days I have tried to run a script on my MySQL server, but it continuously gives me an error.  I have tried the code on different machines, and it works completely fine.  However, my Azure server does not run the script,and it gives the same error the error is #1030 - Got error 1 from storage engine.  I have used MySQL Workbench and PhpMyAdmin, but none of them works.  Your help is highly appreciated.
    Monday, August 13, 2018 2:26 PM

All replies

  • Hi Bryar87,

    What is the script attempting to do? And by different machines, you are referring to non-Azure MySQL instances? It is only the Azure Database for MySQL where your script fails?

    Azure Database for MySQL – Can’t restore database with error “Got error 1 from storage engine”

    Please provide additional details. Thank you!

    Wednesday, August 15, 2018 6:38 PM
  • thanks i find my problem

    azure MySQL database don't support  engine=myisam change to  engine=INNODB


    CREATE TABLE IF NOT EXISTS `banners` (
      `id` int(255) NOT NULL AUTO_INCREMENT,
      `user` int(255) NOT NULL DEFAULT '0',
      KEY `type` (`type`)
    )  
    engine=myisam DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    this code change to

    CREATE TABLE IF NOT EXISTS `banners` (
      `id` int(255) NOT NULL AUTO_INCREMENT,
      `user` int(255) NOT NULL DEFAULT '0',
      KEY `type` (`type`)
    )  
    engine=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;




    Thursday, August 16, 2018 1:23 PM