CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-sql
pratik amberkar
pratik amberkar

Reputation: 21

Import database problem in google SQL cloud

I have already host of my wordpress website on Google Cloud Platform using Google Cloud Compute Engine. Now I want to split my existing wordpress database and move to Google SQL Cloud to improve my website performance.

I'm creating successfully SQL instance on Google Cloud SQL cloud. I refer to this link but I got error when I'm uploading my wordpress database backup.

After creating database on Google Cloud SQL when I click on import button, it take few minutes and show import failed : error 1031 (hy000) table storage engine for wp_wcfm_daily_analysis doesn't have this option error.

Thanks in advance.

Upvotes: 0

Views: 583

Answers (1)

Andrei Tigau
Andrei Tigau

Reputation: 2048

In one of your import file there is the command that tries to change the storage engine from InnoDB to some other storage engine, probably to MyISAM.

As it is stated in the CloudSQL documentation:

InnoDB is the only supported storage engine for Second Generation instances because it is more resistant to table corruption than other MySQL storage engines, such as MyISAM.

You need to check in your sql file that you want to import, if you have the option : ENGINE = MyISAM attached to any CREATE TABLE command, and remove it.

You can also try to convert all your tables to InnoDB by using the following SQL code:

SET @DATABASE_NAME = 'name_of_your_db';

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

You can find here a related discussion.

Upvotes: 0

Related Questions