I just downloaded an alpha DB backup, dumped into a `.sql` file and want to execute it on a beta DB
I just downloaded an alpha DB backup, dumped into a
I scanned the
.sql.sql file and want to execute it on a beta DB now. The error I get iswrangler d1 execute rank-hub-beta --file backup.sql
🌀 Mapping SQL input into an array of statements
🌀 Parsing 35944 statements
🌀 We are sending 4 batch(es) to D1 (limited to 10000 statements per batch. Use --batch-size to override.)
✔ ⚠️ Too much SQL to send at once, this execution will be sent as 4 batches.
ℹ️ Each batch is sent individually and may leave your DB in an unexpected state if a later batch fails.
⚠️ Make sure you have a recent backup. Ok to proceed? … yes
🌀 Let's go
🌀 Executing on remote database rank-hub-beta (24b71fed-ab4c-44b4-94fb-c7eeb5c42190):
🌀 To execute on your local development database, pass the --local flag to 'wrangler d1 execute'
PRAGMA foreign_keys=OFF; CREATE TABLE d1_kv (key TEXT PRIMARY KEY, val...
✘ [ERROR] A request to the Cloudflare API (/accounts/8f4214243c247a1a0bb46647a55d5614/d1/database/24b71fed-ab4c-44b4-94fb-c7eeb5c42190/query) failed.
no such table: main.users [code: 7500]
If you think this is a bug, please open an issue at:
https://github.com/cloudflare/workers-sdk/issues/new/choosewrangler d1 execute rank-hub-beta --file backup.sql
🌀 Mapping SQL input into an array of statements
🌀 Parsing 35944 statements
🌀 We are sending 4 batch(es) to D1 (limited to 10000 statements per batch. Use --batch-size to override.)
✔ ⚠️ Too much SQL to send at once, this execution will be sent as 4 batches.
ℹ️ Each batch is sent individually and may leave your DB in an unexpected state if a later batch fails.
⚠️ Make sure you have a recent backup. Ok to proceed? … yes
🌀 Let's go
🌀 Executing on remote database rank-hub-beta (24b71fed-ab4c-44b4-94fb-c7eeb5c42190):
🌀 To execute on your local development database, pass the --local flag to 'wrangler d1 execute'
PRAGMA foreign_keys=OFF; CREATE TABLE d1_kv (key TEXT PRIMARY KEY, val...
✘ [ERROR] A request to the Cloudflare API (/accounts/8f4214243c247a1a0bb46647a55d5614/d1/database/24b71fed-ab4c-44b4-94fb-c7eeb5c42190/query) failed.
no such table: main.users [code: 7500]
If you think this is a bug, please open an issue at:
https://github.com/cloudflare/workers-sdk/issues/new/chooseI scanned the
backup.sqlbackup.sql with vim for "main.users" but couldn't find anything.