hostname is the name of the server you wish to backup, for transferring databases within Pipe Ten this would be either .uk (Sheffield) or .uk (Derby). Mysqldump -h hostname -u username -p password dbname localfile.sql Replace the following text where applicable. Ubuntu, run ‘sudo apt-get install mysql-client’ which will provide mysql, mysqldump, mysqladmin, mysqlcheck and other tools.īackup an existing database using the mysqldump executable. Macintosh, download and install the relevant. Download and install mysql/mysqldump to get started: Windows, install to your local computer which also provides mysql.exe, mysqldump.exe and related. One of our favourites is the classic and due to their simplicity, portability and originality and we’ll need this for the purposes of this tutorial. When transferring MySQL databases between hosts or servers there are various methods available from the web based to remote GUI clients such as.
