Tag Archives: Data

Huge collection of images of images in Chinese temples

The Zhejiang Library has put online a huge collection of images of (mostly Buddhist) sculpture, under the heading “中国寺庙祠观造像数据库“. There’s no proper page navigation, as far as I can tell, nor any search functions. Download times also very slow. Print sources are given for each image, so presumably these are all under copyright.

Comments on the work of the Old Hanzi Group towards an encoding of OBI script.

This document is a response to an invitation by Suzuki Toshiya and Deborah Anderson to comment on work by the Old Hanzi Group towards an encoding of early Chinese scripts. The comments are based on a review of documents archived on the IRG website:(http://appsrv.cse.cuhk.edu.hk/~irg/), and of the data deposited at ftp://ftp.iso10646hk.net/IRG/OldHanzi/.


0. Introduction

1. General remarks

2. Other projects

3. Feasibility of OBI standardization and encoding

4. Why Old Hanzi shoud be encoded separately from CJK

5. Documentation

6. Intended user group, and purpose of encoding

Import database in SQL format using PHPMyAdmin

The contents of a database (tables, indexes, data, etc.) can be exported from MySQL as a text file containing the SQL statements that recreate the database structure and populate it with the data. The following are the steps required to restore a MySQL database from such an SQL text file using PHPMyAdmin.

  1. Suppose we have an SQL file called db.sql. (PHPMyAdmin can also handle compressed or archived file formats like db.sql.zip – no need to unpack them first.)
  2. Using the web browser, navigate to http://localhost/phpmyadmin to start PHPMyAdmin.
  3. Be aware that importing an SQL file can overwrite existing tables or databases. Make sure that you know what the SQL file is supposed to do and that it won’t interfere unexpectedly with existing databases.
  4. Click the Import tab. Use the “Browse your computer” input box to select the SQL file to import.
  5. Note the size of the file, and the PHP “Max” file size next to “Browse your computer”. The default “Max” size on my installation was a puny 2,048KiB. If the SQL file that you want to import is too big, you could first try compressing it (to a zip file, say). If it is still too big, you need to edit the PHP configuration file php.ini. You could do this by hand with a text editor. Mine is at C:\wamp\bin\php\php5.3.8\. Alternatively you could go via the WampServer icon in the Notification Area… … (PHP > php.ini), which amounts to the same thing. Find the line that begins upload_max_filesize and modify the value that follows it. I have just changed mine from 2M (2 megabytes) to 100M. Save the modified php.ini file. Restart PHP/Apache.
  6. Choose the appropriate character encoding – my data files should always be in utf-8. Uncheck the “partial import” box unless you have a good reason not to. Make sure that “Format” is set to SQL.
  7. Click “Go”.