MySQL

High Concurrency MySQL

by

Domas Mituzas (Facebook) speaks at the 2010 O’Reilly MySQL User Conference & Expo. Slides – assets.en.oreilly.com From the official conference description at en.oreilly.com War and peace stories from Facebook how to detect, analyze and fix problems below, inside and above overloaded MySQL servers. This covers concurrecy problems that appear in real world environments, beyond labs … Read more

How to set MySQL date from a result set to a PHP datetime object?

by

i am trying to set the date and time (DateTime stored in mysql database) to a php DateTime object, one way is to override the class some how to make that happen, but is there any easier way than that?e. g. $date = new DateTime();$date->setDate($mysql_resultset[‘date_time’]);and then format that date according and display it.

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

by

ISBN13: 9780321525994 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product Description It hasn’t taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there’s no limit to the powerful, interactive … Read more

NetBeans IDE 6.7 Conexión y consulta de BBDD MySql (Java EE 6)

by

Veamos como preparar NetBeans para que detecte nuestro SGBD MySQL donde tenemos las tablas con las que vamos a trabajar en nuestraa aplicación distribuida Java EE 6. En otros videotutoriales veremos como recuperar información desde esas tablas mediante técnicas avanzadas de mapeo Objeto-Relacional aprovechando las ayudas incluidas en el IDE. La idea es ir construyendo … Read more

Flash PHP MySQL CMS – Content Management System Website Tutorial CS3 + CS4

by

Source Files – www.developphp.com In this Flash ActionScript 3.0, PHP, and MySQL tutorial video and source file download you can learn how to build slick CMS(Content Management Systems) for your client websites or for projects that require many people to input data. A Content Management System made in Flash makes editing content easier visually and … Read more

What is the command-line code to load a SQL script in notepad to Oracle 10g express?

by

Question: I made a script using notepad but what is the command line code to load it into Oracle express 10g? In MySQL it is just source C: or where ever I have it located. Answer: Follow these steps: Save your notepad file with . sql extension. c:\filename.sql Run it in the command prompt c:>sqlplus … Read more

Performance Tuning Best Practices for MySQL

by

Google TechTalks April 28, 2006 Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his … Read more

Table Corruption in MySQL Database

by

A Request Tracker (RT) enables you to keep a record of all the operations performed in MySQL database. RT creates a session by using a MySQL database, a PERL (Practical Extraction and Report Language) based main engine and front-end web and mail interfaces. However, if RT is unable to store your transactions made into the MySQL component, chances are that your MySQL component is either corrupt or missing. Corruption of MySQL database component can occur due to MySQL database server malfunctioning, operating system failure, malicious software like virus and more. In such situations, you need to recover the MySQL database component by restoring it from the latest backup. But, if you have not maintained any backup or backup falls short of providing the required data, then you should repair your corrupted MySQL component to extract data from it. To do so, you need to use advanced MySQL Database Repair application.

Consider a practical scenario where you encounter the below error message when you attempt to save some changes in session_data table:

“RT couldn’t store your session. This may mean that that the directory ‘/extra/requesttracker/current/var/session_data’ isn’t writable or a database table is missing or corrupt.”

Cause:

The root cause behind occurrence of above error message is that the session_data table is either missing or corrupt.

Read more

Sams Teach Yourself PHP and MySQL: Video Learning Starter Kit

by

ISBN13: 9780672330278 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product Description Sams Teach Yourself PHP and MySQL Video Learning brings the successful Teach Yourself book series from Sams Publishing to life on video — with the same clear and concise style, practical hands-on examples, and self-paced learning approach that have made the … Read more

Building E-Commerce Web Sites with PHP and MySQL

by

Product Description Building E-Commerce Web Sites with PHP and MySQL walks a reader through setting up an e-commerce Web site. Everything is covered icluding:  designing the visual interface, creating the database, generating an online catalog, managing the shopping cart, handling the order and the payment process, and fulfilling the order. Because of the nature of … Read more

MySQL official emphasizes GPL, improvements

by

MySQL official emphasizes GPL, improvements MySQL, the open source database now property of Oracle, has stayed the same in such aspects as its availability under the GPL, but some traits will change under its new management. For example, Oracle will be more tight-lipped about product plans, a MySQL official said Thursday. Read more on InfoWorld … Read more

Head First PHP & MySQL

by

ISBN13: 9780596006303 Condition: USED – VERY GOOD Notes: Product Description If you’re ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you … Read more

PHP and MySQL Web Development

by

Product DescriptionPHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.   PHP … Read more