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.
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. 🙂
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.
Now all you have to do is add the snippet call into a document … and you have a spiffy backup function.