Ok thanks, but the table to follow, is it okay for you, also seeing the diagram and r?

|
2021-04-12 10:34:32
Can anyone help me out
Master Yoda 2021-04-12 19:51:43
2021-04-12 10:33:27
In our environment, we had a host reboot and MySQL got shutdown without clean and while startup we had error of tablespace and in log stated for innnodb force recovery.

How much time it will take ?
Any idea. It is in innnodb force recovery=0

Start with low 1,2 and so on. If you could start and are able to export your db fine. With lower number, chances of recovery are there. Otherwise you might have to use backup previously taken.

Liran 2021-04-13 10:53:47
Hi guys, I try to install mysql on ubuntu. but for some reason the port 3306 doesn’t open
Liran 2021-04-13 10:54:07
when I telnet xxx.xxx.xxx.xxx 3306 I get – no route to host
MasterZiv 2021-04-13 10:56:23
Liran 2021-04-13 10:54:07
when I telnet xxx.xxx.xxx.xxx 3306 I get – no route to host

This is pretty possible, not all communications are allowed between all hosts.

Liran 2021-04-13 11:21:14
What’s the difference between Cluster and replication (master-slaves)?
Liran 2021-04-13 16:54:45
mysql_en-9145.jpg
someone knows why im getting 0 in nodes number?
eg2710 2021-04-16 13:41:31
Can anyone help me in verifying the correctness of an ER diagram?
piterden 2021-04-16 13:47:24
eg2710 2021-04-16 13:41:31
Can anyone help me in verifying the correctness of an ER diagram?

Show DDL with text

eg2710 2021-04-16 14:18:07
Ok wait
eg2710 2021-04-16 14:20:23
er diagram
eg2710 2021-04-16 14:21:34
I don’t have ddl, but I have the relational modelù
eg2710 2021-04-16 14:22:22
my doubt is the relationship between user and follow
piterden 2021-04-16 14:23:13
eg2710 2021-04-16 14:20:23
er diagram

First of all write all names in English.

piterden 2021-04-16 14:23:54
eg2710 2021-04-16 14:21:34
I don’t have ddl, but I have the relational modelù

Diagram is nothing. And almost everything there is wrong

piterden 2021-04-16 14:24:26
Write DDL. Diagram is generating from DDL
MasterZiv 2021-04-16 14:25:52
eg2710 2021-04-16 14:20:23
er diagram

Wow it’s kinda I have this Deja Vu feeling …

MasterZiv 2021-04-16 14:26:36
eg2710 2021-04-16 14:22:22
my doubt is the relationship between user and follow

user and follow WHAT?

eg2710 2021-04-16 14:44:07
CREATE TABLE users(

ud_users int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
username varchar(20) NOT NULL,
name varchar(20) NOT NULL,
email varchar(240) NOT NULL,
birthdate date NOT NULL,
password varchar(20) NOT NULL,
img_profile varchar(240) NOT NULL

);

CREATE TABLE Post(

id_post int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
img_post varchar(240) NOT NULL,
comment varchar(80) NOT NULL,
postdate timestamp NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE like_post(

id_like int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
like_post tinyint NOT NULL,
id_post int(5) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_post) REFERENCES post(id_post) ,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE comment(

id_comment int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
comment varchar(80) NOT NULL,
id_post int(5) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_post) REFERENCES post(id_post) ,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE follow(

id_follow int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
sending_user varchar(20) NOT NULL,
recipient_user varchar(20) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

eg2710 2021-04-16 14:44:13
DDL
piterden 2021-04-16 17:44:29
eg2710 2021-04-16 14:44:07
CREATE TABLE users(

ud_users int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
username varchar(20) NOT NULL,
name varchar(20) NOT NULL,
email varchar(240) NOT NULL,
birthdate date NOT NULL,
password varchar(20) NOT NULL,
img_profile varchar(240) NOT NULL

);

CREATE TABLE Post(

id_post int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
img_post varchar(240) NOT NULL,
comment varchar(80) NOT NULL,
postdate timestamp NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE like_post(

id_like int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
like_post tinyint NOT NULL,
id_post int(5) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_post) REFERENCES post(id_post) ,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE comment(

id_comment int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
comment varchar(80) NOT NULL,
id_post int(5) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_post) REFERENCES post(id_post) ,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

CREATE TABLE follow(

id_follow int(5) NOT NULL PRIMARY KEY AUTOINCREMENT,
sending_user varchar(20) NOT NULL,
recipient_user varchar(20) NOT NULL,
id_users int(5) NOT NULL,
FOREIGN KEY(id_users) REFERENCES users(id_users)

);

1. Rename tables to plural.
2. Rename each PK to the simple id
3. Make each PK unsigned

eg2710 2021-04-16 20:39:52
Ok thanks, but the table to follow, is it okay for you, also seeing the diagram and r?
Liran 2021-04-18 08:59:05
Does anyone has a good tutorial for mySQL clustering? i am having trouble with configuring one
TTHIRDWHEEL 2021-04-19 11:50:45
Hey guys
I’m new to MySQL and I have this work I’m supposed to submit next week.
Create a database for JKUAT university
Create tables Campuses, colleges, schools, departments, courses and students
And describe them
Anyone who can help?
TTHIRDWHEEL 2021-04-19 12:40:25
Sure thing
e 2021-04-19 12:43:47
TTHIRDWHEEL 2021-04-19 11:50:45
Hey guys
I’m new to MySQL and I have this work I’m supposed to submit next week.
Create a database for JKUAT university
Create tables Campuses, colleges, schools, departments, courses and students
And describe them
Anyone who can help?

slide DM.

MasterZiv 2021-04-19 12:55:45
Ask specific questions, no one will do your hometask for you
iatharva 2021-04-19 12:57:47
Then practice
iatharva 2021-04-19 12:58:00
I’ll suggest sqlbolt.com
iatharva 2021-04-19 12:58:09
Oof
iatharva 2021-04-19 12:58:23
Then Google is ur friend
button_idli 2021-04-19 12:59:06
Select * from MySQL(EN) where name=Klaus
button_idli 2021-04-19 13:00:27
It’s a query
piterden 2021-04-19 20:06:12
Klaus, the purpose of this group is not to help students with solving exams tasks. This is thing which you should do self
piterden 2021-04-19 20:16:02
Stop to be noob
|