Yakezie.com - Topic: Running a SQL Script in Wordpress

moneysmarts on Running a SQL Script in Wordpress

Thu, 28 Oct 2010 10:30:36 +0000

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.

nerdwallet on Running a SQL Script in Wordpress

Thu, 28 Oct 2010 10:19:55 +0000

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?

Eric - PersonalProfitability.com on Running a SQL Script in Wordpress

Thu, 14 Oct 2010 19:44:21 +0000

What plugin MoneySmarts?

moneysmarts on Running a SQL Script in Wordpress

Thu, 14 Oct 2010 08:07:53 +0000

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

Car Negotiation Coach on Running a SQL Script in Wordpress

Thu, 14 Oct 2010 06:36:41 +0000

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/

Forest Parks on Running a SQL Script in Wordpress

Thu, 14 Oct 2010 02:25:16 +0000

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

Eric - PersonalProfitability.com on Running a SQL Script in Wordpress

Wed, 13 Oct 2010 08:00:46 +0000

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.

Forest Parks on Running a SQL Script in Wordpress

Wed, 13 Oct 2010 06:43:35 +0000

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

Eric - PersonalProfitability.com on Running a SQL Script in Wordpress

Wed, 13 Oct 2010 06:04:12 +0000

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

Forest Parks on Running a SQL Script in Wordpress

Wed, 13 Oct 2010 04:51:25 +0000

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.

Flexo on Running a SQL Script in Wordpress

Tue, 12 Oct 2010 16:55:47 +0000

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).

Eric - PersonalProfitability.com on Running a SQL Script in Wordpress

Tue, 12 Oct 2010 15:32:46 +0000

Can I get into that through CPanel?

Flexo on Running a SQL Script in Wordpress

Tue, 12 Oct 2010 15:24:59 +0000

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.

Eric - PersonalProfitability.com on Running a SQL Script in Wordpress

Tue, 12 Oct 2010 09:24:16 +0000

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.