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

Advertisements
About

I live on Android and game on Playstation and Nintendo. The PS VITA is my favourite console. I'm also a passionate poodle mum.

Posted in CMS
One comment on “Etomite: How to add the MySQLDumper Snippet via phpMyAdmin
  1. Oyunu says:

    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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: