SQLite£¬×÷Ϊһ¿îÇáÁ¿¼¶µÄ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ÒòÆäǶÈëʽÉè¼Æ¡¢ÁãÅäÖÃÔËÐÐÒÔ¼°¿çƽ̨¼æÈÝÐÔ¶ø¹ãÊÜ¿ª·¢Õßϲ°®
È»¶ø£¬Ëæ×ż¼ÊõµÄ²»¶Ï½ø²½ºÍÓ¦ÓÃÐèÇóµÄÈÕÒæÔö³¤£¬¶¨ÆÚÉý¼¶SQLite°æ±¾³ÉΪÁËÈ·±£Êý¾Ý¿âÐÔÄÜÓÅ»¯¡¢°²È«Â©¶´ÐÞ¸´ÒÔ¼°Ð¹¦ÄÜÌåÑéµÄ¹Ø¼ü´ëÊ©
±¾ÎĽ«ÉîÈë̽ÌÖÔÚLinux»·¾³ÏÂÈçºÎ¸ßЧ¡¢°²È«µØÉý¼¶SQLite£¬ÎªÄúµÄÓ¦Óñ£¼Ý»¤º½
Ò»¡¢Éý¼¶Ç°µÄ×¼±¸£ºÆÀ¹ÀÓë¹æ»® 1. ÆÀ¹Àµ±Ç°»·¾³ ÔÚ×ÅÊÖÉý¼¶Ö®Ç°£¬Ê×ÒªÈÎÎñÊÇÈ«ÃæÁ˽⵱ǰϵͳµÄSQLite°æ±¾ÒÔ¼°ÒÀÀµ¸ÃÊý¾Ý¿âµÄËùÓÐÓ¦ÓóÌÐò
ʹÓÃÒÔÏÂÃüÁî¿ÉÒÔ¿ìËٲ鿴ϵͳÖÐÒѰ²×°µÄSQLite°æ±¾£º sqlite3 --version ͬʱ£¬¼ì²éËùÓÐÏà¹ØÓ¦ÓõÄÎĵµ£¬È·ÈÏËüÃǶÔSQLiteа汾µÄ¼æÈÝÐÔ
²»¼æÈÝ¿ÉÄܵ¼ÖÂÊý¾ÝË𻵻òÓ¦ÓñÀÀ££¬Òò´ËÕâÒ»²½ÖÁ¹ØÖØÒª
2. ±¸·ÝÊý¾Ý ÎÞÂÛÉý¼¶¹ý³Ì¶àô¿É¿¿£¬Êý¾Ý±¸·Ý¶¼ÊDz»¿É»òȱµÄ±£ÏÕ´ëÊ©
¿ÉÒÔʹÓÃSQLiteµÄ`.dump`ÃüÁî»ò±àд½Å±¾×Ô¶¯»¯±¸·Ý¹ý³Ì£¬È·±£ËùÓÐÊý¾ÝÔÚÉý¼¶Ç°µÃµ½ÍêÕû±£´æ
ÀýÈ磺 sqlite3your_database.db .dump >backup_file.sql 3. ¹æ»®Éý¼¶Ê±¼ä Ñ¡ÔñÒµÎñµÍ·åÆÚ½øÐÐÉý¼¶£¬ÒÔ¼õÉÙ¶ÔÓû§µÄÓ°Ïì
ͬʱ£¬Í¨ÖªÏà¹ØÍŶӺÍÀûÒæÏà¹ØÕߣ¬È·±£ËûÃÇÁ˽âÉý¼¶¼Æ»®²¢×öºÃÏàӦ׼±¸
¶þ¡¢Linux»·¾³ÏµÄSQLiteÉý¼¶Êµ¼ù 1. ʹÓðü¹ÜÀíÆ÷Éý¼¶ ´ó¶àÊýLinux·¢Ðа棨ÈçUbuntu¡¢Debian¡¢FedoraµÈ£©¶¼ÌṩÁËͨ¹ý°ü¹ÜÀíÆ÷Ö±½ÓÉý¼¶SQLiteµÄ·½·¨
ÕâÖÖ·½·¨¼òµ¥¿ì½Ý£¬ÄÜ×Ô¶¯´¦ÀíÒÀÀµ¹ØÏµ
Ubuntu/Debian£º bash sudo apt update sudo apt upgrade sqlite3 Fedora£º bash sudo dnf upgrade sqlite Arch Linux£º bash sudo pacman -Syu sqlite ×¢Ò⣺°ü¹ÜÀíÆ÷Éý¼¶Í¨³£»á°²×°·¢Ðаæ²Ö¿âÖÐÌṩµÄ×îа汾£¬µ«¿ÉÄܲ»ÊÇSQLiteµÄ×îа汾
Èç¹ûÐèÒª×îÐÂÌØÐÔ»ò°²È«ÐÞ¸´£¬¿ÉÄÜÐèÒªÊÖ¶¯±àÒë°²×°
2. ÊÖ¶¯±àÒë°²×° ¶ÔÓÚ×·Çó×îа汾µÄ¿ª·¢Õß»òϵͳ¹ÜÀíÔ±£¬ÊÖ¶¯´ÓÔ´´úÂë±àÒë°²×°ÊÇÁíÒ»¸öÑ¡Ôñ
ÒÔÏÂÊÇ»ù±¾²½Ö裺 ÏÂÔØÔ´´úÂ룺 ·ÃÎÊSQLite¹Ù·½ÍøÕ¾ÏÂÔØ×îа汾µÄÔ´´úÂëѹËõ°ü
½âѹ²¢±àÒ룺 bash tar xzf sqlite-autoconf-.tar.gz cd sqlite-autoconf- ./configure make sudo make install ÑéÖ¤°²×°£º ÔÙ´ÎÔËÐÐ`sqlite3 --version`È·ÈÏа汾ÒÑÕýÈ·°²×°
3. ÅäÖû·¾³±äÁ¿ Èç¹ûϵͳÖдæÔÚ¶à¸öSQLite°æ±¾£¬È·±£Éý¼¶ºóµÄ°æ±¾±»ÕýÈ·µ÷Ó㬿ÉÄÜÐèÒªµ÷Õû»·¾³±äÁ¿
ÀýÈ磬ÔÚ`.bashrc`»ò`.bash_profile`ÖÐÌí¼Ó£º export PATH=/usr/local/bin:$PATH È·±£`/usr/local/bin`£¨»òʵ¼Ê°²×°Â·¾¶£©ÔÚ`$PATH`±äÁ¿Ç°£¬ÒÔ±ãÓÅÏÈʹÓÃа汾
Èý¡¢Éý¼¶ºóµÄÑéÖ¤ÓëÓÅ»¯ 1. ÑéÖ¤Êý¾ÝÍêÕûÐÔ Éý¼¶Íê³Éºó£¬Ê¹Óñ¸·ÝÎļþ»Ö¸´Êý¾Ý£¨Èç¹ûÉý¼¶Ç°½øÐÐÁ˱¸·Ý£©£¬²¢ÔËÐÐһϵÁвâÊÔÒÔÈ·±£Êý¾ÝÍêÕûÐÔºÍÓ¦Óù¦ÄÜÕý³£
sqlite3your_database.db