Rogers Canada MMS APN settings for Unloc...

I had to setup my phone today for MMS, and it took forever to find the proper settings online. Just go into settings, wireless, apn settings, and add a new APN for rogers MMS.

Hopefully someone else up here in Canuckistan can use this;

Name: Rogers MMS
APN: media.com
Username: media
Password: mda01
Server: 172.25.0.107
MMSC: http://mms.gprs.rogers.com
MMS Proxy: 10.128.1.69
MMS Port: 80
MCC :302 (should already be filled in)
MNC: either 720 or 72 depending on your SIM card (should already be filled in)
APN Type: mms

Enjoy MMS!

Popularity: 21% [?]

Mass Deleting Posts By Date On WordPress...

Today I duplicated a site I have running in a certain niche. I needed to delete all the old posts from certain years, and couldn’t find a plugin to do this easily. So. I went into trusty old PHPMyAdmin and did it manually. Here’s what you need to do.

1. Login to phpmyadmin

2. Find your wordpress database.

3. Go to the ‘wp_posts’ table in the database.

4. Hit the ‘sql’ tab in phpmyadmin, and use a variety of the following commands.

To Delete Posts By Date:

DELETE FROM `wp_posts` WHERE `post_date` like ‘%2008%’;

To Delete Posts With Certain Content In The Body:

DELETE FROM `wp_posts` WHERE `post_content` like ‘%test_content%’;

To Delete Posts With Certain Content In The Title:

DELETE FROM `wp_posts` WHERE `post_title` like ‘%test_content%’;

Note that you will have to change the contents between the % and % in those sql statements to your own.

That’s it. Watch it delete your posts in just seconds, instead of hours and hours of work through the wordpress backend.

Hope this helps you out too.

Popularity: 13% [?]

Problems Migrating Prosper202 Between Tw...

Today I was faced with migrating my P202 installation from one host to another. As normal, I ran the mysqldump command on the old server to dump the database and scp’d it over to my new host – went to import and I got a bunch of errors like this;

ERROR 1016 (HY000): Can’t open file: ‘./202_SITENAME/202_locations_block.frm’ (errno: 24)
ERROR 1016 (HY000): Can’t open file: ‘./202_SITENAME/202_locations_block.frm’ (errno: 24)
ERROR 23 (HY000): Out of resources when opening file ‘./202_SITENAME/202_locations_block#P#p413.MYD’ (Errcode: 24)

WTF?

I have plenty of RAM, and resources on my new box so this was a little confusing. Turns out that you need to make a couple adjustments in order to re-import the database on Linux servers. Here’s what I did to make it import properly.

first, you have to edit the security limits for mysql on your NEW server, especially if you have a high number of connections to databases. This is done like this;

# nano /etc/security/limits.conf

and add these lines to the bottom

mysql   soft    nofile  24000
mysql   hard    nofile  32000

Then, you’re going to have to edit your my.cnf, which for me on Ubuntu is done like this;

# nano /etc/mysql/my.cnf

and add this line in the tuning section

open_files_limit        = 20000

Now, go back to your original server, and re-dump the database like this;

mysqldump -C -i –single-transaction -u root -p DATABASENAME >>DATABASENAME.sql

Then, scp the file over to your new server like this;

scp DATABASENAME.SQL username@hostname.com:

Once the file has transferred, ssh over to your new host and issue the following commands (for Ubuntu, may be different on other Linux flavors)

/etc/init.d/mysql stop

/etc/init.d/mysql start

mysql -u root -p

<entering password>

then, once you are inside the MySQL command line you’re going to want to select your database like this

> use DATABASENAME;

then, you’re going to want to import your database from the old server

> source DATABASENAME.SQL;

wait a few seconds, you shouldn’t see any errors and then you’re done. You can exit the mysql command line now;

> exit;

Now you should have a perfectly working P202 installation, on your new server migrated from an old one.

Incase you’re wondering, no I did not go remove these settings – figured higher limits were good anyway – if they cause a problem on my server I’ll update this post for y’all.

Hope this helps someone else as I had to do a couple hours of searching, and testing to get all this sorted out.

Popularity: 33% [?]