Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

All pages tagged MYSQL

Back Up and Restore a MySQL Database

If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server. More...

Tags: MYSQL BACKUP RESTORE ZIP SHELL PHPMYADMIN HOW-TO Hits: 365229 Comments: 3

PHP: How to Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready. More...

PHP: How to connect to MySQL database using PHP

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running. More...

Tags: PHP CONNECTION DATABASE MYSQL FUNCTIONS RETRIEVE PRINT SQL QUERY Hits: 184267 Comments: 25

How to create a dump of MySQL database in one click

Your users probably asked you to add an option to export the whole database to SQL file. This can be done in phpMyAdmin or Navicat of course but your users want something simpler than that. More...

Tags: PHP MYSQL BACKUP DUMP EXPORT Hits: 87032 Comments: 0

PHP: Export Database Schema as XML

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema. More...

Tags: PHP MYSQL XML SCHEMA Hits: 80150 Comments: 7

PHP: Blocking access to the login page after three unsuccessful login attempts

Sometimes you need to add an extra protection to password-protected website. This article explains how access to the login page can be restricted after three unsuccessful login attempts. This schema uses visitors IP address to store log attempts in the database and block access to login feature for 30 minutes after third unsuccessful attempt. More...

ASP: How to connect to MySQL database

In this tutorial we will show you how to connect to MySQL database using a DSN and without a DSN. More...

Bike - drop in phpMyAdmin replacement

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps.

Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

More...

Tags: PHP MYSQL PHPMYADMIN Hits: 49028 Comments: 0

ADO and ADO.NET Connection Strings

Connection strings are string variables which contain database connection information and then passed to ADO which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. More...

MySQL Connection Strings

MySQL ODBC and OLEDB connection strings More...

Tags: MYSQL ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 34412 Comments: 0

How to determine MySQL version from the command line

How to determine MySQL version from the command line or from MySQL prompt. Quick and useful trick. More...

Tags: MYSQL Hits: 344 Comments: 0

Cannot load from mysql.proc. The table is probably corrupted

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat: "Cannot load from mysql.proc. The table is probably corrupted". Luckily there is an easy fix. More...

Tags: SQL,MYSQL,UPGRADE Hits: 136 Comments: 0



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.