UBB.Dev
Posted By: armyocs MYSQL Commands (Most used) - 01/16/2003 1:49 AM
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)



© UBB.Developers