View Full Version : [ubuntu] Mysql backup
vksingh
October 14th, 2009, 03:43 PM
Hi,
Can some body tell how to backup mysql data base?
Thanks,
Vivek
DaithiF
October 14th, 2009, 03:48 PM
use mysqldump
example usage:
mysqldump -h host -u user -ppassword --databases database1 database2 > mysqlbackup.bak
vksingh
October 14th, 2009, 08:23 PM
How to create database files at given location?
Thanks,
Vivek
DaithiF
October 14th, 2009, 09:18 PM
what do you mean -- create a backup of a single database at a certain location?
mysqldump -h host -u user -ppassword --databases databasename > /path/to/yourbackup.bak
or just:
mysqldump -h host -u user -ppassword databasename > /path/to/yourbackup.bak
Powered by vBulletin® Version 4.2.2 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.