Comments (3)
Hi and thanks for the report, however, I'm not sure how to address this.
Did you check which process used how much memory?
What other processes were you running?
How much did MySQL (the usual suspect) consume?
Have you tried running it with Python 3.10?
Have you tried running it on a system with more RAM and profile it?
What's in the actions table?
Also, next time you run it, run it with --debug
which will dump all the exceptions to the console.
from sqlite3-to-mysql.
I tried again with more free ram and it said it has done, but the size of the db hasn't changed.
log:
2022-03-23 00:06:55 INFO Transferring table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:56 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:57 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:57 INFO Adding unique index to column "player_id" in table players
2022-03-23 00:06:57 INFO Transferring table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Adding unique index to column "action_identifier" in table ActionIdentifiers
2022-03-23 00:06:57 INFO Transferring table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Adding unique index to column "identifier" in table worlds
2022-03-23 00:06:58 INFO Transferring table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:13 INFO Adding unique index to column "identifier" in table ObjectIdentifiers
2022-03-23 00:07:14 INFO Transferring table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:14 INFO Adding unique index to column "name" in table sources
2022-03-23 00:07:15 INFO Transferring table actions
2022-03-23 08:23:29 INFO Adding index to column "x, y, z, world_id" in table actions
2022-03-23 08:23:30 INFO Adding index to column "x, y, z, world_id" in table actions
2022-03-23 08:24:54 INFO Adding foreign key to actions.player_id referencing players.id
2022-03-23 08:26:10 INFO Adding foreign key to actions.source referencing sources.id
2022-03-23 08:27:20 INFO Adding foreign key to actions.old_object_id referencing ObjectIdentifiers.id
2022-03-23 08:28:34 INFO Adding foreign key to actions.object_id referencing ObjectIdentifiers.id
2022-03-23 08:29:51 INFO Adding foreign key to actions.world_id referencing worlds.id
2022-03-23 08:31:00 INFO Adding foreign key to actions.action_id referencing ActionIdentifiers.id
2022-03-23 08:32:10 INFO Done!
from sqlite3-to-mysql.
Whoa, transferring the actions
table for 8h 15min 😱 What do you have in there LOL?
I'm afraid I'll need more info here to give you some more feedback and/or potentially fix this.
from sqlite3-to-mysql.
Related Issues (20)
- Tried migration using Docker container but didn't work HOT 14
- Request to Add sqlite3mysql example command similar to running from docker
- Data Migration with incorrect values when values are out of data range instead of an error. HOT 8
- Support for Data migration alone HOT 7
- Tool is messing with schema in auto increment HOT 1
- It displayed problem when I attempted to migrate data from SQLite to MySQL. HOT 5
- BOOL datatype not converted correctly to MySQL HOT 1
- Don't add indices if they are present (or: option to only transfer data) HOT 1
- An exception occurred while migrating data HOT 5
- Migration fails with `Cannot create a JSON value from a string with CHARACTER SET 'binary'` HOT 2
- Skip errors HOT 3
- sqlite3mysql is not defined HOT 4
- sqlite3-to-mysql privat problem HOT 3
- Default host: 172.22.0.1 HOT 2
- 1427 (42000) error when Transferring table HOT 8
- Incomprehensible error message: invalid column type HOT 4
- Statically Binary missing HOT 3
- ModuleNotFoundError: No module named 'packaging' HOT 1
- Unsupported data type INTEGER UNSIGNED HOT 4
- I would like to be able to migrate the number of digits in numeric columns as well. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlite3-to-mysql.