If I change table B name will it destroy the FKs?

|
MasterZiv 2022-01-11 11:14:22
Liran 2022-01-11 10:31:29
how can I know what each of this parameters are for
mysql -B -u root test -h localhost -p -N -e
-B / -N / -e ?

man mysql

Liran 2022-01-11 16:44:34
whats the best+fast way to create/import big table for testing on mySQL?
kavrajguddu 2022-01-11 17:12:02
Thank you🙏
svart 2022-01-11 17:40:43
Liran 2022-01-11 16:44:34
whats the best+fast way to create/import big table for testing on mySQL?

use any kind of testing tool. They can usually populate some data as well. Look at sysbench, tpcc or anything similar

SMTABL 2022-01-11 18:04:47
Thank you bro for ur support
Suri 2022-01-12 11:19:05
Sahu Sudheer:
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1

Can any one please explain:
When will be the above job executed?

What does MyQctoolProd mean??

If any thing goes wrong where should we check?

MasterZiv 2022-01-12 11:24:58
Suri 2022-01-12 11:19:05
Sahu Sudheer:
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1

Can any one please explain:
When will be the above job executed?

What does MyQctoolProd mean??

If any thing goes wrong where should we check?

This stuff is not related to mySQL

Suri 2022-01-12 11:25:59
This is a cron job for back up
MasterZiv 2022-01-12 11:26:18
Suri 2022-01-12 11:25:59
This is a cron job for back up

Yes, and it is not related to mySQL

MasterZiv 2022-01-12 11:26:52
Suri 2022-01-12 11:25:59
This is a cron job for back up

It is Linux/Unix problem

Suri 2022-01-12 11:27:01
Okay
MasterZiv 2022-01-12 11:27:32
Suri 2022-01-12 11:19:05
Sahu Sudheer:
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1

Can any one please explain:
When will be the above job executed?

What does MyQctoolProd mean??

If any thing goes wrong where should we check?

Read man cron for understanding crontab entries

Suri 2022-01-12 11:27:46
Okay
Thanks
MasterZiv 2022-01-12 11:30:27
Suri 2022-01-12 11:19:05
Sahu Sudheer:
00 22 * * * /db_apps/mysql/cronjob/mysqlbackup.sh MyQctoolProd> /tmp/mysqlbackup_MyQctoolProd.log 2>&1

Can any one please explain:
When will be the above job executed?

What does MyQctoolProd mean??

If any thing goes wrong where should we check?

Neither one can tell you what is in your bash script and where to look for diagnostics it produces.

You must read the script

Hussain 2022-01-12 17:29:50
Hi friends learn complete MySQL DBA step by step

https://youtu.be/BuHAkila_Oo

MySQL System Admin Real Time Task Practical Step by StepYouTube
MySQL System Admin Real Time Task Step by Step

Mysql admin Playlist

In this video , I am going to discuss about basic MySQL commands in dba doctor channel.
In DBA DOCTOR Channel we are covering System Admin task what all he should know to handle MYSQL related incidents/outages.
Like creating database
Checking and verifying the connection and server status.
monitoring server connection,
Monitoring server status,
Creating user assigning roles,
Dropping the user revoking the roles,
Switching the user,
inserting the data,
Selecting the record,
creating table,
dropping table,
dropping database

Welcome to my channel DBA Doctor.

https://www.youtube.com/channel/UCBf4WAQwFr3XxagqXZMcWZA

DATABASE PLAYLISTS :-
https://studio.youtube.com/channel/UCBf4WAQwFr3XxagqXZMcWZA/playlists

Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏

***********************************************************

Mysql Complete Tutorial:-

SQL Server Complete Tutorial:-

SQL Server Complete DBA Interview Questions and Answer:-

Microsoft Azure Complete Tutorial:-

Aws Complete Tutorial:-

Always on Real Time Interview Questions:-

https://youtu.be/W-ZY2rAKuII

AZ-900 microsoft azure fundamentals tutorial:-

https://youtu.be/xH3fYDyc8Ew

MySQL System Admin Real Time Task Practical Step by Step:-
https://youtu.be/BuHAkila_Oo

Microsoft Azure SQL database Interview Questions and Answers:-
https://youtu.be/VAIJyV-H92w

