Etomite: How to add the MySQLDumper Snippet via phpMyAdmin

I am trying to add functionality to a client’s Etomite site, and a script allowing quick and easy database backup through a webpage interface is a real must. Of course, WordPress2 has this built into the admin panel 🙂 … but I digress.

I was unable to save the code snippet via the Etomite admin, and got the helpful suggestion in the Etomite forum to try adding the code directly into the database using phpMyAdmin. This worked a treat.

For those who would like to do the same, but are not very familiar with phpMyAdmin, here are a couple of screenshots and steps to help. But please, be careful!

Hopefully you know how to access your phpMyAdmin – usually via a control panel for your hosting account. Look for the MySQL Database link.

Once you’re inside PhpMyAdmin (looks scary, eh?), you can select your database from a drop-down menu. If you only have one database (for Etomite), then that’ll be displayed.

In the left-hand column, you’ll see all the tables listed. Click on the one for etomite_site_snippets. You’re now inside that table. PhpMyAdmin - Etomite Site Snippets

At the top of the page is a menu with commands – click on Browse. This will show you all the snippets you have in your Etomite.
Check the id numbers for the snippets – you want to pick the next number to assign to your MySQLDumper snippet.

Now it’s time to insert the snippet!
You guessed it: click on the Insert menu command at the top.

This page will allow you to enter your code snippet. Don’t worry … you only have to fill in that box on the right. 🙂
PhpMyAdmin - add MySQLDumper Snippet
Fill in the fields as shown in the screenshot (obviously, you’ve picked your own id number!) and paste the snippet code into the box. Then press the Go button.

That’s it!

Now all you have to do is add the snippet call into a document … and you have a spiffy backup function.

Etomite MySQLDumper backup

One thought on “Etomite: How to add the MySQLDumper Snippet via phpMyAdmin

  1. Hello there, You have done an incredible job. I will definitely digg it and personally recommend to my friends.

    I’m sure they’ll be benefited from this site.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s