RDS MariaDB: ERROR 1114 (HY000) at line LLL: The table 'XXX' is full

0

I am trying to import a 3GB MariaDB dump into my RDS MariaDB db.t3.medium with 50GB storage,
And I am getting this error:
ERROR 1114 (HY000) at line 20546: The table 'mdl_question_attempt_step_data' is full
(It is a Moodle LMS DB)

I have imported several DBs before, with not issue. but they were smaller then 1GB.

I am about to import a 50GB DB, and the RDS is set to "auto grow" the storage.
Should I do any pre import preparations?

已提問 3 年前檢視次數 1001 次
1 個回答
0

SOLVED
It probably too the auto storage scaling process to run for some moments (or an hour?)
And after I saw in the DB monitor that I have more free disk space, I ran the import command again, and... every thing finished successfully :-)

This time, I was monitoring the progress via CLI
pv ./moodledb.sql | mysql -h DDDDD.eu-west-1.rds.amazonaws.com -P 3306 -u XXX -p moodledb

已回答 3 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南