UKoom

how to correctly import a MySQL dumpfile through a command line. mysql -p -h DBSERVER dbname < dbname.sql

I have not yet seen enough of 5.1 in real-world production environments. MySQL 5.1 rease as “GA” seems to be the most controversial to date. It ...

This is my study note about mysql :) MySQL ============================================== http://www.mysql.com Usages --------------------- System parameters *select version(),user(),current_date,now(); Install/Remove MySQL service *mysql -install|remove *net start|stop mysql (this command will not work if use mysqld --standalone) *mysqladmin -u root -p shutdown(it works in all status) Commands *Cancel the command \c Backup the data *mysqldump -u root -ppasswd user|othertable|--all-database>backup.sql Load the data from text file *load data local infile 'data.txt' ...