Tag: database
-
MySQL: How to create a database
To create a simple database (e.g. if you need to create one for a WordPress or Wiki install) use the following after logging in to MySQL as the root user: create database [nameOfDatabase]; Don’t forget the ; at the end, or you’ll end up on a new line consisting of a >…
-
How To: Export all mysql databases for backup
This is a handy command for anyone using multiple mysql databases – it produces a single file which you can easily back up to elsewhere. mysqldump -u root -p –all-databases > databasesBackup.sql Note the two hyphens before “all”. This command creates the file databasesBackup.sql which contains the contents of all of your databases.…