Command line cheat sheet

From TempusServa wiki
Revision as of 00:27, 22 February 2013 by old>Admin (→‎MySQL commands)
Jump to navigation Jump to search

MySQL commands

Import data from a SQL dump file to a specific database:

mysql -uroot -pPW1234 tslive < dumpLive.sql

Export data from a SQL dump file to a specific database:

mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql