invite-manager-bot icon indicating copy to clipboard operation
invite-manager-bot copied to clipboard

ER_NO_SUCH_TABLE when connecting to mysql

Open MartTo22 opened this issue 4 years ago • 5 comments

I keep getting a NO_SUCH_TABLE error when connecting to the mysql database, what should I do? image

MartTo22 avatar Aug 24 '20 19:08 MartTo22

run db scripts given in script/db folder

chaun14 avatar Aug 31 '20 16:08 chaun14

How do I do that? (I’m kind of a noob with stuff like this sorry)

On Mon, Aug 31, 2020 at 09:36 chaun14 [email protected] wrote:

run db scripts given in script/db folder

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/SideProjectGuys/invite-manager-bot/issues/174#issuecomment-683891510, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQS7JNQORS4DZGSZZ5U7DZDSDPGSHANCNFSM4QJ2X2OA .

MartTo22 avatar Aug 31 '20 16:08 MartTo22

learn how to use mysql :/

chaun14 avatar Aug 31 '20 17:08 chaun14

mysql -u root -p
*inserts password if authed*
CREATE DATABASE im_0;
use im_0;
source /root/invite-manager-bot/scripts/db/setup_db0.sql;


CREATE DATABASE im_1;
use im_1;
source /root/invite-manager-bot/scripts/db/setup_dbx.sql;

This is how I did it you might need to play around with it to make it work.

SyntaxDragon avatar Sep 11 '20 20:09 SyntaxDragon

Alright, thank you so much!

On Fri, Sep 11, 2020 at 13:23 dragonblitz10 [email protected] wrote:

mysql -u root -p

inserts password if authed

CREATE DATABASE im_0;

use im_0;

source /root/invite-manager-bot/scripts/db/setup_db0.sql;

CREATE DATABASE im_1;

use im_1;

source /root/invite-manager-bot/scripts/db/setup_dbx.sql;

This is how I did it you might need to play around with it to make it work.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/SideProjectGuys/invite-manager-bot/issues/174#issuecomment-691295348, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQS7JNWYLUHGPLZ7LGEMMP3SFKBMBANCNFSM4QJ2X2OA .

MartTo22 avatar Sep 11 '20 20:09 MartTo22