User Tools

Site Tools


tech:rdbms:mysql_hints

Quick mysql primer

mysql connection test

os> mysql -u root -p
Password: <PASSWORD>
mysql>use mysql
mysql>show tables;
mysql>select * from user
mysql>exit

Backup a database

mysqldump --user=root --password=<PASSWORD> --database <DBNAME> > /backup/path/<DBNAME>.bkp

Restore a database

os> mysql -u root -p < /backup/path/<DBNAME>.bkp
Password: <PASSWORD>
tech/rdbms/mysql_hints.txt · Last modified: 2024/02/21 19:09 by 127.0.0.1

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