Is it possible to dump only tables without views?

|
Liran 2022-08-07 11:12:13
i don’t know the exact command it’s running. in GCP cloud sql there’s a function to dump the whole instance / single db. all i know it uses single-transaction so it won’t lock db.
Liran 2022-08-07 11:13:19
https://cloud.google.com/sql/docs/mysql/import-export/import-export-sql#:~:text=Cloud%20Storage.-,Export%20from%20Cloud%20SQL%20to%20a%20SQL%20dump%20file,-To%20create%20a

Export and import using SQL dump files  |  Cloud SQL for MySQL  |  Google CloudGoogle Cloud
smlkw 2022-08-07 11:17:08
mysqldump –databases DATABASE_NAME -h INSTANCE_IP -u USERNAME -p
–hex-blob –single-transaction –set-gtid-purged=OFF
–default-character-set=utf8mb4 > SQL_FILE.sql
smlkw 2022-08-07 11:17:21
You can set a username here
Liran 2022-08-07 11:22:04
is it possible to dump only tables without views? or dump views without all the definers?
do you think there’s a workaround from GCP side or my only option is to mysqldump by myself?
Max Weber 2022-08-07 11:28:51
Can anyone tell me, how to import data to MySQL?

importing Excel Data to MySQL

smlkw 2022-08-07 11:45:27
You can convert Excel data into CSV format and then to import it to MySQL
smlkw 2022-08-07 11:47:28
I don’t know, but what I know — you can edit a dump file and fix incorrect usernames there
Max Weber 2022-08-07 11:52:44
I want command to import CSL file to SQL on command line.
Liran 2022-08-07 12:08:34
Yeah I understand you, I just don’t know how easy that would be with 300gb dump file
Mr_Mohan_Cool 2022-08-07 12:21:47
Hi All,
Is their any requirement for mysql developer for
3-5 experience
smlkw 2022-08-07 12:37:35
What?
smlkw 2022-08-07 12:38:10
Vim works well with huge files
smlkw 2022-08-07 12:39:11
I think you need to search information first

I’ve gave you a direction

Max Weber 2022-08-07 13:03:25
Sure. I got it.
Liran 2022-08-07 14:09:01
I heard from many other DBA’s that I worked with that I should never use triggers. what are the reasons to avoid using them?
Swapnil 2022-08-07 15:05:59
Depends on many reason like
how highly transactional table is,
growth of table, DMLs on table.

AFAIK, triggers on postgreSQL are pretty stable to use.
Also we have statement level triggers

Dbpr916 2022-08-07 16:58:41
Hi gud evening can any one share SQL full notes
lonelykingalways 2022-08-07 17:31:59
How the data is Send to Database
Abhishek 2022-08-07 18:38:09
Happy friendship day
Janardhan Jan 2022-08-08 10:48:51
Hi I am trying to delete records by using procedure but it takes more time to delete. Can anyone help me on these.
nitinkunar 2022-08-08 11:43:59
How to delete duplicate collumn in MySQL
A 2022-08-08 14:17:24
I am using min aggregate function along with group by to find the min created date of the grouped data.
Now I am unable to sort by that min created date
A 2022-08-08 14:17:30
Can someone help
A 2022-08-08 14:17:42
Using sequelize orm with nodejs
Swapnil 2022-08-08 15:12:28
Is this a database query ?
A 2022-08-08 15:33:53
Yes. Got it now it’s working
Sai Prasad 2022-08-08 17:15:34
With rank functions and CTE
nitinkunar 2022-08-08 17:19:54
I done
Shadabkhanking 2022-08-09 01:49:58
Walaikum assalam wa Rahmatullahi wa barakatahu wa magfiratahu
DBA 2022-08-09 04:52:17
How to resolve Max prepare statement error
DBA 2022-08-09 04:53:15
How to resolve slave lag issue….no problem found in network and in disk…and all tables are having primary key…
Omkar Bhalerao 2022-08-09 08:00:34
Anyone have working sql
Max Weber 2022-08-09 08:02:31
mysql_en-23688.jpg

Max Weber 2022-08-09 08:02:40
How to solve this error? Can anyone help me?
|