Word Press mysql & mysqldump helper scripts
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
 

blog comments powered by Disqus