Please support our MySQL advertiser: Programming Forums
Views: 12155 | Replies: 3
 |
•
•
Join Date: Jun 2005
Posts: 85
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
I would like to know how I can backup Mysql tables from hosting server to my local pc? I don't want to use phpMyAdmin, is there some simple commands to do that(I use PHP)? and how to restore it back to hosting server?
I assume it will use csv file.
Any help will be appreciated.
I assume it will use csv file.
Any help will be appreciated.
•
•
Join Date: Jul 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi
I use mysqlhotcopy; it runs from the command line. I don't remember if it comes default with MySql, it may not. But if not, It's easy to find on the web and install.
After you run it, you can tar up the directory it creates and ftp over to your local machine.
Putting it back on your server is a little more tricky. You'd have to stop the DB. Send the file over to the server. Decompress/untar it. Make sure the permissions are correct on all files (they should be). And then start up the DB again.
By the way, My server is a linux box. I'm not sure if mysqlhotcopy is available for Windows/Mac servers.
Mike
I use mysqlhotcopy; it runs from the command line. I don't remember if it comes default with MySql, it may not. But if not, It's easy to find on the web and install.
After you run it, you can tar up the directory it creates and ftp over to your local machine.
Putting it back on your server is a little more tricky. You'd have to stop the DB. Send the file over to the server. Decompress/untar it. Make sure the permissions are correct on all files (they should be). And then start up the DB again.
By the way, My server is a linux box. I'm not sure if mysqlhotcopy is available for Windows/Mac servers.
Mike
•
•
Join Date: Sep 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: how to backup mysql DB to local machine? and restore? •
•
•
•
Originally Posted by michael123
I would like to know how I can backup Mysql tables from hosting server to my local pc? I don't want to use phpMyAdmin, is there some simple commands to do that(I use PHP)? and how to restore it back to hosting server?
I assume it will use csv file.
Any help will be appreciated.
Please free download MySQL Auto Backup at http://www.mysqlautobackup.com to help you to backup your MySQL databases automatically.
•
•
Join Date: Mar 2005
Location: LTT, South Africa
Posts: 125
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
you will need to have the database servers ip or dns name
mysqldump --opt databasename > path_and_filname.sql
or from your cmd prompt
mysqldump -h hostserver -u username -ppasword --opt databasename > path_and_filname.sql
restoring it is the above with the > changed to < if im not mistaken
mysqldump --opt databasename > path_and_filname.sql
or from your cmd prompt
mysqldump -h hostserver -u username -ppasword --opt databasename > path_and_filname.sql
restoring it is the above with the > changed to < if im not mistaken
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
