Backing up and restoring mysql database in Centos 5.5
To backup and restore mysql database in Centos 5.5.
Backup: To backup a database use the following syntax
#mysqldump -u databaseusername -p databasename > backupfilename.out
Restore: To restore the database backup file to new database:
#mysql -u databaseusername -p newdatabasename < backupfilename.out
Hope this is very much helpful.
Backup: To backup a database use the following syntax
#mysqldump -u databaseusername -p databasename > backupfilename.out
Restore: To restore the database backup file to new database:
#mysql -u databaseusername -p newdatabasename < backupfilename.out
Hope this is very much helpful.
Comments
Post a Comment