UBB.Developers Forums Community Development Programming MySQL and Server Configuration MYSQL Commands (Most used)

These are the ones I use the most, hope it can help.

Backup a Database
<-----------------------<<

Backup Database from the prompt-

mysqldump -u(databaseusername) -p(databasepassword) (databasename)>backupfile.sql

Example-

mysqldump -uocsfoundation -ppassword forums>forumsbackup.sql


Import a Database
<-----------------------<<
Mysql Input
mysql -u(user) -p(password) (databasename)<(backupfile.sql)

mysql -uocsfoundation -ppassword forums<forumsbackup.sql

(Note: your database should be empty first)