| Como reparar replicaciones MySQL | | 2008-07-11 18:10:29 | | Ultimamente eh estado investigando un poquito de este tema porque lo estoy usando para un trabajo, asi que les comparto lo que voy aprendiendo.
Por causas aun desconocidas(aun no se mucho del tema) el slave dejo de actualizarse, asi que busque un poco de informacion y encontre que habia que revisar el log de MySQL [...] | | By: Jorgelig Blog | | |
|
| Algunos links para Replicacion con Mysql | | 2008-07-08 01:44:07 | | Apenas acabo de meterme un poco mas a fondo con Mysql, normalmente no salia del clasico UPDATE, SELECT con uno que otro INNER JOIN, etc.. pero debido a las necesidades de un sistema en el que estoy colaborando me es necesario hacer cositas un poco mas complejas cada vez. Ahora le toco el turno a [...] | | By: Jorgelig Blog | | |
|
| FAQ: How to install and configure MySQL cluster? | | 2008-07-03 08:33:39 | | Question: Can you give me more information on how to set up MySQL cluster?
Answer: Sure, below are the links to extremely informative Internet resources providing detailed guides on why and how to deploy MySQL cluster.
By the way a cluster in IT field is a group of linked computers, working together so they form a single [...] | | By: Linux Screw | | |
|
|
|
| Quick copy/paste MySQL Replication Manual | | 2008-07-02 09:33:31 | | This quick manual tells how to set up database replication in MySQL. Basically it was written for 5.* MySQL versions but is also applicable for 3.23/4.0 ones (btw they are still in use, believe me).
As you might already know, replication allows you to create a copy of certain MySQL database from a master server on [...] | | By: Linux Screw | | |
|
| Sekilas Tentang MySQL | | 2008-06-22 23:47:35 | | Mungkin ada beberapa di antara pembaca sekalian yang bingung ketika melihat kata “MySQL”. Sebenarnya apa itu MySQL? MySQL merupakan salah satu dari beberapa database yang paling banyak digunakan yang bersifat open source yang dibuat oleh MySQL AB.
Kenapa paling banyak digunakan? Karena MySQL mempunyai kelebihan dalam hal kecepatan mengakses data, gratis, dan mudah digunakan. Nah, [...] | | By: Danta's Articles | | |
|
|
|
|
| Installation and Configuration of MySQL in Ubuntu | | 2008-05-29 03:46:00 | | To install MySQL, run the following command from a terminal prompt:
sudo apt-get install mysql-server
During the installation process you will be prompted to enter a password for the MySQL root user.
Once the installation is complete, restart the MySQL server: sudo /etc/init.d/mysql restart
Check if MySQL is running: sudo netstat -tap | grep mysql
you should see the following line or something
| | By: Complete Dose of Linux Poison | | |
|
| inParadize jobs - PHP, Perl, MySQL, - Mumbai openings | | 2008-05-25 14:50:00 | | Development of advanced software and systems for interactive websites, online portals and enterprise applications using PHP and MySql working over Linux with high security, scalability and...
For more info on latest job openings and other career related information visit my site http://venky-itjobs.blogspot.com
| | By: IT Jobs and Career | | |
|
| PHP & MySQL Web Development All-in-One Desk Reference For Dummies | | 2008-05-17 13:48:30 | | Webmasters and Web programmers around the world know that PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating dynamic, database-driven Web sites for eCommerce and content management. In fact, PHP is used in one of every three Web sites on the Internet and MySQL has been downloaded millions of times. PHP and MySQL provide a freely downloadable and widely supported alternative to ASP.NET.this book provides six discreet minibooks are organized as follows: Book I: PHP Programming - Setting Up Your PHP Environment, PHP Basics, Building PHP Scripts, PHP and Your Operating System, Object-Oriented Programming. Book II: Using MySQL - Setting Up MySQL, Administering MySQL, Building a Database, Other Administrative Tasks, Using MySQL Administrator, Using MySQL Query, Using phpMyAdmin. Book III: Using PHP with MySQL - Communicating with the Database; Creating and Modifying Database Structure; Adding, Updating, and Removing Data; Retrieving Data from the Database; Adva | | By: free e book | | |
|
| MySQL Data Types and Properties | | 2008-05-13 04:57:52 | |
Have a look at the following line of code from the post Storing
and Retrieving Data from MySQL Database.
CREATE TABLE phno(
name varchar( 50 ) ,
phnum varchar( 20 )
)
As I told you we have to declare the column data types while creating tables
depending on the values we want to store. MySQL has wide variety of data types,
out of which I’m stating some of the important ones below:
CHAR: For storing character and string data, faster than VARCHAR.
VARCHAR: For storing character and string data. Slower but efficient in
storing variable length string as only the needed memory is used no matter
how much we allocate.
INT: For storing regular integers. Same as INTEGER, other related data
types are TINYINT, SMALLINT, MEDIUMINT, BIGINT.
FLOAT: For storing floating point values, it is 4 bytes long. There is
also a DOUBLE which is 8 bytes long.
DATE: For storing YYYY-MM-DD date values.
Be | | By: Learning Computer Programming | | |
|
| Howto create a MySQL user | | 2008-05-13 04:46:00 | | Here is a quick tip how to create from mysql new database and a new mysql user that has full privileges on this newly created database:
mysql -uroot -p
CREATE DATABASE ;
GRANT ALL PRIVILEGES ON .* TO 'my_user'@'localhost' IDENTIFIED BY 'my_password' WITH GRANT OPTION;
| | By: Complete Dose of Linux Poison | | |
|
| Howto change the MySQL root password | | 2008-05-13 04:45:00 | | Here is a quick tip that will show several methods to change the mysql root password (that is normally empty at mysql initial install).
Method 1: using the SET PASSWORD command:
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
Method 2: using mysqladmin
mysqladmin -u root password "newpass"
| | By: Complete Dose of Linux Poison | | |
|
| Storing and Retrieving Data from MySQL Database | | 2008-05-12 06:58:01 | |
You may first want to read Installing,
Configuring and Testing MySQL Database Server on 'localhost', About
MySQL, Databases and SQL Commands.
Now that you have installed MySQL database server and have learnt some SQL
commands to query MySQL, its time to use our knowledge to do what database servers
are used for, storing and retrieving data.
To make for a nice example, we’ll create a simple Phonebook Application
which would store phone numbers and names of peoples. It’d be able to
illustrate the storage and retrieval of data from database quite well.
OK let’s first start with the datable design. We’d need to create
a database first and table in that database. One table is enough because we
only need to store name and phone number which should be stored in the same
table. For the table we should have two fields (column), one for name and the
other for phone number. Both can be of data type (MySQL) VARCHAR as we don’t
need to | | By: Learning Computer Programming | | |
|
| About MySQL, Databases and SQL Commands | | 2008-05-12 02:20:55 | |
In the last post we ‘created
a database’ from our script as an example to test the working
of MySQL. Actually a database is a set of tables for storing data. The tables
in a database may be logically related with each other. MySQL supports unlimited
number of databases and for each application you may use a different one
To understand relation between a database and tables consider an example of
a database oriented Note
Keeping application. Since it needed user authorization we can store
user information such as username and password in one table, upgrading that
system to multi-user capable is also possible because a table can store any
number of rows (i.e. different set of username & password, in this case).
We’ll also need a second table for storing note data. Thus we’re
using a database having two tables to store data related to a single application.
The following image illustrates this relation quite well:
MySQL data | | By: Learning Computer Programming | | |
|
| Installing, Configuring and Testing MySQL Database Server on ‘localhost’ | | 2008-05-12 02:18:42 | |
Here we go with another installation and configuration post for out local server;
this time for MySQL, the well known and widely popular free database server.
[You may want to read Installing
Web Server on your PC, Installing
Apache and PHP on your PC and Configuring
Apache Web Server and PHP]
In this post, we’ll learn to set-up MySQL server on our own local server
and see how we can connect to it from our scripts.
Since the last few posts we have been having problems implementing data storage/retrieval
from files, we thought it was the right time to start using database for that
purpose. However before we can use database connectivity from our scripts, we
need to install a database server, we’ve chosen My SQL. In spite of MySQL
database server being free, it has proven itself time and again as the best
database server around. Its free too so there is no point in us looking for
anything else.
OK, let’s start by first downloading
t | | By: Learning Computer Programming | | |
|
| MySQL-FRONT now | | 2008-05-07 21:34:00 | | MySQL is the world's most popular open source database software, and almost every high-volume Web sites used it because it have fast performance, high reliability and ease of use. And now MySQL database is owned, developed and supported by Sun Microsystems, one of the world's largest contributors to open source software.And because MySQL is an open source database software, some newbie user can't easily used it thats why "MySQL-FRONT"came to resue.But why some newbie user can't easily used it? Because MySQL is a key part of LAMP(Linux, Apache, MySQL, PHP/Perl/Python) and because linux only using minimal GUI and MySQL access only through phpmyadmin web application.So MySQL-FRONT came, MySQL-FRONT is a graphical GUI for the MySQL database. It has a total control of the graphic display, information can be presented as clearly as possible. Your data is presented in a table with resizable column-width and sorting capability.But not to think that this is also an open source software, sorry b | | By: Pinoy Technology | | |
|
| Web Experts (PHP, MySQL, HTML) - Mumbai - EXA India | | 2008-04-29 12:56:00 | | Required Skills: The successful applicant will be able to: Develop web applications using PHP/MySQL. Understand, analyze & modify existing popular open source scripts. Have good knowledge of AJAX and...
For more info on latest job openings and other career related information visit my site http://venky-itjobs.blogspot.com
| | By: IT Jobs and Career | | |
|
|
| Nueva version de MySQL con importantes mejoras | | 2008-04-17 09:21:00 | | La adquisicion de MySQL por parte de Sun ya se empieza a notar.La proxima semana Sun usara el evento de Santa Clara (California) para liberar MySQL 5.1, Entre los avances de esta version están el particionado, la programación de eventos, la replicación basada en filas y el clustering basado en disco. Son funciones habituales en los productos de IBM, Oracle y Microsoft, pero deberían ayudar a MySQL a competir en entornos en los que el rendimiento y la capacidad para escalar son críticos.Fuente | Copia Original Extraido de | Libertad digitalVisto en | Barrapunto | | By: Software libre y sus trucos de Free Spirit | | |
|
| OpenBSD: Secure Mail Server with Postfix, MySQL, ClamAV, SpamAssassin, Amavis-new | | 2008-04-17 03:23:51 | | Few days ago I started configuring corporate mail server that should be deployed on OpenBSD and comprise the following features:
Easy to configure and powerful MTA (Postfix)
Virtual domains and user accounts (this information is stored in MySQL database)
Antispam and antivirus checking for all accounts (spamassassin and clamav via amavis-new)
Secure access to mailboxes through POP3, IMAP and [...] | | By: Linux Screw | | |
|
| Walkin - Yahoo India - 19, 20 Apr 2008 - Systems Administration, Java, C++, PHP, MySQL, Perl - Bangalore | | 2008-04-16 13:15:00 | | YAHOO INDIA
We are looking for Engineers with hands-on experience to plan, build, deploy and manage our production environment, automate jobs, monitor and troubleshoot application issuers, and...
For more info on latest job openings and other career related information visit my site http://venky-itjobs.blogspot.com
| | By: IT Jobs and Career | | |
|
| [How to]: Permitir acceso remoto a MySQL | | 2008-04-02 04:02:18 | | Este How To va a ser muy cortito, pero no por eso poco útil; ademas de que es re tarde ya y debo dormir, aunque sea un par de horas
Estaba con ArcanuS experimentando algunas cositas en PHP y derepente surgio la necesidad de interactuar con mi servidor MySQL. El problema es que ArcanuS [...] | | By: Blog de Tinchio | | |
|
|
| Install and Configure FreeRadius with MySQL | | 2008-03-09 06:08:48 | | To complete my previous post about Creating Mikrotik User Manager, now I'd like to share a little information about installing FreeRadius with MySQL and how to configure it. And like the other post i have, i try to make it in the simple and fast way with example screenshot . My sample OS today is Fedora.
Install FreeRadius with MySQL
An easy way to install a new FreeRadius supported to our | | By: Computers & Networking | | |
|
|
| MySQL ya es de Sun en su totalidad | | 2008-03-03 13:08:00 | | Sun Microsystems dijo el Martes que ha completado su adquisición de la compañía de base de datos Open Source MySQL por aproximadamente 1000 millones de dólares; y ahora vuelve su atención hacia otras adquisiciones. "Bajo mi punto de vista es la adquisición más importante en la historia de Sun", dijo el director de Sun, Jonathan Schwartz, en una teleconferencia ayer. Sun pagó aproximadamente 800 millones de dólares en efectivo y 200 millones de dólares en acciones por MySQL. Aunque sea una gran adquisición para la compañía de servidor y software, no será la última, dijo Schwartz. Artículo completo en faq-mac. | | By: Software libre y sus trucos de Free Spirit | | |
|
|
| Importación de datos desde tablas DBase (dbf) a MySQL con Python | | 2008-02-18 16:48:34 | | Hoy pasé un buen rato haciendo un script Python para importar tablas en formato Dbase (Linux) a MySQL (Windows). Una lista de cosas que fui aprendiendo/resolviendo:
MySQLdb: Módulo para hablar con el MySQL
dbfpy: Módulo para acceder a las tablas Dbase
Para evitar importar en el MySQL los registros marcados como borrados (deleted) de las tablas Dbase utilicé [...] | | By: Blog de Marcelo Ramos | | |
|
|
| Migrar de Bases de datos en Access a MySQL | | 2008-02-09 10:34:00 | | Ms Access to MySQL es un programa para Windows que permite convertir bases de datos Access a MySQL y que puede descargarse gratuitamente desde la siguiente página: descarga de Ms Access to MySQL Si lo hemos descargado, instalado y lo intentamos ejecutar y aparece la siguiente ventana, es que tenemos que descargar e instalar el driver ODBC de MySQL desde la siguiente página: driver ODBC de MySQL El programa nos guía a través de un sencillo asistente que nos permitirá pasar bases de datos Access a MySQL. Esta es la primera ventana del asistente, en la que simplemente tendremos que hacer clic sobre el botón “Next”. En el siguiente paso del asistente tendremos que seleccionar la base de datos que queramos convertir. También tendremos que especificar el nombre de usuario y contraseña en caso de que la base de datos se encuentre protegida por contraseña. A continuación especificaremos la ubicación de la base de datos MySQL (localhost si la base de datos la tenemos | | By: Software libre y sus trucos de Free Spirit | | |
|
| Book Review: Learning PHP & MySQL - Step-by-Step Guide to Creating Database-Driven Web Sites by Michele Davis and Jon Phillips | | 2008-02-08 10:22:00 | | A review I wrote for BlogCritics. First I must say that I was really excited to review Learning PHP & MySQL: Step-by-Step Guide to Creating Database-Driven Web Sites. My HTML skills have grown greatly over time and I am able to maintain a few HTML driven websites with a minimum of hassle and effort. I have limited time and little desire to immerse myself in any web development, but have been enamored by PHP and the database driven MySQL and the website functionality they promise. So when I saw the book described by the publisher as "perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books," and "If you ... know your way around HTML, Learning PHP & MySQL is the book you've been looking for," I thought this could be the perfect opportunity to learn something useful and write a review at the same time.But after reading the book, downloading the software, and trying to follow what was presented, I know no more about how to use PHP & MySQL | | By: Pilates & Reiki In Paradise Blog | | |
|
| Introducing CMS with PHP and MySQL | | 2008-02-01 21:14:03 | | Introduction
As a precursor to the PHP and MySQL programming tutorial, it is worth understanding that one of the most powerful uses for PHP and MySQL is as a Content Management System (or CMS). The CMS is the backbone of a good interactive web site, and all the top publishing systems, from Drupal to Wordpress use [...] | | By: computer and internet business | | |
|
| Sun compra MySQL AB | | 2008-01-25 16:51:00 | | Sun Microsystems anunció un acuerdo para adquirir a la empresa sueca MySQL AB, los creadores de la popularísima base de datos abierta del mismo nombre que tiene entre sus usuarios a gigantes como Google, Yahoo!, YouTube y MySpace, por un total de U$S 1000 Millones (U$S 800 en efectivo y U$S 200 en otras opciones). Para darnos una idea de lo que significa ese astronómico número, sólo mencionemos que es aproximadamente 5 veces más de lo que pagó Novell cuando compró SUSE en el 2003. Los 400 empleados de MySQL AB trabajarán ahora para Sun y Marten Mickos, el ex-CEO de MySQL, seguirá a cargo de la base de datos dentro de su nueva empresa. | | By: Software libre y sus trucos de Free Spirit | | |
|
|
| Sun Buying MySQL | | 2008-01-17 21:46:00 | | Sun Microsystems, Inc. has announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world's fastest growing open source databases for approximately $1 billion in total consideration.MySQL's open source database is widely deployed across all major operating systems, hardware vendors, geographies, industries and application types. The complementary product line-ups will extend MySQL's database reach and are expected to bring new m | | By: Beta18>>Technology HotSpot | | |
|
| Sun Microsystems accquires MySQL - expected make billion dollor database market | | 2008-01-17 01:58:13 | | MySQL, the most popular open source database will be soon acquired by Sun Microsystems and brisk up Sun growth strategy in Billion db market.In SANTA CLARA, this week Sun Microsystems, Inc. (NASDAQ:JAVA) declared about its explicit agreement to acquire MySQL AB, open source icon and developers of one of the world’s fastest growing open source database. Acquisition of MySQL by Sun Microsystems will augment Sun’s stand in the global IT market as will include $15 billion database market. Sun is declared to be the largest contributor in the commercial open source market and pioneer web economy platform provider.With SMO i.e. social media optimization, expanding social networks, sprouting new social communities, increasing number of user driven social communities and their integration has really helped web technology to grow rapidly and move ahead from web 2.0 to web 3.0 and now to semantic web and Latent Semantic Analysis (LSI Indexing). With slew of web deployments globally, aficionad | | By: Open source web deisgn development | | |
|
| Sun Microsystems compra MySQL | | 2008-01-16 17:19:00 | | Es la compra del año por parte de Sun Microsystems, en la que han adquirido MySQL AB por la cantidad aproximada de 1 billon de dolares...tal como lo leen, suena bastante dinero...pero asi es, un grande de Silicon compra un grande en el open source. Cosas como esta no se ven a diario.Info | Sun Microsystemshttp://www.text-link-ads.com/xml_blogger.php?inventory_key=JN8NV4HMM54QZOB1YA0P&feed=1 | | By: Punto Tecnológico | | |
|
| Sun juega otra carta: compra MySQL | | 2008-01-16 09:17:25 | | Interesantes lo movimientos que ha realizado Sun en 7 años. Una búsqueda rápida de eventos relacionados a Sun y el open source me dió ésto:
Agosto 1999:
Compra StarOffice a la empresa StarDivision
Julio 2000:
Libera el código de StarOffice 5.2 bajo la licencia LGPL
Octubre 2000:
Crea el proyecto OpenOffice.org para gestionar el código LGPL de StarOffice 5.2
Junio 2005:
Crea [...] | | By: Blog de Marcelo Ramos | | |
|
| Sun Microsystems Announces Agreement to Acquire MySQL | | 2008-01-16 07:55:46 | | Sun Microsystems Announces Agreement to Acquire MySQL, Developer of the World’s Most Popular Open Source Database: “SANTA CLARA, CA January 16, 2008 Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world’s fastest growing open source [...] | | By: Agylen | | |
|
| Sun acquires MySQL AB | | 2008-01-16 07:53:05 | | Exciting news was published today at Jonathan Schwartz' (Chief Executive Officer and President of Sun Microsystems) blog:
We announced big news today - our preliminary results for our fiscal second quarter, and as importantly, that we're acquiring MySQL AB.
…
This puts products like MySQL in an interesting position. They're a part of every web company’s infrastructure, [...] | | By: Linux Screw | | |
|
|
| Windows - Take control of your Apache and MySQL startup with batch file | | 2007-12-02 19:06:00 | | As default, Apache and MySQL are loaded automatically when windows start if you install it on your windows box. Some computer with less memory will have trouble with their start up time caused by many application windows call upon starting up including Apache and MySQL.If you are web designer and your computer not as a web server, you may want to set Apache and MySQL start up by manual (unless your computer are set for a web server), by change it to manual at windows services will increasing windows start up time a little bit, but you will have to start the Apache and MySQL manually every time you want to use it.You can go directly to windows services or can write a command line in a dos prompt for starting Apache and MySQL.dos command:service start apache2 | | By: Computers & Networking | | |
|
| Interview: Marten Mickos, CEO, MySQL | | 2007-12-01 00:13:36 | | "With Microsoft, we meet them in smaller companies and where the competition is happening at the operating system level. If they customer says they 1 Vote(s) | | By: JeQQ it | | |
|
|
|
| MySQL/PHP Database Applications | | 2007-10-27 18:10:28 | | If you are thumbing through these pages, you’re probably considering writing Web-based applications with PHP and MySQL. If you decide to go with these tools, you’ll be in excellent company. Thousands of developers—from total newbies to programmers with years of experience—are turning to PHP and MySQL for their Web-based projects, and for good reason. Both PHP and MySQL are easy to use, fast, free | | By: free e book | | |
|
|
| Memakai Mysql Remote di cPanel baru | | 2007-06-21 08:24:32 | | Bagi anda yang menyewa hosting ataupun mempunyai server di hosting gratis, sekarang cPanel hadir bukan hanya dengan interface
baru yang lebih mudah dipakai dan lebih interaktif, tetapi juga ada fitur baru yang sangat bagus, yaitu Remote MySQL, dimana
kita bisa menambahkan hak akses bagi user dari IP / host luar, yang bukan satu intra network dengan host local yang mempunyai database MySQL tersebut.
Tentunya dengan feature baru ini, anda yang mempunyai host gratis tetapi tidak dilengkapi dengan fasilitas database, dapat berbagi space database dengan
hosting yang memiliki MySQL tersebut.
(more…) | | By: Belajar Tutorial apa itu Adsense, Adbrite, SEO , e | | |
|
|
