https://supertokens.com/ logo
Join Discord
Powered by
Hey team, I wanted to migrate from 6.0.0 to 7.0.0,...
# support-questions-legacy
h
Hey team, I wanted to migrate from 6.0.0 to 7.0.0, where can I find any script or command for this? I am using docker version of the core with mysql db. Thank you in advance.
r
hey @hehohesda_12345 are you self hosting or using managed core?
h
Oh, self hosted one.
r
right. See the changelog.md in the supertokens-core github repo
h
Okay great, thanks I was looking for it in the releases :|.
Hi, I migrated the db successfully, I just wanted to let you know that the third last command in this section https://github.com/supertokens/supertokens-core/blob/master/CHANGELOG.md#migration-steps-for-sql gave me error, no foreign key found. There was no foreign key in that table.
Copy code
ALTER TABLE emailpassword_pswd_reset_tokens 
  DROP FOREIGN KEY emailpassword_pswd_reset_tokens_ibfk_1;
Copy code
Error Code: 1091. Can't DROP 'emailpassword_pswd_reset_tokens_ibfk_1'; check that column/key exists
For mysql
r
@sattvikc can you please see?
s
sure, looking into it
@hehohesda_12345 rest of the queries passed ?
would you mind sharing the db dump before and after migrations for further investigation?
h
Yes rest of the qeuries work just fine, I had to add the prefix for the table_name.
By db dump you mean the sql dump file ? I can provide you that by tomorrow.
s
yes sure
yes I mean the SQL dump
h
I used the latest version of 6.0 mysql plugin, and it error occurred again.
The problem is prefix tdp is also applied to foreign key names, hence the query didn't worked.
You changelog md is perfect.
🌟
s
oh right, glad it worked for you
5 Views
PreviousNext
Powered by