This and that around Mysql in Apache environment (Note)

Log in to Mysql

Command


> mysql -u username(For example root) -p

Go to Mysql and see the list of databases

Command


mysql> Show databases;   #Check the database with this command

Extract data from a specific database in Mysql and move it locally

1. Create a MySQL data file (Dump file)

command


$ mysqldump -u root -p database name>File name that reflects the extraction (optional)

Recommended Posts

This and that around Mysql in Apache environment (Note)
Commands that were important when building the Laravel environment in the Apache environment (Note)
matplotlib this and that
Note: CGI (during trial and error) in Vagrant environment
This and that about pd.DataFrame
This and that using reflect
(Note) Django in Vagrant environment
Zabbix API this and that
This and that learned from boost.python
This and that of python properties
This and that using NLTK (memo)
This and that of the inclusion notation.
Building an environment that uses Python in Eclipse
Install gensim in conda environment (and also install mecab)
Try installing GeoSpark (Apache Sedona) in Python environment
Note that I was addicted to npm script not passing in the verification environment
A note that runs an external program in Python and parses the resulting line