chandu_babu Posted January 2, 2015 Report Posted January 2, 2015 1.How to take backup of production databases ? (To a remote server ) 2.Do you use any tools ? Any suggestions will be appreciated.
DaleSteyn1 Posted January 2, 2015 Report Posted January 2, 2015 intha clear ga undhi kadha uncle http://webcheatsheet.com/sql/mysql_backup_restore.php e link lo unnadhi chaduvu..ayna dev aithe endi prod aithe endi e database kaina okelaga backup cheyadame
chandu_babu Posted January 2, 2015 Author Report Posted January 2, 2015 intha clear ga undhi kadha uncle http://webcheatsheet.com/sql/mysql_backup_restore.php e link lo unnadhi chaduvu..ayna dev aithe endi prod aithe endi e database kaina okelaga backup cheyadame 1.All the above steps are for storing into a local server.. i am looking if we can do it to a remote server. 2. While using mysqldump database gets locked, so how to do a hot backup 3. Most of the tools (like php admin) are for windows. I need for Linux based.
Hyderabad_Nawab Posted January 2, 2015 Report Posted January 2, 2015 Calling loveindia... CITI#H@ CITI#H@
ZuniorVentiyar Posted January 2, 2015 Report Posted January 2, 2015 either use mysql workbench which has options to mention remote server details or use -h option with mysqldump command 1.All the above steps are for storing into a local server.. i am looking if we can do it to a remote server. 2. While using mysqldump database gets locked, so how to do a hot backup 3. Most of the tools (like php admin) are for windows. I need for Linux based.
vaade_veedu Posted January 2, 2015 Report Posted January 2, 2015 ssh, dump, copy else connect using workbench, take dump
MeetFriendz Posted January 2, 2015 Report Posted January 2, 2015 ssh, dump, copy else connect using workbench, take dump +1 mostly backups sits on servers which might be in propriatery format... so unix server connection tools tho files storage location remote server pettu
chandu_babu Posted January 2, 2015 Author Report Posted January 2, 2015 ssh, dump, copy else connect using workbench, take dump Do u have any idea of installing workbench on Linux ?
ZuniorVentiyar Posted January 2, 2015 Report Posted January 2, 2015 which linux version u r using .... workbench only support Ubuntu and debian falvors download from mysql site and use sudo dpkg -i mysqlworkbench.deb Do u have any idea of installing workbench on Linux ?
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts