SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: MySQL Backup
-
Oct 22, 2009, 03:12 #1
- Join Date
- Oct 2009
- Posts
- 1
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
MySQL Backup
Hi
I want to move a MySQL database from one server to another. Since this database is having more than 150 tables with humongous data inserted, I can’t take a regular backup like downloading as SQL file and then uploading it at the other MySQL server.
Also the server that currently hosts the database is not having SSH installed in it.
So is there any easy way by which u can move the database to the other server.
Is there any way by which I can login to the second server via putty and connect to the current server and move the databases?
Please advise me.
-
Oct 22, 2009, 03:51 #2
- Join Date
- Aug 2000
- Location
- Philadephia, PA
- Posts
- 20,578
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
You can use the -h flag on mysqldump to tell it to connect to the old database, and produce the .sql dump on the new server. Then run it through mysql to populate the database on the new server.
mysqldump --helpTry Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more
Bookmarks