Viewing articles tagged 'script'

  Script to import tables from file into an sqlite database

script to import #!/usr/bin/env bash# obtains all data tables from databaseTS=`sqlite3 $1...

 How to optimize the mysql database using mysqltuner script

Most modern applications these days including popular CMS use databases. As databases grow in...

 Mysql export databases script

We can use this command to export the databases as single files: mysql -uroot -p -e 'show...

 Mysql Import databases script

#!/bin/bash usage() {echo "$0 [mysql_parameters] <SQL files...>" >&2echo " Restores...

 Script to export tables from an sqlite database to files

script to export the tables:#!/usr/bin/env bash# obtains all data tables from databaseTS=`sqlite3...