SQL Server DBA interview Questions and Answers Part-1|Microsoft | SQL Server| DBA:-
https://youtu.be/SoPrSOOSkc4

SQL Interview Questions and Answers:-
https://youtu.be/Bw_6X4zNwIg

Learn How to Migrate Database using Amazon :-
https://youtu.be/Gk7L9s4ntWo

#mysqlrealtime
#mysqldba
#mysqlsysadmin
#mysqluser
#mysqldatabase
#mysqlmonitoring
#mysqlcommandline
.

.

Amit Kumar 2022-01-12 19:48:40
Hi all anyone prepared or having MySQL dba interview questions and answers for experience
Amit Kumar 2022-01-12 19:48:56
Kindly share ,thanks in advance
svart 2022-01-12 20:03:15
Amit Kumar 2022-01-12 19:48:40
Hi all anyone prepared or having MySQL dba interview questions and answers for experience

Just ask what will happen when user start a query which would update 1M rows. It is the endless topic to discuss and you will touch almost every piece of mysql internals and you can go as deep as you want based on candidate experience.

M S 2022-01-13 07:53:45
Hi all ,how can we get the user count from processlist with respect to host can anyone share me the solution for this
Vinay Naugain 2022-01-13 08:49:54
Thanks @m_an_kush, it was helpful.
Gaurav Gupta 2022-01-13 09:29:40
We are looking for Core php Developer and Node js Developers on job.
Liran 2022-01-13 12:57:36
I have table A and table B. table A has FK for table B. if I change table B name will it destroy the FKs?
ChildProcessError 2022-01-13 13:02:03
is it possible to select a random item from a json in a row?
ChildProcessError 2022-01-13 13:02:36
or i have to fetch the data first and random it?
MasterZiv 2022-01-13 13:03:36
ChildProcessError 2022-01-13 13:02:03
is it possible to select a random item from a json in a row?

yes it is possible.

MasterZiv 2022-01-13 13:04:13
Liran 2022-01-13 12:57:36
I have table A and table B. table A has FK for table B. if I change table B name will it destroy the FKs?

formally you should re-create the FK constraint after renaming the table.

ChildProcessError 2022-01-13 13:04:24
MasterZiv 2022-01-13 13:03:36
yes it is possible.

how can i do that

MasterZiv 2022-01-13 13:04:45
ChildProcessError 2022-01-13 13:04:24
how can i do that

By using select statement

ChildProcessError 2022-01-13 13:04:48
i mean in a sql query
not in python code
Liran 2022-01-13 13:05:25
MasterZiv 2022-01-13 13:04:13
formally you should re-create the FK constraint after renaming the table.

by doing it I see the foreign key navigates to the new table’s name but does it really work or I need to analyze table / drop FK and recreate?

ChildProcessError 2022-01-13 13:06:09
MasterZiv 2022-01-13 13:04:45
By using select statement

im not sure your got my point
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean

MasterZiv 2022-01-13 13:08:58
Liran 2022-01-13 13:05:25
by doing it I see the foreign key navigates to the new table’s name but does it really work or I need to analyze table / drop FK and recreate?

you can re-check in the docs, but I would always do this in 3 steps
0 drop the constraint
1 rename the table
2 re-create the constraint.

I’m afraid you can only finally prove this or that behavior by analyzing the source code and writing a test case for this (or use existing)

Liran 2022-01-13 13:09:41
MasterZiv 2022-01-13 13:08:58
you can re-check in the docs, but I would always do this in 3 steps
0 drop the constraint
1 rename the table
2 re-create the constraint.

I’m afraid you can only finally prove this or that behavior by analyzing the source code and writing a test case for this (or use existing)

yeah, guess i’ll give it a try on some test server and see. thanks! 🙂

MasterZiv 2022-01-13 13:09:44
ChildProcessError 2022-01-13 13:06:09
im not sure your got my point
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean

this is not a JSON I suppose

MasterZiv 2022-01-13 13:10:24
ChildProcessError 2022-01-13 13:06:09
im not sure your got my point
for example i have row with a json column with this value [1,2,3,4,5,6,7,8]
i need to choose one of the items of that list in json randomly with sql query before fetching the data so keep my code clean

you must have an object or array of objects at the top level

|