|
Websites
|
|
Thursday, 16 June 2011 08:50 |
|
Here are two simple scripts that will allow you to use mysql and mysqldump without having to constantly open up wp-config.php to copy the DB connection information.
wp-mysql
#!/bin/bash
db_name=`grep DB_NAME wp-config.php | awk -F\' '{print $4}'`
db_user=`grep DB_USER wp-config.php | awk -F\' '{print $4}'`
db_pass=`grep DB_PASSWORD wp-config.php | awk -F\' '{print $4}'`
db_host=`grep DB_HOST wp-config.php | awk -F\' '{print $4}'`
mysql -u $db_user -h $db_host --password=$db_pass $db_name
wp-mysqldump
#!/bin/bash
db_name=`grep DB_NAME wp-config.php | awk -F\' '{print $4}'`
db_user=`grep DB_USER wp-config.php | awk -F\' '{print $4}'`
db_pass=`grep DB_PASSWORD wp-config.php | awk -F\' '{print $4}'`
db_host=`grep DB_HOST wp-config.php | awk -F\' '{print $4}'`
mysqldump -u $db_user -h $db_host --password=$db_pass $db_name
|