Sofie Estolloso Hofmann Designs International

WEB DESIGN SERVICES

Website Design and Development, Content Management System (CMS), Wordpress Web Content Management System, WordPress Blog Design Customization, WordPress Web Design Customization, Web Design Consultancy, Web Hosting Consultancy, Domain Registration Consultancy, Website Promotion Consultancy, Blog Promotion Consultancy, Blogging Consultancy, Website Redesign, Website Maintenance

We especially specialize in WordPress Web Design and Development. We customize themes and design websites using WordPress as a CMS (Content Management System).

WEB DESIGN AND DEVELOPMENT SOLUTIONS

View more of our web designs. We have designed websites utilizing ASP, PHP, HTML, XHTML, MySQL, CSS, RSS and Javascripts among others.

Please do not hesitate to ask us for a non-binding appointment to discuss the possible project and what you really need in your website.

Contact us now and we will gladly help you.

Every time you update or upgrade your blog or website you are always being advised to backup your files and database.

You actually know how to upgrade your WordPress blog, for example, because of the WordPress Automatic Upgrade feature but you have no idea how to backup your database.

So, how would you backup your database?

There are several ways on how to backup your database but in this case I will show how to backup your MySQL database via phpMyAdmin.

How to backup MySQL Database via phpMyAdmin?

1. Locate your Databases or phpMyAdmin at the Control Panel of your account.

If you don’t know how to locate your database, read the following blog entries on how to locate MySQL Databases at the Control Panel.

How to locate Databases or phpMyAdmin at the PLESK Control Panel
How to locate Databases or phpMyAdmin at the H-SPHERE Control Panel
How to locate Databases or phpMyAdmin at the DREAMHOST Control Panel

Sometimes, you do not have to login at the Control Panel to login at the phpMyadmin.

But first, you need to find that link to your phpMyAdmin at the provided Control Panel.

2. Launch the phpMyAdmin from the Control Panel if you already found your Database or phpMyAdmin.

If you already know the link to your Database or phpMyAdmin, bookmark it for easy access.

Access the phpMyAdmin via the browser if you already know the link to your Database or phpMyAdmin.

Once you launched the phpMyAdmin or accessed the phpMyAdmin via your browser you might be required to login.

3. Type your database username and database password if you will be required to login.

Please take note that the database username and password are different from your Control Panel username and password.

4. Click the Login button.

Once you clicked the Login button, you will be redirected to the main phpMyAdmin page.

5. Click “Databases” to view your database or databases if you have more than one database.

You will be redirected to a new page where you will see your “Server:mysql” or “Server:localhost” depending on what the server is.

You will also see the menu type like Databases, SQL, Status, Variables, Charsets, Engines, Processes, Export, and Import.

You will see two columns namely the Database column and the Collation column.

I will not explain to you what those titles are all about but will only show you how to save or backup your database via phpMyAdmin.

6. Click the appropriate database name, the “database_sample” that you would like to backup.

You will be redirected to another page showing you two important things “Server:localhost” or “Server:mysql” and “Database: database_sample” above the menu type like Status, SQL, Search, Query Export, Import, and Operations.

7. Click Export among the menu.

You will be redirected to another page.

8. Check SQL and Check Select All to save all the data in your database.

9. Check Add DROP TABLE if not checked.

10. Check Add IF NOT EXISTS if not checked.

At least the four options under Structure except and before Add CREATE PROCEDURE.

11. Check Data, Complete inserts, Extended inserts, Use delayed inserts except Use ignore inserts.

Export type is INSERT.

12. Check Save as file.

Leave the File name template as it is.

13. Check None as Compression to save the database as simple text.

14. Click Go on the bottom right side corner.

Wait for it until the database file was downloaded.

Once it was downloaded, the database file has a “.sql” file extension as you checked SQL.

15. Save the file to any folder you want.

That’s it.

Now you know how to backup your database via phpMyAdmin.

What else?

You have the option to save a zipped file or a gzipped file.

Check the zipped or gzipped as Compression and follow the same procedure.

Once it was downloaded, the database file has a “.sql.zip” file extension for zipped file after the database filename like “database_sample.sql.zip” and a “.sql.gz” file extension for gzipped file after the database filename like “database_sample.sql.gz”.

What else?

Before you do this, be very careful! I would not want you to lose your data just because your server is slow.

Uncheck Save as file, check None as Compression and click Go if you would like to see the database in text format without saving it.

This is just to show you how your database looks like.

Wait until everything is visible.

If you see the text, that’s it!

What else?

Click the database name “database_sample” at “Database: database_sample” to return to the previous window if you would like to backup the database.

Click Export again, and follow the same procedure from number 1 to number 15.

Again, that’s it.

WARNING:

Do not do anything other than what I wrote here. I said, do not do anything other than what I wrote here.

Be very careful when clicking the icons, especially the empty icon, drop icon and delete icon. If you make a mistake, your database might be gone in just a few seconds.

WordPress 2.9 “Carmen” is another great WordPress release. WordPress 2.9 was released on December 19, 2009 but I never had the time to upgrade the blogs and sites before Christmas and even after the holidays. Then on January 4, 2009, WordPress 2.9.1 was released to address a handful of minor issues.

With the two releases, I just thought that it was time to upgrade. And so, yesterday, I upgraded the blogs and sites below from WordPress 2.8.6 to WordPress 2.9 “Carmen” to WordPress 2.9.1.

Sofie Hofmann dot com
Sofie Estolloso Hofmann Designs International
Pro Blog it | ProBlogging Venture Tips and Ideas, Reviews and Opinions
ISYU.INFO Around the World
Patria Diesel Power Plant Issue
Semirara Dumpsite Issue
Pandan Antique Philippines
Tugbong Festival
Weggis along Lake Lucerne Switzerland
PAGTATAP Foundation
Philippine Seafarers Assistance Programme
Leocadio Alonsagay Dioso Memorial Public Library

WordPress 2.9 introduced a lot of new great features like editing an image using the built-in image editor, updating the plugins in batches, embedding with oEmbed among others, but I have not really explored and tested them yet. I will not write about the new features. You can read all about them at WordPress.org or just watch the video below.

There is one thing though that I would like to share to you. If you have been following my blog every time I upgraded to a new released version of WordPress you probably knew about my problem with the Image Gallery feature of WordPress and how I found a solution to it.

I was sort of not in the mood before to find out what was the real problem so I looked for a simple solution. But yesterday, I really looked for the problem and what I can actually do about it so I do not have to comment on the four lines at the post.php file every time there is a need to upgrade.

With one site for example, the “File URL” at the Media Library was different from the “guid” at the wp_posts at the database. You probably knew already that the “File URL” if you need to “Edit Media” at the Media Library cannot be edited from there. So I especially looked for that particular problem and found out that I can actually edit it at the wp_postmeta at the database.

I could actually use some SQL syntax but opted to edit them one by one as I did not want to take any chances that I might make a mistake and delete some things that I do not want to delete. I just removed the unnecessary folders and subfolders before the file name of the photos at the wp_postmeta at the database.

With another site, it was more of adding the year and month before the file name of the photos at the wp_postmeta at the database. The year and month were not reflected when I first uploaded the photos because the miscellaneous settings were different then from the one at the present.

I changed the settings at the miscellaneous by checking “Organize my uploads into month- and year-based folders”. When I first uploaded the photos, I did not check “Organize my uploads into month- and year-based folders”.

With what I just told you, I did not comment anymore on the four lines at the post.php under the wp-includes folder. Other than the Image Gallery problem, upgrading from WordPress 2.8.6 to WordPress 2.9 to WordPress 2.9.1 went fine.