El programa de copias de seguridad de base de datos mysqlhotcopy

http://dev.mysql.com/doc/refman/5.0/es/mysqlhotcopy.html

mysqlhotcopy es un script Perl que fue escrito originalmente por Tim Bunce. Usa LOCK TABLES, FLUSH TABLES, y cp o scp para realizar una copia de seguridad rápida de la base de datos. Es la forma más rápida de hacer una copia de seguridad de la base de datos o de tablas, pero sólo puede ejecutarse en la misma máquina donde está el directorio de base de datos. mysqlhotcopy sólo realiza copias de seguridad de tablas MyISAM. Funciona en Unix y NetWare.

Sigue leyendo

Dos trucos rápidos para MySQL: backup y restore desde consola

http://www.rafalinux.com/?p=1117

Habituado a utilizar prácticamente todos los días servidores, me doy cuenta que tengo una memoria algo mala, y que a veces soy incapaz de recordar dónde estaba tal o cual fichero de configuración (los olvidos son directamente proporcionales a la diversidad de los sistema operativos con que uno trabaja: Debian, Archlinux, Windows, etc). Suelo ir con mi chuleta de las órdenes más frecuentes, pero en el caso de no tenerla a mano, o cuando le está metiendo mucha prisa a uno, he decidido escribir una especie de receta-recordatorio.

Sigue leyendo

Model associations

http://appointsolutions.com/2012/07/using-model-associations-in-sencha-touch-2-and-ext-js-4/

The data package in Sencha Touch and ExtJS is awesome. Models let you easily and robustly configure your data structures and easily use them in all sorts of components. One of the model features that have a lot of potential but are used and understood relatively poorly are model associations. One of the most interesting uses of associations is that they allow you to use parent data when using the model in components. In practice this can be quite hard to accomplish however when all stores load their own data. In this blogpost I will show how to use parent (belongsTo) relations to automatically fetch and use parent data.

Model associations

Sigue leyendo

Sencha Touch 2 Models – hasMany Associations, PHP Example

http://miamicoder.com/2012/sencha-touch-2-models-hasmany-associations-php-example/

 

In this article you will learn how to use the hasMany association, a feature of Sencha Touch models that allows you to connect two models in a one-to-many relationship. The model configs you will learn about in this post are the following:

  • hasMany
  • belongsTo

The back-end code for this tutorial is in PHP. I also published a version of this Sencha Touch tutorial using C#

Let’s create a simple Sencha Touch application with the following files:

Sigue leyendo

How to Create a Sencha Touch 2 App, Part 1

http://miamicoder.com/2012/how-to-create-a-sencha-touch-2-app-part-1/

 

In this series we will create the Sencha Touch 2 version of the Notes Application, an application that allows its users to take notes and store them on the device running the app. Along the way, we will dive into the following areas:

  • The building blocks of a Sencha Touch application.
  • How to implement navigation in an application with multiple views.
  • How to edit data using Sencha Touch form elements.
  • How to render information using lists views.
  • How Sencha Touch stores data with HTML5 local storage.

In the first part of the series, we are going to define the features of the application, its look and feel, and we will start building its main screen.

Sigue leyendo

How to Create a Sencha Touch 2 App, Part 3

http://miamicoder.com/2012/how-to-create-a-sencha-touch-2-app-part-3/

In this third part of this tutorial on how to create a Sencha Touch application, we are going to create the Note Editor View. This is the View that will allow our users to create, edit and delete notes.

When we finish this article, our application will have the ability to create notes, and edit existing notes. Let’s get started building the Note Editor View.

Sigue leyendo