1mysqldump -u<username> -p<password> --no-create-db myDB --ignore-table=myDB.table1 --ignore-table=myDB.table3-h localhost > mysql.backup See https://tecadmin.net/tutorial/mysql/skip-tables-in-mysqldump/

1cd /path/to/wordpress 2wp db export backups/name-of-db-backup.sql

1<?php 2$inipath = php_ini_loaded_file(); 3if ($inipath) { 4echo 'Loaded php.ini: ' . $inipath; 5} else { 6echo 'A php.ini file is not loaded'; 7} 8?> or 1[icasimpan!@example.org ~]$ php -i |grep php.ini 2Configuration File (php.ini) Path => /etc 3Loaded Configuration File => /etc/php.ini …

Verify if mcypt is really installed 1php -m|grep -i mcrypt Counter-check from phpmyadmin. If it say installed there, issue is that php-cli can't see mcrypt as a module. Find the mcrypt definition and symlink similar to below: 1ln -s /etc/php5/mods-available/mcrypt.ini /etc/php5/cli/conf.d/20-mcrypt.ini See details in …

1echo '<?php phpinfo(); ?>'|php

1mysqldump -u<username> -p<password> --no-create-db myDB -h localhost > mysql.backup That way, it would strip the original database name and NOT become a problem when importing to another database name. See …

From CLI, ssh to specific server and go to: 1/mnt/files/[site].[dev | test | prod]/backups/

1drush uli --no-browser

1curl -sS https://getcomposer.org/installer | php 2mv composer.phar /usr/local/bin/composer 3ln -s /usr/local/bin/composer /usr/bin/composer