richardbrinkman / curl-phpmyadmin

Export MySQL data from phpmyadmin using curl

curl-phpmyadmin

Export MySQL data from phpmyadmin using curl.

mysql-export.sh [-h|--help] [--stdout] [--tables=<table_name>,<table_name>] [--add-drop] [--apache-user=<apache_http_user>] [--apache-password=<apache_http_password>] [--phpmyadmin-user=<phpmyadmin_user>] [--phpmyadmin-password=<phpmyadmin_password>] [--database=<database>] [--host=<phpmyadmin_host>] [--use-keychain]
	-h, --help: Print help
	--stdout: Write SQL (gzipped) in stdout
	--tables: Export only particular tables
	--add-drop: add DROP TABLE IF EXISTS to every exporting table
	--apache-user=<apache_http_user>: Apache HTTP autorization user
	--apache-password=<apache_http_password>: Apache HTTP autorization password or keychain entry name if --use-keychain
	--phpmyadmin-user=<phpmyadmin_user>: PhpMyAdmin user
	--phpmyadmin-password=<phpmyadmin_password>: PhpMyAdmin password or keychain entry name if --use-keychain
	--database=<database>: Database to be exported
	--host=<phpmyadmin_host>: PhpMyAdmin host
	--use-keychain: Use Mac OS X keychain to get passwords from. In that case --apache-password and --phpmyadmin-password will be used as account name for search in Mac Os X keychain. 
	--lang=<languagecode>: Languagecode defaults to en-utf-8

Common uses:

mysql-export.sh --tables=hotel_content_provider --add-drop --database=hs --stdout --use-keychain --apache-user=betatester --phpmyadmin-user=hs --apache-password=www.example.com\ \(me\) --phpmyadmin-password=phpmyadmin.example.com --host=https://www.example.com/phpmyadmin | gunzip | mysql -u root -p testtable

exports and imports on the fly in local db