A simple MySQL Backup Tool

A simple MySQL Backup Tool 

 

If you administer a website (or indeed a number of websites) you may need a tool which will allow you to simply backup a MySQL database on a regular basis. Although there are a number of tools available online, none quite fit our needs. As a result, we’ve quickly written a simple MySQL backup tool in PHP. Features

• Tested compatible with PHP version 5.2.14 and MySQL 5.0 
•  Allows for SQL and ZIP export of a single MySQL database 
• Lists previous backups made This is version 0.1a – it is no doubt buggy. 

We would appreciate any feedback if you do decide to use the tool. The application is fairly self explanatory in its usage. 

Installation 

• Extract the Zip file 
• Copy the contents to a directory on your server 
• Browse to the directory you saved the files to with your browser 

Features to be added in v0.2a (Release date 4th February 2011) Improved documentation Backup multiple databases Additional security (password for created ZIP files, and password for the utility) - See more... 

Briefly unavailable for scheduled maintenance. Check back in a minute

Briefly unavailable for scheduled maintenance. Check back in a minute

 

This WordPress error message appears when a plugin update fails half way through. The fix is extremely simple: FTP to your WordPress installation directory Delete the .maintenance file at the root wordpress folder (where wp-config.php lives) Login and retry the plugin operation - See more...

Sage Accounts

Sage Accounts: Username in use 

This is a very common issue with Sage – if the program crashes for whatever reason, you are unable to log back into the program. Before you start! I’d always recommend taking a backup of the company files before making any changes to Sage program or data files – just in case! The Sage file database system is a little antiquated and can be temperamental. The fix itself is simple: Browse to the Sage company file directory on your computer (this will vary, although if you check the COMPANY file in your install directory, it will be listed) Open the ACCDATA directory Delete the queue.dta file - See more...

Updating WordPress with 1&1 hosting

Updating WordPress with 1&1 hosting 

WordPress plays nicely with most web hosts, although 1&1 are a little different. If you try to update a freshly installed copy of WordPress on 1&1 hosting without making this change, some functions (mainly the automatic update processes) will not complete successfully. The key is to edit the .htaccess file in the WordPress installation directory: FTP to your WordPress installation directory Download the .htaccess file Edit the file, adding the following line: AddType x-mapp-php5 .php Upload the file to the server, overwriting the old .htaccess file - See more...

Blocking browsing to website subdirectories – 1&1

If you are using a webhost like 1&1, you may find that adding additional domains to your hosting package sets the default directory (the ‘home’ directory) as a subdirectory of the main site. Imagine you have two sites: www.abc.com www.newsite.com After adding the newsite.com entry to your list of domains the home directory may be set to www.abc.com/newsite/ – this will allow a user to browse to www.abc.com/newsite and access the new site. Why is this a bad thing? It’s uncertain whether sites like google treat multiple domains pointing to content as a bad thing – there is some information out there, like here, but the situation isn’t 100% clear. The best situation is to have the content isolated properly, so that the new site we have created newsite.com cannot be browsed in this fashion. There are two methods to resolve this issue: Set the home directory of the primary website to a subdirectory

• Configure abc.com to have a home directory of /http_docs/abc.com (or similar) 
• Configure newsite.com to have a home directory of /http_docs/newsite.com (or similar)

See more...

Scheduled Tasks – Running Tasks Without A Password in Windows XP

 

If you try to run a scheduled task in Windows XP, it will balk if you don’t enter a password (or if your main account has no password, it won’t let you proceed). There are two potential fixes: Run the task as the administrator (i.e. your-machine-name\administrator) You can then enter the administrators password. You may need to set this in Computer Management first: Right click My Computer Click Manage In the right hand window, click into Users and Groups Right click the Administrator account, and click Change Password Enter a password of your choice. You can then run the task as the system administrator. - See more... 

Enable Telnet Command in Windows 7

 

Telnet is a simple but extremely popular protocol for exchanging data between two computers. It is often used for testing computer programs. The Telnet utility is included with Windows Vista and Windows 7 computers although it is not enabled by default. Enable Telnet for Windows Vista/Windows 7 If you would like to enable Telnet, follow these steps: 1. Go to Control Panel. 2. Click into Programs and Features. 3. Click Turn Windows Features on or off. - See more...