Tag: MYSQL
-
How to Re-index Bibliographic Records in Koha
Sometimes after entering Bibliographic (Books) data to Koha, they are not visible in the search. Due to this issue we need to rebuild the Koha index using command: sudo koha-rebuild-zebra -f -v instancename
-
How to Backup MYSQL Databases
REM Export all databases names to file mysql -h your-server-ip -u user-name -ppassword information_schema –skip-column-names –execute=”SHOW DATABASES;” > databases.tmp echo “Start!” REM Look over database names REM Outter loop to get table names for /F %%A in (databases.tmp) do ( echo “Exporting table Names for %%A” mysql -h your-server-ip -u user-name -ppassword %%A –skip-column-names –execute=”SHOW…
-
How to import NPI data to MYSQL database
The Centers for Medicare and Medicaid (CMS) releasing the NPI database frequently. They also made a file available for downloading. It’s a zip file of 500MB that when unzipped expands into 5GB. The files can be obtained from http://www.cms.gov/Regulations-and-Guidance/HIPAA-Administrative-Simplification/NationalProvIdentStand/DataDissemination.html ZIP file contents header and data file in CSV format Header file has all the column…
-
How to export schema of MYSQL Database?
If you need schema of your MYSQL database for backup or any copy database to another server, then you must need schema with or without data. GUI tools like SQLYog, WebYog or PHPmyAdmin will best example for that. But if you need any command or utility then MYSQLDUMP has most important role. For using mysqldump…