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
Post a Comment