Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 120894

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

0
votes
1) 'my public ip' is this ip allowed to connect your mysql server? note : i know you have allowed from everywhere '%' but better to check again, whether your server ('my public ip') is allowed to … connect to mysql server 2) If 1st is ok then please check your password. Looks like something wrong with the password (typo, or copy issue etc). Hope this helps. …
answered Apr 9 '17 by Vaibhav
0
votes
Above answers are the solutions however you can also explore below options with caution. Check if you have any unnecessary files. if you have delete and create some free space. Also you can check fo …
answered Mar 31 '17 by Vaibhav
2
votes
MySQL replication can be helpful. Your remote DB (lets call it A) and Future DB on local site (lets call it B) can be configured with Master-Slave replication. "A" will be master and "B" will be …
answered Apr 6 '17 by Vaibhav
0
votes
Are you facing any issues with current state of configuration? Some generic recommendations :- 1) enable log_bin , if you need reduce your dataloss in case of crash 2) Set Server_id, in future you mi …
answered Apr 7 '17 by Vaibhav
0
votes
it will hung and will not complete the execution you might no be able to stop the mysql gracefully or properly using stop command I suspect this is related to untuned query which is killing your …
answered Mar 31 '17 by Vaibhav
1
vote
Random insert into or delete from a secondary index can cause the index fragmentation. Basically it will use extra space than required. There are several ways to reclaim this space. One of the way to …
answered Mar 31 '17 by Vaibhav
0
votes
What command are you using to load mysqldump? Is this a production server? Size of the dump? Format of the dump (.gz or .sql)? Check if the error caused due to restart,if yes 1) check mysql memory …
answered Apr 11 '17 by Vaibhav