php - MySQL (mysqldump) to SQLite on Android - is there a Windows shell / command line script? -


so, question entirely in title:

i'm running android virtual machine on windows machine , i'm trying transfer mysql database xampp-phpmyadmin server via php script , mysqldump create new sqlite database on android machine. when run script,

$config = parse_ini_file('config.ini'); $dump = shell_exec('mysqldump --user=' . $config['username'] . ' --password=' . $config['password'] . ' --opt users'); 

i sql dump, echo , receive string in android (i write file). sweats when think extracting sql syntax output.

so, isn't there nice little command line script me, or other more convenient way?

edit: clarification: script should able extract sql syntax mysqldump output (there's lot of non-sql output in there) can use string execsql in android. wondering: must have been done before, don't want start primordial ooze here.

edit 2: stackoverflow question convert mysql sqlite links this page containing mysql2sqlite, use cygwin convert; can't in php script, cygwin can't used windows command line mysql2sqlite , dump file parameter. right?

you can import mysqldump directly sqllite on android if you're exporting in .sql format , adding options recreating tables etc.

no need worry non-sql syntax in file, should commented out.


Comments

Popular posts from this blog

javascript - oscilloscope of speaker input stops rendering after a few seconds -

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -