Differences

This shows you the differences between two versions of the page.

--- mysql_mysqldump_intro [2015/12/14 12:17] – luke7858
+++ mysql_mysqldump_intro [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 === Dumping and Importing database ===
-To take a mysql dump you should not be logged into mysql, you will just need to be in the terminal. Use the following command to export the db to the directory you are currently in.
-\\
 Best practice states that the /home/user/.my.cnf or /root/.my.cnf file should be created (depending on what user you are taking the dump with) with the appropriate credentials before taking a mysql dump. This is not mandatory but certainly makes life easier when working with mysql
 \\
+Creating the file is as easy as:
+<sxh bash>
+vim /root/.my.cnf
+</sxh>
+<sxh bash>
+[client]
+user: root
+password: mypassword
+</sxh>
 === Viewing databases outside of mysql ===
 You can view your mysql databases without logging into mysql with the following command: