Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.

The MySQL command line can be a bit daunting at first, but once you get the hang of it, it’ll become second nature. SEE: Server deployment/migration checklist (Tech Pro Research) I want to walk ...

If you are used to the command line client of mySQL, and you prefer it over phpmyadmin, then this is a solution to connect to the servers opened only for localhost. Requirements: ... you can set up ...

These are some simple bash scripts to make working with multiple MySQL databases much easier. There are only to be used in development environments as they require privileged access to your databases.

innodb-java-reader is a java implementation to access MySQL InnoDB storage engine file directly. With the library or command-line tool, it provides read-only features like examining pages, looking up ...

This is likely because when I first learned it was with command-line tools, but even so, I think command-line database tools often are the best way to interact with a database manually. Two of the ...

I tried using the following commands to shutdown and startup MySQL and although it did, it also changed the permissions on the databases and I could no longer work with them in phpmyadmin until i ...

The mysql command-line interactive program is a very powerful way to access, display and even manipulate data without the need for any GUI at all. The basic commands are well worth learning, so if you ...