User Tools

Site Tools

Trace:
mysql_mysqldump_intro

Differences

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

Link to this comparison view

Next revision		Previous revision
mysql_mysqldump_intro [2015/12/14 12:14] – created luke7858mysql_mysqldump_intro [2024/05/23 07:26] (current) – external edit 127.0.0.1
Line 1: Line 1:
 === Dumping and Importing database === === 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 === === Viewing databases outside of mysql ===
 You can view your mysql databases without logging into mysql with the following command: You can view your mysql databases without logging into mysql with the following command:
mysql_mysqldump_intro.1450095270.txt.gz · Last modified: 2024/05/23 07:26 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki