|
|
|||||||
|
MySQL backup tutorial In this tutorial I will show you a short and simple way how to create a backup copy of your MySQL database using the mysqldump utility. Automate Software Builds with Visual Build Pro Easily create an automated, repeatable process for building and deploying software. Table and database operations This chapter covers the operations that can be performed on whole tables or databases. It also explains table maintenance operations for table repair and optimization, changing various table attribute... Reset MySQL root password This tutorial is teach the database administrator on how to reset the root password if he/she forget the root password. Security Issues : Cleaning up User Data in MySQL One of the things you’re going to encounter when using MySQL with PHP sooner, rather than later, is the issues that arise when you start accepting user input in the form of comments or blog posts. Up ... Creating a Simple Comments and Login System using MySQL and PHP In this tutorial we'll build ourselves a very simple PHP application to accept user data and save it into our database. This information will then be displayed to anyone visiting the site. We’ll also ... Generating Reports using MySQL’s Aggregate Functions MySQL contains a range of functions which are useful for generating aggregate data about multiple records including averages, minimum/maximum values and sum/totals Using Multiple MySQL Tables with Unique IDs, Joins and Normalization In this tutorial we’re going to look at an example where it becomes useful to use more than one table at a time while still using the powerful features of MySQL to query this data in a simple, straigh... Column and Data Types in MySQL In this tutorial we won’t be doing anything too technical. Instead, we’ll be focusing on learning about how MySQL represents the data you give it to store, and the limitations and potential benefits e... Using PHPMyAdmin to manage your MySQL data PhpMyAdmin is a popular open-source application used to remotely manage and modify MySQL databases and is particularly useful for use on websites as it can be placed within a secure directory on a rem... MySQL basics Showing you the basics of MySQL and a little about setting it up in Linux. |
||||||||