Do you have the sql-dump file on the server?

|
MasterZiv 2022-01-10 14:17:37
M S 2022-01-10 14:16:08
Where NOT IN clause uses composite Index??

it depends on the query and the index.

M S 2022-01-10 14:24:04
U mean that it will use
Mangesh Panchal 2022-01-10 14:24:38
How to find difference by time from timestamp date from 2 rows / lineitem
MasterZiv 2022-01-10 14:24:40
M S 2022-01-10 14:24:04
U mean that it will use

It can use. Not that it will be used.

Parker_600 2022-01-10 15:11:23
mysql_en-15696.jpg

Parker_600 2022-01-10 15:11:36
Please help to this question
Parker_600 2022-01-10 15:11:43
Please
Fenibo Fubara 2022-01-10 18:56:06
Please guys, what’s the directory to find MySQL file (.sql)in digital ocean Ubuntu server
svart 2022-01-10 18:57:25
Fenibo Fubara 2022-01-10 18:56:06
Please guys, what’s the directory to find MySQL file (.sql)in digital ocean Ubuntu server

find / -name ‘*.sql’

Fenibo Fubara 2022-01-10 18:58:24
svart 2022-01-10 18:57:25
find / -name ‘*.sql’

Can you through more light pls

svart 2022-01-10 19:00:26
Fenibo Fubara 2022-01-10 18:58:24
Can you through more light pls

sure.
– copy this command
– connect to your digital ocean instance
– paste the command
– press “enter”
– wait for results

Fenibo Fubara 2022-01-10 19:04:52
svart 2022-01-10 19:00:26
sure.
– copy this command
– connect to your digital ocean instance
– paste the command
– press “enter”
– wait for results

Done, it gave a result but not what I needed

svart 2022-01-10 19:05:32
Fenibo Fubara 2022-01-10 19:04:52
Done, it gave a result but not what I needed

you got what you asked for

Fenibo Fubara 2022-01-10 19:26:23
https://docs.digitalocean.com/products/databases/mysql/how-to/import-databases/

How to Import MySQL Databases into DigitalOcean Managed Databases | DigitalOcean DocumentationDigitalOcean
Import an existing MySQL database into DigitalOcean Managed Databases.
Fenibo Fubara 2022-01-10 19:26:24
mysql_en-15721.jpg

Fenibo Fubara 2022-01-10 19:26:24
mysql_en-15720.jpg

Fenibo Fubara 2022-01-10 19:26:25
So I am trying to get the database file path so I can do a command like

sftp> get the-path-to- database-file.sql

Fenibo Fubara 2022-01-10 21:24:38
Hellloooo..
Any help pls
piterden 2022-01-10 22:07:47
Fenibo Fubara 2022-01-10 21:24:38
Hellloooo..
Any help pls

Do you have the sql-dump file on the server?

piterden 2022-01-10 22:10:35
Fenibo Fubara 2022-01-10 19:26:25
So I am trying to get the database file path so I can do a command like

sftp> get the-path-to- database-file.sql

Yes you can. It is written on your screenshot. Why do you ask again?

Fenibo Fubara 2022-01-10 23:31:15
mysql_en-15730.jpg
Photo from Supermanic
Fenibo Fubara 2022-01-10 23:33:19
svart it doesn’t seem to find the database .SQL file
Fenibo Fubara 2022-01-10 23:34:51
piterden 2022-01-10 22:07:47
Do you have the sql-dump file on the server?

Not sure sir, pls guide me

piterden 2022-01-10 23:57:15
Fenibo Fubara 2022-01-10 23:34:51
Not sure sir, pls guide me

Guide where?

SMTABL 2022-01-11 09:20:55
Hi folks,
SMTABL 2022-01-11 09:21:23
Can anyone suggest me a good SQL video tutorials for beginners with projects
kavrajguddu 2022-01-11 09:37:14
SMTABL 2022-01-11 09:21:23
Can anyone suggest me a good SQL video tutorials for beginners with projects

Yes same

Liran 2022-01-11 10:07:56
hi i have a column name as follow, as you can see there’s an invalid invisible character between the d & ; . how can I resolve this?
old_system_user_id‏;
MasterZiv 2022-01-11 10:18:18
SMTABL 2022-01-11 09:21:23
Can anyone suggest me a good SQL video tutorials for beginners with projects

There is no good video tutorials.
Read books, go to university and study science. All video tutorials is bullshit.

MasterZiv 2022-01-11 10:19:25
Liran 2022-01-11 10:07:56
hi i have a column name as follow, as you can see there’s an invalid invisible character between the d & ; . how can I resolve this?
old_system_user_id‏;

Details needed..

MasterZiv 2022-01-11 10:20:53
Liran 2022-01-11 10:07:56
hi i have a column name as follow, as you can see there’s an invalid invisible character between the d & ; . how can I resolve this?
old_system_user_id‏;

I suspect this is your fantasy, tell us what is you real problem

MasterZiv 2022-01-11 10:21:33
Liran 2022-01-11 10:07:56
hi i have a column name as follow, as you can see there’s an invalid invisible character between the d & ; . how can I resolve this?
old_system_user_id‏;

Like “I do…, and I get… ”

Liran 2022-01-11 10:21:41
MasterZiv 2022-01-11 10:20:53
I suspect this is your fantasy, tell us what is you real problem

i want to get rid of this invalid char between the “d” and “;”.

MasterZiv 2022-01-11 10:24:33
Liran 2022-01-11 10:21:41
i want to get rid of this invalid char between the “d” and “;”.

This way noone will be able to help you

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 ?
|