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 50418

InnoDB : MySQL's ACID-compliant Storage Engine

0
votes
It comes out that Oracle does not support remote backup from MySQL enterprise backup 4.0 (mysqlbackup) for MySQL 5.7 as of now and Oracle is already working on adding this feature to MEB. Thanks all …
answered Jul 19 '17 by Nawaz Sohail
1
vote
tagName column in table cardTags is not defined as primary key and you are declaring foreign key FOREIGN KEY (tagName) REFERENCES cardTags(tagName).
answered Oct 17 '14 by Nawaz Sohail
4
votes
Data is present in data folder of MySQL which is usually in ProgramData for windows installations. look into "C:\ProgramData\MySQL\MySQL Server 5.6"..as programdata usually have the files on by defaul …
answered Jun 15 '15 by Nawaz Sohail
0
votes
0answers
I have a view which have following definition Create view view1 as select * from information_schema.events where event_schema="database1" I have granted select permissions on the view1 to …
asked Jun 11 by Nawaz Sohail
2
votes
After much of thinking and researching found one answer which really helped in achieving what was required. It is a perl script and reference link is http://dev.mysql.com/doc/refman/5.6/en/storage- …
answered Sep 12 '15 by Nawaz Sohail
1
vote
2answers
We are facing the issue in replication that we are not getting any error in Show slave status\G output rather facing the following issue in Error Log File [ERROR] Error reading packet from server: Lo …
asked Sep 22 '15 by Nawaz Sohail
-1
votes
2answers
-19_backup_apply_log.log 170717 09:30:19 MAIN ERROR: innodb_page_size obtained from innodb file header 0 is not matching with innodb_page_size 16384 which is read from backup configurations. 170717 09:30:19 MAIN …
asked Jul 17 '17 by Nawaz Sohail
0
votes
1answer
We need to get Master server information such as server IP and Port, we know this information is dumped into master.info file by default but what if it required within MySQL prompt as we are using win …
asked Oct 20 '15 by Nawaz Sohail
2
votes
The actual thing is the variable "innodb_autoinc_lock_mode" which control the behavior for auto_inc lock during generation of auto generated numbers. It can be set to three values which are 0 ,1 or 2. …
answered Oct 29 '15 by Nawaz Sohail
10
votes
5answers
enough. What actually required is the number of bytes according to the definition of the table for innodb only and collation could also be considered as utf-8-general-ci For example a …
asked Sep 8 '15 by Nawaz Sohail
0
votes
1answer
I am facing a very strange issue as i have implemented a trigger on tableA which does encrypt data and insert data to another tableB and update column to 4 digit. The issue is First insert is somehow …
asked Dec 17 '15 by Nawaz Sohail
0
votes
1answer
We are currently using MySQL 5.7.20 on CentOS and are using zip installation. Since it is a zip installation we do not have service created in /etc/init.d/. Is there any other method for auto-star …
asked Feb 5 '18 by Nawaz Sohail