Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

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.

37
votes
5answers
6k views

When is the right time to use MariaDB instead of MySQL, and Why?

What we earn and what we lost with this migration? What should I expect as drawbacks after the migration? Is it really unnecessary to change the applications in any situation?
67
votes
5answers
10k views

How can a group track database schema changes?

What version control methodologies help teams of people track database schema changes?
226
votes
10answers
220k views

What are the main differences between InnoDB and MyISAM?

What are the main differences between InnoDB and MyISAM?
5
votes
3answers
2k views

With MySQL Replication, what level of resilience is possible?

I've found lots of good material on setting up MySQL replication, but not much on what to do in the event of failures. Understanding the degree of resilience I can achieve is fundamental to designing ...
3
votes
4answers
10k views

How to do a mysqldump with a use database in the dump

So the command I normally use to get a database sent to another server is: mysqldump -u user -p --add-drop-tables database *file* But I always have to go into the file and add a line at the top: use ...
3
votes
3answers
13k views

In MySQL Workbench, insert a new column at the “top” of a table?

I must keep a table's columns as specified in a specification that changes quite often. In MySQL Workbench, adding a new columns after all the others is easy, but I can't find a way to insert a new ...
2
votes
1answer
2k views

MySQL : “FLUSH TABLES WITH READ LOCK” started automatically

I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
37
votes
8answers
181k views

MySQL DB import/export command line in Windows

How to export / import a database in MySQL through the command line? MySQL system configuration, WampServer server installed. OS: Windows The advice for my local host, not an live hosting...
10
votes
9answers
11k views

Load-balanced MySQL cluster without load balancer

I'm looking to create a load-balanced MySQL cluster, but without the actual load-balancer, in order not to add another point of failure or complexity. What I was thinking was to have the following: ...
43
votes
9answers
24k views

Is there a tool like Microsoft's “SQL Server Profiler” for MySQL? [closed]

While developing on MySQL I really miss being able to fire up a profiler. I find SQLyog is a good enough replacement for Query Analyzer but have not found a tool that works like SQL profiler. For ...
60
votes
7answers
114k views

How do I completely disable MySQL replication

I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?