Posts Tagged database

How to Move a Database from one Host to Another Using phpMyAdmin

If you want to know how to move a whole site database from one host to another (say, from Godaddy to Dreamhost), this article is a must read. It will show and explain the whole process of exporting and importing a database (or to be more precise, all of its tables) using phpMyAdmin, the default MySQL database administrator. It is meant for those who don’t have Administrator access to phpMyAdmin (and cannot create databases from inside phpMyAdmin).

Let’s begin. First, you need to export your website’s database tables from the old host. To do so, access phpMyAdmin via your hosting panel (it’s Domain->Databases->DBWebAdmin for Plesk, and CPanel should have something similar), click on the database name (so that you see all the tables in the main window), then click on the “Export” tab at the top. Read the rest of this entry »

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

How Do Professional Programmers and Developers Test Their Work?

This article will cover a few of the techniques and tools used by professional web developers, designers and programmers in their work to test new code and improve their software/websites. Many people don’t know about this, and end up spending much more time on testing (uploading, changing code, troubleshooting) than needed.
This will be very useful to you if you are just starting out in any web development language like PHP, ASP, Javascript and others or if you just have a site that you want to maintain and improve yourself.

Let me start by saying that professionals rarely change and test their code via an FTP client right on their web server. This is because it takes a lot of time to download, edit and re-upload a file via FTP (especially when you’re changing just a line or two of code, or your Internet connection speed is less than stellar) and because they don’t want their visitors to notice any strange things on the website while they are testing the code.

So, what do they do?
They work and test everything locally, which means they have a copy of their website and database in a folder on their computer and they change those files and see the results immediately in any web browser. I’m going to show and explain a few tools used for this purpose in Windows (Linux and Mac OS X are a little different, although you can easily use the tips here for those Operating Systems, too). Read the rest of this entry »

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,