How To Mysqldump Only One Table
RegisterLogin
How To Mysqldump Only One Table
Post Description: If You Want To Know How To Mysqldump Only One Table This Post Will Show You Backing Up Only One Table In The Entire Database This Will Help You
Tags: How, To, Mysqldump, Only, One, Table
This Post Was Posted On Jan 08, 2010 By Webune Tutorials #3008
Post Description: If You Want To Know How To Mysqldump Only One Table This Post Will Show You Backing Up Only One Table In The Entire Database This Will Help You
Tags: How, To, Mysqldump, Only, One, Table
This Post Was Posted On Jan 08, 2010 By Webune Tutorials #3008
How To Mysqldump Only One Table by Webune Tutorials
if you want to know how you can backup only one table in your whole database you can do it with one command. this command i will show you, you can even zip it to make it smaller:
in the following example, lets say i have this information:
db usename: WEBUSER
db password: DBPASSWORD
database name: MYBLOG
db table: DBTABLE
name of the backup file: MYBACKUPDB
ok use this linux shell command to create it:
SHELL COMMAND:
mysqldump -u WEBUSER -pDBPASSWORD MYBLOG DBTABLE | gzip > MYBACKUPDB.sql.gz
now, how about to install it - use this command:
SHELL COMMAND:
gunzip < MYBACKUPDB.sql.gz | mysql -u WEBUSER -pDBPASSWORD MYBLOG
done
Leave Your Comments
Related Pages: [Add Your Website]
Post New Topic
©2012 Webune Forums - Wed Dec 12, 2012 9:44 pm
Powered by: Webune Forums V3
Powered by: Webune Forums V3