Click on the link above to snag a program I wrote to check to see if links in WordPress blogs are active. I run it every night in my crontab.
A shout out to Jose Solorzano who wrote the simple HTML DOM parser.
Click on the link above to snag a program I wrote to check to see if links in WordPress blogs are active. I run it every night in my crontab.
A shout out to Jose Solorzano who wrote the simple HTML DOM parser.
$userinfo->user_email
This assumes you have ssh access on a linux system and already have
wordpress databases laying around and that you are very familiar with
the mysql command and unix in general
- Create a fresh database on the server:
mysql -u root -p
CREATE DATABASE dbname;
grant all privileges on dbname.* to dbusername@localhost identified by ‘dbusernamePassword’;
FLUSH PRIVILEGES;
exit;
- Unpack a fresh wordpress release from the wordpress site
wget http://wordpress.org/latest.tar.gz
tar -xzf latest.tar.gz
mv wordpress aNameYouPick
rm latest.tar.gz
- Copy over a recent good wp-config.php and edit it.
- Install WordPress, open permissons so apache can write to the folder and wp-content
- Set the permalink structure to /%postname%
- Copy the old wp-content folder to the new installation
- Copy anything else that needs to go over.
- Get a dump of the database either from a backup or phpMyAdmin put in dbname.sql on the server
- Edit the dump: make sure the urls are going to work
- Move the dump to the server
- Import the dump on the server from the command line:
mysql -u root -p dbname <dbname.sql
Note if you are using MAMP on a mac you can find the mysql command in
the MAMP folder. Make sure you start the mysql command with the root
user, eg: mysql -u root -p
Awesome process for uploading a local database to a remote machine It just worked! Original here.
Summary