How to backup your mysql database

To backup your database, log into the siteutil panel, (http://www.siteutil.com), select the 'mysql databases' option.  click on the 'database' link.  click on the 'mysql database manager' button.  This will open up the phpMyAdmin database manager.  Enter the username/password combination for accessing your database.  

Once logged in perform the following steps

  1. Begin by clicking database in your phpMyAdmin panel.  (It may not be necessary to do this, depending on your version of PhpMyAdmin). 
  2. Select the database that holds your WordPress data, the database you created when you installed WordPress.
  3. Click 'Export'. 
  4. Select all the tables, and check the SQL radio button. 
  5. Check the 'Add Drop Table' box.
  6. Check the 'Add If Not Exists' box.
  7. check the 'Save as file' box.
  8. Check 'None' for compression.  If your database is very large, use a compression method.
  9. Click 'go'.  You will be prompted to either open the file or 'save as' which will allow you to select a folder on your local computer.  The data will now be saved onto your computer.
  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

Where can I find documentation for ServerObject's AspMail component?

This documentation can be found at: http://www.serverobjects.com/products.html For...

How do I upload files through my web pages?

You can use Software Artisan's SAFileUP. This is an ASP component that allows you to upload files...

What is PageCounter and how do I use it?

About Page Counter PageCounter is an object that counts and displays the number of times a Web...

How do I setup Microsoft Outlook Express to read my e-mail?

Follow these steps: Open Microsoft Outlook Express. From the Tools menu, click...

How do I setup Netscape Messenger to read my e-mail?

Follow these steps: Open Netscape Navigator. Click the Edit menu and then click Preferences......