|
|
Joined: Jun 2002
Posts: 61
Power User
|
Power User
Joined: Jun 2002
Posts: 61 |
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)
|
|
|
Entire Thread
|
MYSQL Commands (Most used)
|
armyocs
|
01/16/2003 1:49 AM
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 87
Joined: December 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|