grace ho » hi i have 1 month old who have
admin » Hi Wantie, how to check the n
Wantie » Hi Dan, pls help me to check t
Jordi » Hi Dan,
Thanks for this fun
Charlie » the CRTL ALT Enter works great
Mark » Sounds like a blast, and thank
Lim Kimlang » Note :
Yes madam this is a
Thomas » Hi Dan,
I would like to dri
Baggio » Tnks
Home
HYGEN Web Design
323 commentsmysqldump: command to backup a database on another remote server
August 12th, 2010 | by admin |
MySQL: mysqldump command tip!
The mysqldump program is often used to getting a data dump of a local database for backup reasons or just for moving a database from one server to another. To make this even easier, mysqldump can accept a remote host as an arguement. This means that if you are logged into server A you can get a backup of server B immediatly without having to login to server B and then transfer the file manually vis FTP or SCP etc. Just use this command:
mysqldump -h000.00.000.000 -uYOURUSERNAME -pYOURPASSWORD DATABASE_NAME > backup.12.08.10.sql
- -h parameter is where you put the host, for example the IP address of the server that has the MySQL database living on it.
- -u parameter preceeds your MySQL username
- -p parameter preceeds your MySQL password
- > directs the output of the command to a specified file which will be created if it doesn’t exist
