Ubuntu/mysql
From r00tedvw.com wiki
(Difference between revisions)
(Created page with ";mysql is one of the most popular database applications on the market today <br\> mysql login mysql -u <user> -p will then prompt you for a password <br\> mysqladmin login m...") |
|||
| Line 14: | Line 14: | ||
verify MySQL is running | verify MySQL is running | ||
sudo netstat -tap | grep mysql | sudo netstat -tap | grep mysql | ||
| + | backup wiki mysql database | ||
| + | sudo -s | ||
| + | mysqldump -u user -p db.name > wikidatabasebackup.sql | ||
| + | i.e. mysql -u wikiuser -p wikidb > /var/www/mediawiki/backup/wikidatabasebackup10_4_12.sql | ||
Revision as of 14:21, 22 November 2012
- mysql is one of the most popular database applications on the market today
mysql login
mysql -u <user> -p
will then prompt you for a password
mysqladmin login
mysqladmin -u <user> -p
you can also run other commands after -p, such as:
see if the database is running
status
change MySQL root pass
sudo dpkg-reconfigure mysql-server-5.1
verify MySQL is running
sudo netstat -tap | grep mysql
backup wiki mysql database
sudo -s mysqldump -u user -p db.name > wikidatabasebackup.sql i.e. mysql -u wikiuser -p wikidb > /var/www/mediawiki/backup/wikidatabasebackup10_4_12.sql
