Backing Up WordPress Database

In a Plesk 9 environment – go to Domains >> the domain you’re looking to backukp the database for >> Databases >> Webadmin

This will launch phpMyAdmin web based MySql interface.

Choose the database for the WordPress installation that is being backed up.

Click on the Export Tab

back-phpadmin

 

Check Add DROP TABLE in Structures,  Complete inserts in Data and Save as file with None for compression

 

back-phpadmin2 

The file will download to you computer

back-phpadmin3

 

A more detailed offical instruction set can be found here.

http://codex.wordpress.org/WordPress_Backups

Badmail on IIS SMTP

I’ve had to deal with this issue a number of times so in case I need to again here the handy dandy solution.

The problem is that mail destined for bad recipients goes to the Badmail folder in mailroot. When SPAMMers impersonate senders using your domain this can fill quite quickly. Yesterday, I was confronted with a Badmail folder with almost half a million emails.

What to do?

I created another folder called Badmailnew. I took away all write permissions to this folder from the system.  In IIS in the SMTP properties you can select the folder you wish to use as Badmail. I pointed it to this new folder. Since the new folder does not allow the system to write the bad mail cannot be placed there.

WordPress Upload Limit GoDaddy Shared Linux Hosting

I ran across a number of sites describing how to do this but none were working for me. They did all have parts of the puzzle.

You need to add the following values or whatever amount your looking to increase to a file called PHP5.INI and place this in the wp-admin folder of your WordPress install.

memory_limit = 100M
upload_max_filesize = 192M
post_max_size = 100M
file_uploads = On

Wildcard DNS Using Plesk 9 and LAMP

I was trying to setup a WordPressMU site and I needed to enable Wildcard DNS. I found some excellent resources on this at this page run by 1&1 hosting.

http://www.1and1faq.com/forums/archive/index.php/t-602.html

Some of the commands in SSH regarding the websrvmng confused me. The following page shows some  of the commands you can run on this program.

http://mattiasgeniar.be/2009/07/26/how-to-change-a-servers-main-ip-address-including-dns-records-in-plesk/

addendum:

I setup another WordPresMU site. I had problems using the site even after following the above instructions. The problem turned out to be that the first site DNS info was with Network Solutions who already had a CNAME record with the wildcard domain setup. The new one was being hosted by GoDaddy. This did not have a wildcard for sub-domains setup by default. I tried to setup a CNAME record but it was refused. I created an A name wildcard. That’s doing the trick.