tags: apache archive business charity climbing cluster comic database email exchange family fm2008 hack humour linux liverpool microsoft money mysql network oes opensource outlook php pictures poem process project real_life review rss science security software sql thought tsm updates webdev website windows
If you want to take a backup of your MySQL database or move it to another server, here's the easiest way. Run the following from a cmd, terminal or bash session, do not use the mysql command line tool.
DUMP
mysqldump -h hostname -u user --password=password databasename > filename
LOAD
mysql -h hostname -u user --password=password databasename < filename
Cheers
Ryan Partington
Yesterday I was working on an SQL cluster and part of the job was to change the IP address. Doing so caused the application dependent on the cluster to fail. I was required to make a registry changes so the SQL server would listen on the new IP address. What helped me determine the issues and resolve it quickly was running 'netstat -a -n' from the command prompt and looking at what IP address the SQL server was listening on. 'netstat -a -n' is a handy command worth running on secure servers as part of a schedule so you can view what ports/services your server is open to.
Cheers
Ryan Partington
