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.

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.

Mastering these two commands is paramount if you want to become a competent MySQL admin. Backups. The mysqldump command creates a file of SQL statements that when run, will recreate the same tables ...

Backing up, restoring and copying MySQL databases via command-line is not as simple as it should be. Lots of configuration options and edge-cases make you wast time searching for anwers on Stack ...

While importing databases dump that are of large sizes in gb you may find issues with phpmyadmin and some other clients also. to import the database you can use the command.mysql -uusername -p ...

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 ...