User Tools

Site Tools


mbstring extension must be loaded in order to run mPDF
mysql

MySQL

CLI usage

Command Description
mysql -u root -pAuthenticate and connect (interactive mode)
mysqldump –databases {DATABASE} > output.sql
mysqldump -u root –password={PASSWORD} {DATABASE} -c > output.sql
Dump DATABASE

SQL expressions

Command Description
SHOW DATABASES;Show all databases
SHOW TABLES in {DATABASE};Show all tables in DATABASE
DROP DATABASE {DATABASE};Delete DATABASE
mysql.txt · Last modified: by wolfo

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki