Mysql
important mysql command, backup, dump restore
Connest to mysql server
mysql -u USERNAME -h ‘HOST_IP’ -p
enter password – here
mysql> show databases;
mysql> use DATABASE_NAME;
mysql> your query here.
Dumping a mySQL to a sql file
mysqldump -l –opt databasename > /root/file/location/filename.sql -u user –password=whateverthepass
Importing mySQL dump file
mysql databasename < /root/file/location/filename.sql -u user –password=whateverthepass
Copying Entire Folder of Files
cp – Ru /root/file/location/* /where/it/should/go –reply=yes
Making a [...]
Mysql master slave server database load balancing
Mysql database Master slave serve setup