~라는 데이터베이스가 존재하지 않음: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1049, "Unknown database ''") (Background on this error at: https://sqlalche.me/e/20/e3q8)Traceback: 확인해야할 파일

앱 실행중 에러가 터졌다. 

기존 studentdb를 사용하고있었는데 강사님이 진행중 문제가 생겨 mydb로 생성했고, 

샘플 프로젝트를 주시고 실행하니 

하필 studentdb가 잘 생성됬었던 나는 오히려 db connect 에러가 터진것.

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1049, "Unknown database 'mydb'") (Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback:
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\streamlit\runtime\scriptrunner\exec_code.py", line 129, in exec_func_with_error_handling
    result = func()
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\streamlit\runtime\scriptrunner\script_runner.py", line 689, in code_to_exec
    exec(code, module.__dict__)  # noqa: S102
    ~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\app.py", line 28, in <module>
    init_table()
    ~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\db.py", line 117, in init_table
    with engine.begin() as conn:
         ~~~~~~~~~~~~^^
File "C:\Users\playdata2\anaconda3\Lib\contextlib.py", line 141, in __enter__
    return next(self.gen)
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 3257, in begin
    with self.connect() as conn:
         ~~~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 3293, in connect
    return self._connection_cls(self)
           ~~~~~~~~~~~~~~~~~~~~^^^^^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 145, in __init__
    Connection._handle_dbapi_exception_noconnection(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        err, dialect, engine
        ^^^^^^^^^^^^^^^^^^^^
    )
    ^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2448, in _handle_dbapi_exception_noconnection
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 143, in __init__
    self._dbapi_connection = engine.raw_connection()
                             ~~~~~~~~~~~~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 3317, in raw_connection
    return self.pool.connect()
           ~~~~~~~~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\pool\base.py", line 448, in connect
    return _ConnectionFairy._checkout(self)
           ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\pool\base.py", line 1272, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout
    rec = pool._do_get()
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get
    with util.safe_reraise():
         ~~~~~~~~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 121, in __exit__
    raise exc_value.with_traceback(exc_tb)
File "G:\study\sk_playdata\study_ai\python_workspace\day12_crawling\auto_crawler\venv\Lib\site-packages\sqlalchemy\pool\impl.py", line 175, in _do_get
    return self._create_connection()
           ~~~~~~~~~~~~~~~~~~~~~~~^^
File "G:\study\sk_playdata\study_ai\python_workspace

 

 

 

 

 

대표적인 파일 두개를 확인하자.

.env 파일에 있는 정보 수정.

db 커넥트하는 모듈 수정.

 

 

 

 

 

 

완료