Running SQL code on your WPMU database

July 14, 2009  | 
2 Comments

Taken from: The WordPress MU Manual

Occasionally you will install a mu-plugin where the auto-install fails to add the db table(s) for you.

This means you will need to run the SQL code in the “sql.txt” on your WPMU database. Plugins that may require you to complete this step include this instruction in their install file. You use the “sqp.txt” file contained in the zip file you downloaded.

Image of a SQL text file in the zip file

Run the SQL code in “sql.txt” on your WPMU database as follows:

1. Log into your cPanel
2. Scroll down to the database section and click on phpMyAdmin

Image of MyPHPadmin in cPanel

3. Click on the name on of the database you want to run the sql code on

Image of opening up MySQL database

4. Click on the ‘SQL’ tab

Image of clicking on SQL tab

5. Copy/paste the entire contents of the sql.txl into the Run SQL queries on database and then click Go.

Image of running a SQL code on your database

6. If successful you should see a message saying it has been executed successfully.

Image of successful SQL query

Next up this week we’ll be looking at setting up a support email in cPanel.

Featured Plugin - WordPress + Google Maps = Perfect

Simply insert google maps into posts, sidebars and pages - show directions, streetview, provide image overlays and do it all from a simple button and comprehensive widget.
Find out more

Featured Plugin - Start Your Own Powerful Membership Site

If you're thinking about starting a paid, or just private, membership site then this is truly the plugin you've been looking for. Easy to use, massively configurable and ready to go out of the box!
Find out more

Featured Plugin - Open an Online Store with MarketPress

Out of all the WordPress ecommerce plugins available, this has got to be the winner - easy to configure, powerful functionality, multiple gateways and more. A simply brilliant plugin!
Find out more

Featured Plugin - Send beautiful html email newsletters, from WordPress!

Now there's no need to pay for a third party service to sign up, manage and send beautiful email newsletters to your subscriber base - this plugin has got the lot.
Find out more

Featured Plugin - Start your own Quora / StackOverflow / Yahoo Q&A site

It's now incredibly easy to start your own Q&A site using nothing more than WordPress - The Q&A plugin simply and brilliantly transforms any site, or page, into a perfect support or Q&A environment.
Find out more

Featured Plugin - Every great SEO tweak you need, in one snazzy bundle

Fully integrated with the SEOMoz API, complete with automatic links, sitemaps and SEO optimization of your WordPress setup - this is the only plugin you need to help you rank your site number 1 on Google - nothing else compares.
Find out more

Featured Plugin - Host sites, get paid, just like WordPress.com

If you've ever wondered how you could offer a paid site management and hosting service, then this is the plugin for you. Offer a freemium or paid service, for any niche you like, it's powered Edublogs.org to success already!
Find out more

Featured Plugin - Easily integrate your WordPress site with Facebook

Would you like to add Facebook comments, registration, 'Like' buttons and autoposting to your WP site? Well, The Ultimate Facebook plugin has got that all covered!
Find out more

Featured Plugin - Turn any WordPress page into a fully featured wiki!

To get a wiki up and running you used to need to install Mediawiki and toil away for days configuring it... not any more! This plugin gives you *all* the functionality you want from a wiki, in WordPress!!!
Find out more

2 Responses to Running SQL code on your WPMU database

  1. Hi!
    Thanks for the cool post and I think that Run the SQL code in “sql.txt” on WPMU database is really helpful and the procedure which is given step by step its really best one and keep post regularly ,stay tune with us,Thank U…………………:IOI:

  2. Hi! its a nice post and the procedure of description its really great,Thanks for the post.

Click on a tab to select how you'd like to leave your comment

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting