Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = 'chips_';
- $db_dump = 'test2.sql';
- $sql_dump = 'sqlite3.db';
- $ssh_host = '';
- $ssh_user = '';
- $ssh_pass = '';
- $db_host = '';
- $db_user = '';
- $db_pass = '';
- $db_name = '';
- $ssh = "sshpass -p $ssh_pass ssh $ssh_user@$ssh_host";
- // $ssh = "ssh -i $ssh_key $ssh_user@$ssh_host";
- // 1. get all tables for given host
- $tables = str_replace(PHP_EOL, ' ', trim(`$ssh "MYSQL_PWD='$db_pass' mysql --host=$db_host --user=$db_user --database=$db_name --batch --silent --execute='SHOW TABLES LIKE \"${host}%\"'"`));
- // 2. make MySQL database dump
- `$ssh "MYSQL_PWD=$db_pass mysqldump --host=$db_host --user=$db_user --no-data $db_name $tables" > $db_dump`;
- // 3. convert to SQLite3
- `./mysql2sqlite $db_dump | sqlite3 $sql_dump`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement