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

Post a Comment

Popular posts from this blog

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.

-
To upload bulk users to GoogleApps, you will require a following required fileds, other fields are optional:-               First Name               Last Name               Email Address               Password               Org Unit Path What is 'Org Unit Path'? This field was not their earlier. This is the path to place users in an organizational unit. For example if your domain has different organization unit like , staff, students, guest etc.. then the Org Unit Path would be just :  /
Read more

Moodle OAuth 2. This account is pending email confirmation! Solved

-
Image
If you happen to come across this ' This account is pending email confirmation' message while using Google OAuth2 in Moodle. Try these following solutions: Solution 1. First login to you Moodle and Admin. Go to Site Administration --> Server--> oAuth 2 Services go to setting. Make sure the Require email verification is NOT checked. Solution 2: Login to Moodle database and delete the particular user #mysql -uroot -p\ mysql> use moodledb; mysql> SELECT * FROM mdl_auth_oauth2_linked_login WHERE email='sjamso@moodle.edu.bt'; mysql>D ELETE FROM mdl_auth_oauth2_linked_login WHERE email='sjamso@moodle.edu.bt';
Read more

Enable SIP2 in Koha. How to configure SIP server in Koha 18.11??

-
First to enable the SIP2, run the commands below: # koha-enable-sip library       [where library is the koha instance name] # koha-start-sip library          [start the sip server] # koha-stop-sip library           [stop the sip server] Next, configure the SIPconfig.xml # vim /etc/koha/sites/library/SIPconfig.xml Add the necessary details in the SIPconfig.xml file <acsconfig xmlns="http://openncip.org/acs-config/1.0/"> <!-- above address gets nothing, it's just a namespace -->   <error-detect enabled="true" /> <!--   Set Net::Server::PreFork runtime parameters   syslog_ident will identify SIP2 Koha server entries in syslog   For OpenSolaris, add: syslog_logsock=stream -->   <server-params             min_servers='1'            min_spare_servers='0'         ...
Read more