Method 1 (Long Method)
mysqldump -u USER -pPASSWORD DATABASE > filename.sql
copy the file to the new host and restore using
mysql -u USER -pPASSWORD DATABASE < filename.sql
Method 2 (short method)
mysqldump –opt –compress –user=USERHERE –password=PWHERE
–host=SOURCE.HOST.HERE SOURCE_DB_NAME | mysql –user=USERHERE
–password=PWHERE –host=TARGET.HOST.HERE -D TARGET_DB_NAME -C
TARGET_DB_NAME
Best Deal Ads :
2 Responses to 'Backup and Restore MySQL Database Using Command Line'
Leave a Reply
Resources
Categories
Recent Posts
Archives
Blogroll
Blog Categories
Monthly Archives
By Month
- November 2010 (1)
- November 2009 (1)
- April 2009 (1)
- March 2009 (1)
- January 2009 (1)
- November 2008 (2)
- October 2008 (4)
- September 2008 (7)
- July 2008 (6)
- June 2008 (1)
- May 2008 (2)
- April 2008 (3)
- February 2008 (1)
- January 2008 (4)
- December 2007 (2)
- October 2007 (1)
- July 2007 (2)
- May 2007 (1)
- April 2007 (1)
- March 2007 (4)
- January 2007 (4)
- December 2006 (4)
- November 2006 (11)
- October 2006 (11)
- September 2006 (2)
Great man!
I will begin to use mysql shortly. I’ll need these commands.
Thanks!
hi i dont know much about linux but my boss gave me a job to backup all the mysql database and tables from fedora core4 running as web/database server. i can enter in fedora using remote desktop from my laptop but after that i am unable to do anything. if any one can help me in finding mysql and then tell me how to backup it at different directory of server as well as on my laptop. its urgent or i will loose my job. thanks in advance