Comments (6)
anzhiyu-c
commented on May 20, 2024
1
python3 -m pip install sqlite3-to-mysql
Sorry to bother you, but I found a solution. I reported this error because I couldn't find Python.h, and I have two versions of python. I should execute it on python3.
Yum install python3-devel is then installed successfully. Sorry, please close this issue.
from sqlite3-to-mysql.
techouse
commented on May 20, 2024
Hi,
Can you provide more info? Please fill out the bug report template.
from sqlite3-to-mysql.
anzhiyu-c
commented on May 20, 2024
I guess my PIP version is too low
from sqlite3-to-mysql.
anzhiyu-c
commented on May 20, 2024
Hi, this is my installation error log. I understand that there seems to be a problem with the dependency of backports-datetime-fromisoformat. I found a report on this.
Installing backports-datetime-fromisoformat on Python 2 doesn't work
I am using the python3 installation
I executed the yum install python-devel.
Looking in indexes: https://pypi.doubanio.com/simple
Collecting sqlite3-to-mysql
Using cached https://pypi.doubanio.com/packages/26/9b/eab8bde9039481af1f36029bc678f1be0c2bd663b1097fc292ba4f8e057f/sqlite3_to_mysql-1.4.15-py2.py3-none-any.whl (18 kB)
Requirement already satisfied: tabulate in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (0.8.9)
Collecting backports-datetime-fromisoformat>=1.0.0
Downloading https://pypi.doubanio.com/packages/20/15/4bc39da78d00da480ff627398ad25770be1f0c3cf40ea9bc5e9030b441fb/backports-datetime-fromisoformat-1.0.0.tar.gz (10 kB)
Preparing metadata (setup.py) ... done
Requirement already satisfied: tqdm>=4.35.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (4.64.0)
Requirement already satisfied: pytimeparse>=1.1.8 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.1.8)
Requirement already satisfied: mysql-connector-python>=8.0.18 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.28)
Requirement already satisfied: Unidecode>=1.2.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.3.4)
Requirement already satisfied: Click>=7.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.4)
Requirement already satisfied: simplejson>=3.16.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (3.17.6)
Requirement already satisfied: packaging>=20.3 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (21.3)
Requirement already satisfied: six>=1.12.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.16.0)
Requirement already satisfied: importlib-metadata in /usr/local/lib/python3.6/site-packages (from Click>=7.0->sqlite3-to-mysql) (4.8.3)
Requirement already satisfied: protobuf>=3.0.0 in /usr/local/lib64/python3.6/site-packages (from mysql-connector-python>=8.0.18->sqlite3-to-mysql) (3.19.4)
Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /usr/local/lib/python3.6/site-packages (from packaging>=20.3->sqlite3-to-mysql) (3.0.8)
Requirement already satisfied: importlib-resources in /usr/local/lib/python3.6/site-packages (from tqdm>=4.35.0->sqlite3-to-mysql) (5.4.0)
Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (4.1.1)
Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (3.6.0)
Building wheels for collected packages: backports-datetime-fromisoformat
Building wheel for backports-datetime-fromisoformat (setup.py) ... error
ERROR: Command errored out with exit status 1:
command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-izi5im4d
cwd: /tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/
Complete output (20 lines):
running bdist_wheel
running build
running build_py
creating build
creating build/lib.linux-x86_64-3.6
creating build/lib.linux-x86_64-3.6/backports
copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
running build_ext
building 'backports._datetime_fromisoformat' extension
creating build/temp.linux-x86_64-3.6
creating build/temp.linux-x86_64-3.6/backports
creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
#include <Python.h>
^
编译中断。
error: command 'gcc' failed with exit status 1
----------------------------------------
ERROR: Failed building wheel for backports-datetime-fromisoformat
Running setup.py clean for backports-datetime-fromisoformat
Failed to build backports-datetime-fromisoformat
Installing collected packages: backports-datetime-fromisoformat, sqlite3-to-mysql
Running setup.py install for backports-datetime-fromisoformat ... error
ERROR: Command errored out with exit status 1:
command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-6wcqf8o_/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat
cwd: /tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/
Complete output (20 lines):
running install
running build
running build_py
creating build
creating build/lib.linux-x86_64-3.6
creating build/lib.linux-x86_64-3.6/backports
copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
running build_ext
building 'backports._datetime_fromisoformat' extension
creating build/temp.linux-x86_64-3.6
creating build/temp.linux-x86_64-3.6/backports
creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
#include <Python.h>
^
编译中断。
error: command 'gcc' failed with exit status 1
----------------------------------------
ERROR: Command errored out with exit status 1: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-6wcqf8o_/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat Check the logs for full command output.
Hi,
Can you provide more info? Please fill out the bug report template.
from sqlite3-to-mysql.
techouse
commented on May 20, 2024
What Python version are you on? That package only installs on Python 3.4, 3.5 and 3.6. From the title of the issue, I gathered you're on 3.7.9 but it looks like you're on 3.6.x?
https://github.com/techouse/sqlite3-to-mysql/blob/master/setup.py#L24
from sqlite3-to-mysql.
anzhiyu-c
commented on May 20, 2024
Sorry, there are two versions at the same time, but I installed it with version 3.6.8 of python.
Here is my complete run command, because I have two versions of python, so I used python3 -m pip😭
[root@czw ~]# python3 -m pip install sqlite3-to-mysql
Looking in indexes: https://pypi.doubanio.com/simple
Collecting sqlite3-to-mysql
Using cached https://pypi.doubanio.com/packages/26/9b/eab8bde9039481af1f36029bc678f1be0c2bd663b1097fc292ba4f8e057f/sqlite3_to_mysql-1.4.15-py2.py3-none-any.whl (18 kB)
Requirement already satisfied: tqdm>=4.35.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (4.64.0)
Requirement already satisfied: Unidecode>=1.2.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.3.4)
Collecting backports-datetime-fromisoformat>=1.0.0
Downloading https://pypi.doubanio.com/packages/20/15/4bc39da78d00da480ff627398ad25770be1f0c3cf40ea9bc5e9030b441fb/backports-datetime-fromisoformat-1.0.0.tar.gz (10 kB)
Preparing metadata (setup.py) ... done
Requirement already satisfied: Click>=7.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.4)
Requirement already satisfied: simplejson>=3.16.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (3.17.6)
Requirement already satisfied: six>=1.12.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.16.0)
Requirement already satisfied: tabulate in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (0.8.9)
Requirement already satisfied: mysql-connector-python>=8.0.18 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.28)
Requirement already satisfied: pytimeparse>=1.1.8 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.1.8)
Requirement already satisfied: packaging>=20.3 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (21.3)
Requirement already satisfied: importlib-metadata in /usr/local/lib/python3.6/site-packages (from Click>=7.0->sqlite3-to-mysql) (4.8.3)
Requirement already satisfied: protobuf>=3.0.0 in /usr/local/lib64/python3.6/site-packages (from mysql-connector-python>=8.0.18->sqlite3-to-mysql) (3.19.4)
Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /usr/local/lib/python3.6/site-packages (from packaging>=20.3->sqlite3-to-mysql) (3.0.8)
Requirement already satisfied: importlib-resources in /usr/local/lib/python3.6/site-packages (from tqdm>=4.35.0->sqlite3-to-mysql) (5.4.0)
Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (3.6.0)
Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (4.1.1)
Building wheels for collected packages: backports-datetime-fromisoformat
Building wheel for backports-datetime-fromisoformat (setup.py) ... error
ERROR: Command errored out with exit status 1:
command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-2m2glxuo
cwd: /tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/
Complete output (20 lines):
running bdist_wheel
running build
running build_py
creating build
creating build/lib.linux-x86_64-3.6
creating build/lib.linux-x86_64-3.6/backports
copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
running build_ext
building 'backports._datetime_fromisoformat' extension
creating build/temp.linux-x86_64-3.6
creating build/temp.linux-x86_64-3.6/backports
creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
#include <Python.h>
^
编译中断。
error: command 'gcc' failed with exit status 1
----------------------------------------
ERROR: Failed building wheel for backports-datetime-fromisoformat
Running setup.py clean for backports-datetime-fromisoformat
Failed to build backports-datetime-fromisoformat
Installing collected packages: backports-datetime-fromisoformat, sqlite3-to-mysql
Running setup.py install for backports-datetime-fromisoformat ... error
ERROR: Command errored out with exit status 1:
command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-jb5_vlvf/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat
cwd: /tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/
Complete output (20 lines):
running install
running build
running build_py
creating build
creating build/lib.linux-x86_64-3.6
creating build/lib.linux-x86_64-3.6/backports
copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
running build_ext
building 'backports._datetime_fromisoformat' extension
creating build/temp.linux-x86_64-3.6
creating build/temp.linux-x86_64-3.6/backports
creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
#include <Python.h>
^
编译中断。
error: command 'gcc' failed with exit status 1
----------------------------------------
ERROR: Command errored out with exit status 1: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-jb5_vlvf/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat Check the logs for full command output.
[root@czw ~]#
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
- After migration and post-migration HOT 1
- After migration and post-migration HOT 4
- sqlite3mysql: command not found ubuntu 22.04 installation or usage issue HOT 1
- Export to sql file for mysql HOT 1
- 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.