You must be logged in to post Login


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Running a SQL Script in Wordpress

No Tags
UserPost

9:24 am
October 12, 2010


Eric – PersonalProfitability.com

Portland, OR

Member

posts 2120

Does anyone have any idea how to do this: http://diythemes.com/thesis/rt…..to-thesis/

They make it sound really easy, but I don't even know where to start.  Do I go into my DB admin interface and enter it somewhere?  I have backups of my DB from the WP DB Backup plugin, so I am good to go on that front.

Thanks all.

3:24 pm
October 12, 2010


Flexo

Member

posts 71

Mosts hosts have PHPMyAdmin installed, which will let you send SQL statements right to the database using a web interface. You can also do it from your server's linux/unix command line.

3:32 pm
October 12, 2010


Eric – PersonalProfitability.com

Portland, OR

Member

posts 2120

Can I get into that through CPanel?

4:55 pm
October 12, 2010


Flexo

Member

posts 71

I've never used CPanel, but it's possible. I get to mine through Plesk, which is like CPanel. If you have a separate subdomain for your mysql server, I'd start by just typing that in your web browser's address bar. You'll need your mysql username and password (you can find that in your WP config file).

4:51 am
October 13, 2010


Forest Parks

Cairo, Egypt

Admin

posts 1337

In cpanel you will find phpmyadmin and from there you can run sql commands….. do it once or twice and it becomes very easy but ALWAYS keep a backup before doing anything.

Vist me at Frugal Zeitgeist…. Frugal and Sustainable Living for the now…

6:04 am
October 13, 2010


Eric – PersonalProfitability.com

Portland, OR

Member

posts 2120

I got into PHPMyAdmin through MySQL and it looks like the code didn't work.  Ugh!

6:43 am
October 13, 2010


Forest Parks

Cairo, Egypt

Admin

posts 1337

Bugger :(….. Not used Thesis before so not sure why it didn't work…. Maybe just keep using all in one seo pack for now.

Vist me at Frugal Zeitgeist…. Frugal and Sustainable Living for the now…

8:00 am
October 13, 2010


Eric – PersonalProfitability.com

Portland, OR

Member

posts 2120

I have sites on two different hosts.  I ran the script on my other host and it seemed to work fine.  On the host where I keep Narrow Bridge it did not do anything.  Interesting…

Apparently I am missing some sort of DB access setting or something.

2:25 am
October 14, 2010


Forest Parks

Cairo, Egypt

Admin

posts 1337

Yeah I guess it's possible, best to ask your host for SQL editing access I guess.

Vist me at Frugal Zeitgeist…. Frugal and Sustainable Living for the now…

6:36 am
October 14, 2010


Car Negotiation Coach

Member

posts 125

You may have tried this already, but you might have to update your Thesis permissions first (through an FTP client).  Check the settings here: http://diythemes.com/thesis/do…..s/upgrade/

Geoff (aka The Car Negotiation Coach)

Check out my free ebook: How I Tripled My Affiliate Revenue without Adding Traffic & You Can Too. Or learn how to save big money when buying a car

 

8:07 am
October 14, 2010


moneysmarts

Member

posts 240

I think there is a plugin that will do this for you too if you can't get the SQL to work.

7:44 pm
October 14, 2010


Eric – PersonalProfitability.com

Portland, OR

Member

posts 2120

What plugin MoneySmarts?

10:19 am
October 28, 2010


nerdwallet

Guest

make sure you have your wordpress database selected in phpMyAdmin.  if you have multiple databases on your host, it won't be selected by default.

and phpMyAdmin usually throws off an error if there's something wrong with the MySQL statement.  otherwise it displays a green checkmark with text along the lines of "1 row modified in 5ms" or something.  

what kind of output are you getting?  maybe a screenshot would help clarify?

10:30 am
October 28, 2010


moneysmarts

Member

posts 240

NarrowBridge said:

What plugin MoneySmarts?


oh boy.. I wish i could remember. It was in a post somewhere about thesis and SEO.  I wish i could remember where, but i can't find it. sorry.

No Tags

About the Yakezie.com Forum

Forum Timezone: America/Los_Angeles

Forum Stats:

Groups: 2
Forums: 9
Topics: 6383
Posts: 84794

Membership:

There are 13651 Members
There have been 20 Guests

There are 9 Admins
There are 8 Moderators

Top Posters:

My Personal Finance Journey – 3159
Khaleef @ KNS Financial – 3149
Budgeting in the Fun Stuff – 3048
Sustainable PF – 2759
Miss T @ Prairie Eco-Thrifter – 2213
Eric – PersonalProfitability.com – 2120

Administrators: The College Investor (1935 Posts), Financial Samurai (1803 Posts), LaTisha @YoungFinances (1715 Posts), Forest Parks (1337 Posts), 20s Finances (1147 Posts), Money Reasons (697 Posts), Chris Johnson (78 Posts), Sydney at Untemplater (0 Posts), Suba (0 Posts)

Moderators: Suba @ Wealth Informatics (1876 Posts), sooverthis (1041 Posts), PK @ DQYDJ (361 Posts), jmichelsen (208 Posts), Ramona (13 Posts), JeremyNJohnson (4 Posts), Moderator (0 Posts), rackgeek (0 Posts)