In that case you can use the below simple steps to backup and restore a single mysql table using mysqldump utility.
Backup:
example :mysqldump -u -p databasename tablename > tablename.sql
mysqldump psa BackupsScheduled > BackupsScheduled.sql -u admin -p`cat /etc/psa/.psa.shadow`
Restoration :
for example :mysql -u -p databasename < tablename.sql
mysql psa < BackupsScheduled.sql -u admin -p`cat /etc/psa/.psa.shadow`
No comments:
Post a Comment