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.

Comments

Popular posts from this blog

Solution to Moodle Error: Coding error detected, it must be fixed by a programmer: Failed to unserialise data from file. Either failed to read, or failed to write.

ACTION_FAILED:OU_INVALID: Solution for GoogleApps bulk user upload issue, username@domainname.com:ACTION_FAILED:OU_INVALID. This error is because you have not specified the Org Unit Path properly.

(Solved) (Fixed )MariaDB Unmet Dependencies on Ubuntu 20.04.