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