(Sirgey) When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we’ll share with you a better option after the break), e.g.: mysql –password=secret –user=username database_name < query.sql [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://www.linuxjournal.com/node/1001956" opennewwindow=true]Read More[/standout-css3-button] (Community content) [/membership]

(Erik Wetterberg) Recently we have been doing some work with export and import of data from and to MySql databases. Our customer wants to be able to export configuration data from one MySql instance and import it into another.

In preparation for rolling out a production cluster I had to set up a development cluster. I set things up on two servers so that a SQL node and a ndb node ran on each server. What fun. Right.

(Mark Callaghan) How do you tune load problems on MySQL? You might get lucky and see that there are a few long running statements when running SHOW PROCESSLIST. You might be working on a small system where you know all of the people and/or SQL statements. Unfortunately, these approaches don’t work f

(Ernest Bonat) MySQL data load and search are very important business requirements in any Windows or Internet web application development. In general, any application needs to show a result set of data and/or a single record to the end-users. In Windows applications it is very popular to show a resu

(Peter Zaitsev) One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column even if functio

(Habiburahman Khaled) Many people have been asking how to insert one parent and multiple child records into MySQL database using ASP.NET from one form at once. This article will show you exactly that.

(Mark Robson) I’ve been doing a few experiments with ENUMs and SQL_MODE.

(Peter Zaitsev) The question I often get is how far MySQL may fall behind and how to keep replication from lagging.

(Jay Janssen) So you want to build a system that does jobs. You want the jobs to be able to be run in parallel for speed, but also for redundancy. This system needs to be coordinated so, for example, the same jobs aren’t being done twice, the status of every job is easy to see, and multiple servers