How do I allow remote access to mysql using xampp?

|
Dev_ag 2022-06-21 08:08:05
Swapnil 2022-06-21 08:07:14
Creat temp table like below
create temp table (json_column json);
Then do insert into temp table values (paste your json file here)

Once insert is done, then you can process the json and insert values in any of your table

Thank you, Let me try

Acas76 2022-06-21 08:56:30
General how much time it will take a backup for 250GB database
smlkw 2022-06-21 09:23:05
Acas76 2022-06-21 08:56:30
General how much time it will take a backup for 250GB database

It depends on what is your type of storage

Hussain 2022-06-21 09:28:54
Log shipping real time issue resolve and real time interview questions and answers.

Log Shipping Real Time issue | log Shipping trouble shooting issue | log shipping interview questionYouTube
SQL Server Log Shipping Tutorial Live

In This Session We are Going to Live Demonstrate Log shipping

log shipping is automatically taking log backup and moving log in to secondary server and copy into secondary server log backup
restore log backup into secondary server.

automatic sync primary log with secondary log.
we can monitor log between primary and secondary.
the use of log Shipping is
we can failover and fail back database from primary to secondary and secondary to primary.
secondary server we can use for reporting base.

Explain More about Log Shipping Benefit and loss
In Detail Log Shipping Configuration
SQL Server Replication.
SQL Server Always on
SQLServerrealtime https://youtube.com/playlist?list=PLHJ4Qpy10lBCTaoIN7xBzS1AGl0QVF6JJ
#logshipping
#sql
#highavailability
#replication
#database
#sqlserver

Acas76 2022-06-21 09:43:21
smlkw 2022-06-21 09:23:05
It depends on what is your type of storage

.sql

Acas76 2022-06-21 09:44:53
I want to take backup a database that is 250GB and restore in another server
Acas76 2022-06-21 09:46:45
Can some one tell me ways to backup and restore a my sql database (250GB)
Acas76 2022-06-21 09:47:31
Both soure & destination servers running on windows
chaituyadav 2022-06-21 10:12:12
Hi sir
svart 2022-06-21 12:36:36
Acas76 2022-06-21 09:47:31
Both soure & destination servers running on windows

you can use whatever produced logical backup. mysqldump or mydumper (but you will have to run it from a linux box) or mysqlpump if you have 8.0

Pd 2022-06-21 13:56:40
mysql_en-21960.jpg
Can anyone help to rectify this error
Paul G. 2022-06-21 15:07:01
Pd 2022-06-21 13:56:40
Can anyone help to rectify this error

Hi, it’s a good idea to setup Telegram on your win-pc to send text versions of the problem directly to the chat.

Kha_L3d 2022-06-22 01:17:00
mysql_en-21971.jpg
Hey guys
How to fix this issue
svart 2022-06-22 08:41:46
never worked with “bitnami” but you can check if mysql port is opened, socket exists and error logs
Lee Hovey 2022-06-22 09:04:16
mysql_en-21977.jpg

Lee Hovey 2022-06-22 09:04:54
Has the brothers encountered this error?
Lee Hovey 2022-06-22 09:05:31
When I use navicat backup
MIRADO 2022-06-22 10:50:28
hello friends, there are coordinates that I saved in the text field and these coordinates are in it. i want to find the closest coordinate i sent. my fields are text but the values ​​are double
MasterZiv 2022-06-22 11:07:38
MIRADO 2022-06-22 10:50:28
hello friends, there are coordinates that I saved in the text field and these coordinates are in it. i want to find the closest coordinate i sent. my fields are text but the values ​​are double

You need to do 2 things
1) Read something about 1st normal form of a table
2) re-design your DB

MIRADO 2022-06-22 11:10:49
MasterZiv 2022-06-22 11:07:38
You need to do 2 things
1) Read something about 1st normal form of a table
2) re-design your DB

I do not have a chance to make changes in the table. I can read from the table from mobile and web, but I can solve it in a long way. I’m looking for an easy way with query

MasterZiv 2022-06-22 11:11:13
MIRADO 2022-06-22 11:10:49
I do not have a chance to make changes in the table. I can read from the table from mobile and web, but I can solve it in a long way. I’m looking for an easy way with query

then the task cannot be done

Liran 2022-06-22 12:04:09
how can i select all rows that has a string which contains only white space and no letter/symbol/number? im looking for strings like “ “ / “ “
Swapnil 2022-06-22 14:25:58
Liran 2022-06-22 12:04:09
how can i select all rows that has a string which contains only white space and no letter/symbol/number? im looking for strings like “ “ / “ “

any sample data ?

Makgato 2022-06-22 17:58:21
https://serverfault.com/questions/52794/how-do-i-allow-remote-access-to-mysql-using-xampp

How do I allow remote access to mysql using xampp?Server Fault
I’m using xampp and navicat to manage mysql on two dev machines (laptop & desktop). The laptop is my main machine, while the desktop acts as a local dev server for the group.

Connecting to my…

smlkw 2022-06-22 19:28:07
People here solve don’t such questions
Hari Haran 2022-06-22 19:40:39
Ok
Acas76 2022-06-22 20:42:23
svart 2022-06-21 12:36:36
you can use whatever produced logical backup. mysqldump or mydumper (but you will have to run it from a linux box) or mysqlpump if you have 8.0

Thankyou

Pavankalyan 2022-06-23 13:16:07
Upgarded Cent os 6 to cent os 7 : • After updating the Centos 6.9 to 7.7 reports are not working and MySQL queries are taking a long time to execute.
Pavankalyan 2022-06-23 13:16:26
Pavankalyan 2022-06-23 13:16:07
Upgarded Cent os 6 to cent os 7 : • After updating the Centos 6.9 to 7.7 reports are not working and MySQL queries are taking a long time to execute.

Using php

Pavankalyan 2022-06-23 13:16:33
What is the solution
Pavankalyan 2022-06-23 13:16:57
Is it developer or support department issue?
PriyaJeevan18 2022-06-23 13:18:09
Pavankalyan 2022-06-23 13:16:07
Upgarded Cent os 6 to cent os 7 : • After updating the Centos 6.9 to 7.7 reports are not working and MySQL queries are taking a long time to execute.

Check read write on the db disk …try to fine tune the db

Pavankalyan 2022-06-23 13:30:14
To create a view in mysql we use select query
Pavankalyan 2022-06-23 13:30:48
Pavankalyan 2022-06-23 13:30:14
To create a view in mysql we use select query

Now fetching data from select query is fast or from view

Pavankalyan 2022-06-23 13:31:20
Does view play any role in query speed
|