Showing 1-6 of 6 items.

MySQL Export Database to File in Linux

Last updated on Dec 30, 2019 in MySQL, Linux

It is very useful to know how to export MySQL database from Linux command line by using `mysqldump`. You just need to know MySQL user's username and password, and the database name that you want to export.

MySQL Export Database to GZIP File in Linux

Last updated on Dec 30, 2019 in MySQL, Linux

You can export MySQL database from command line of Linux by using `mysqldump`. By default, the output is in SQL format, so it is good idea to compress it on-the-fly.

MySQL Import Database from SQL File in Linux

Last updated on Dec 30, 2019 in MySQL, Linux

During development environment setup we often have a database dump created with **mysqldump** and we need to import it from the command line.

MySQL Import Database from .GZ File in Linux

Last updated on Dec 30, 2019 in MySQL, Linux

During development environment setup we quite often have a database dump created with mysqldump and in gzip format, and we need to import it from the Linux command line.

Reset MySQL Root Password in Centos 6

Last updated on Dec 28, 2019 in MySQL, Linux

Reset the MySQL root password in CentOS 6 by using MySQL server Safe Mode.

Reset MySQL Root Password in Centos 7

Last updated on Dec 27, 2019 in MySQL, Linux

Reset the MySQL root password in CentOS 7 by using MySQL server Safe Mode.