seafile从sqlite迁移到mysql

前端之家收集整理的这篇文章主要介绍了seafile从sqlite迁移到mysql前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. sqlite3.exe
  2.  
  3. 下载文件sqlite-shell-win32-x86-3071300.zip
  4.  
  5. First make sure the python module for MysqL is installed. On Ubuntu,use sudo apt-get install python-MysqLdb to install it.
  6.  
  7. Download these three files to /data/haiwen,ce_ccnet_db.sql,ce_seafile_db.sql,MysqL.sql(used for create tables in seahub_db).
  8.  
  9. Rename MysqL.sql to ce_seahub_db.sql: mv MysqL.sql ce_seahub_db.sql. Now you should have the following directory layout.
  10.  
  11.  
  12.  
  13. seahub.db
  14.  
  15. seafile.db
  16.  
  17. groupmgr.db
  18.  
  19. orgmgr.db
  20.  
  21. usermgr.db
  22.  
  23. 1. 导出成指定的sql脚本
  24. sqlite中指定的数据表以sql创建脚本的形式导出,具体命令
  25.  
  26. ywx@ywx:~/yu/sqlite$ sqlite3 test.db
  27. sqlite version 3.7.7.1 2011-06-28 17:39:05
  28. Enter ".help" for instructions
  29. Enter sql statements terminated with a ";"
  30. sqlite> .output data.sql
  31. sqlite> .dump
  32. sqlite>
  33.  
  34.  
  35. PRAGMA foreign_keys=OFF;
  36. BEGIN TRANSACTION;
  37. CREATE TABLE `Group` (`group_id` INTEGER PRIMARY KEY AUTOINCREMENT,`group_name` VARCHAR(255),`creator_name` VARCHAR(255),`timestamp` BIGINT,`type` VARCHAR(32));
  38. INSERT INTO "Group" VALUES(1,'信息科技部','015208@zjtlcb.com',1491567534304229,NULL);
  39. CREATE TABLE `GroupUser` (`group_id` INTEGER,`user_name` VARCHAR(255),`is_staff` tinyint);
  40. INSERT INTO "GroupUser" VALUES(1,1);
  41. CREATE TABLE GroupDNPair (group_id INTEGER,dn VARCHAR(255));
  42. DELETE FROM sqlite_sequence;
  43. INSERT INTO "sqlite_sequence" VALUES('Group',1);
  44. CREATE UNIQUE INDEX groupid_username_indx on `GroupUser` (`group_id`,`user_name`);
  45. CREATE INDEX username_indx on `GroupUser` (`user_name`);
  46. COMMIT;
  47.  
  48.  
  49. Create 3 databases ccnet_db,seafile_db,seahub_db and seafile user.
  50.  
  51. MysqL> create database ccnet_db character set = 'utf8';
  52. MysqL> create database seafile_db character set = 'utf8';
  53. MysqL> create database seahub_db character set = 'utf8';
  54.  
  55. Import ccnet data to MysqL.
  56.  
  57. MysqL> use ccnet_db;
  58. MysqL> source ce_ccnet_db.sql;
  59. MysqL> source ccnet_db_data.sql;

猜你在找的Sqlite相关文章