In this Moon festival, I'm practice to modified iOS game pocket planes 1.1.7, and it works on my iOS 7 environment with iPhone5 -------------------------------------------------------------------------------------------------- [Steps] 1. Find database position it under : /Documents/playerData/user-playerData.db 2. Use SQLite browser to open .db 3. Modified database, you can refer to follow instruction: [DB] /Documents/playerData/user-playerData.db [Table] playerMeta [Columns] b: => Money c: => Gold [Table] planes [Columns]...
#! /bin/bash U=userid P=password insert="insert into table_name(columns1, columns2) values (values1, values2)" /usr/bin/mysql -u$U -p$P >> eof $insert >> sh ***.sh ---------------------------------------------------------------------------------------- table count select count(*) from table_name table numbers 可用 default value [Reference] http://stackoverflow.com/questions/13814413/how-to-auto-login-mysql-in-shell-scripts http://phorum.study-area.org/index.php?topic=15790.0 http://stackoverflow.com/questions/8753371/how-to-insert-data-to-mysql-having-auto-incremented-primery-key ...
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql [Reference] http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/ http://blog.sina.com.cn/s/blog_5ac7b9bc01011vcg.html ...
