Posts Tagged mysql

NaggieHow to recover a corrupt MS SQL Sever database

Monday, May 3rd, 2010

MS SQL Server is a relational database management system (RDBMS), which is specifically developed to be used in the enterprise environment. It provides increased productivity, efficiency, availability, and administrative ease to your organization.

It’s the case with most of the applications it too can face some errors that may lead to data corruption. The data corruption cases may arise because of various issues such as power surges, virus infections, human errors, abrupt shutdown when the database is open, etc. In such cases, you should replace the database with an updated backup. And if the backup is not updated and you need the data urgently, then you should use an SQL MDF repair tool that will help you to repair SQL database.

Let’s consider a scenario wherein you have got MS SQL Server installed on your system, and one day when you open the SQL Server database, it fails to open. An error message is displayed.

“Server can’t find the requested database table.”

Once you encounter this error message, you are unable to access the database.

Cause: Here the error is that the SQL database is corrupt and, thus, inaccessible. It may have got corrupt because of various reasons such as virus infections, human errors, power surges, abrupt system shutdown when the database is open, etc.

Resolution: If the SQL database is not a complex one and there isn’t huge amount of data, then you should try and rebuild the database. However, if the database is complex and contains huge amount of data, then you should consider using a third-party sql server repair application for mdf repair. Such tools are read-only in nature and do not overwrite the data while scanning the databases using fast yet sophisticated algorithms. Also, these tools have rich interface and enable you to repair the database yourself without the intervention of an expert.

SQL Recovery software is an MS SQL repair tool that is able to repair SQL databases created in MS SQL Server 2000, 2005, 2008. It can recover all kinds of database components such as tables, defaults, stored procedures, triggers, views and rules.

In addition, it can recover database constraints such as primary key, foreign key, unique key, and check. In addition to all this, it can repair a database even if it is not repairable by the DBCC CHECKDB command. This tool is compatible with Windows 7, Vista, 2003 Server, XP, 2000, and NT.

Tags: , , , , ,
Posted in Expert's Opinions, Purely Technical | No Comments »

NaggieMySQL Profiler Plugin for WordPress

Saturday, March 6th, 2010

WordPress is so flexible that it has not only made it a major hit but also made non-developers to customize it with ease. Most of the Wordpress functions are optimized for acceptable performance, incorrect usage can cause undesirable speed loss.

Code Profiling

A (code) profiler is a performance analysis tool that measures only the frequency and duration of function calls, but there are other specific types of profilers in addition to more comprehensive profilers, capable of gathering extensive performance data.

You may not notice any performance issues unless you use code profiling to assist you. For general PHP profiling, programmers often use xdebug with all sort of PHP applications including wordpress. But, if you’re a wordpress theme developer, usually all you need is a MySQL profiler.

WP MySQL Profiler

This simple plugin will assist both theme and plugin developers in MySQL Profiling. Once installed, MySQL statistics will be available at page footer.

Installation

  • Download WP MySQL Profiler and extract the archive.
  • Rename your wp-db.php file in wp-includes directory to wp-db-backup.php.
  • Upload wp-db.php included in the archive to your wp-includes directory.
  • Upload wpSqlProfiler.php to wp-content/plugins/ directory.
  • Edit your wp-config.php. Find define (‘WPLANG’, ”); and add below:               define(’SAVEQUERIES’, true);
  • Enable “WP MySQL Profiler” plugin from the admin CP.

Usage

You will see MySQL query details at page footer, when you will log in as an admin. Keep an eye on both total queries and time. Each time you add code to your templates, use the profiling information to check if an optimized function or code snippet has been used.

If you notice high total queries or time, examine the queries and check the backtrace (below) to find where the query originated from. And then remove or replace the unoptimized function/code.

The Backtrace

screenshot 031 MySQL Profiler Plugin for WordPress

In the profiler, third column will give you the most important information. It started at themes/default/single.php on line 7 with the function get_header() which called function wp_head(), kubrick_header_display() and finally get_option() in the file functions.php on line 83.

Note that there’s a link “Show Full Trace”. For simplicity, the profiler doesn’t show all the function calls by default. Instead, it tries to determine function calls from plugins and themes. Since you are going to use it when coding plugins and themes, it makes sense to assume that you’re concerned with function calls originating therein.

Final Steps

And if you want to use the same wordpress copy on a live site, make sure to:

  • delete the wp-db.php and rename wp-db-backup.php to wp-db.php. (optional)
  • remove define(‘SAVEQUERIES’, true); from wp-config.php.

Similarly, disable the WP MySQL Profiler plugin.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , ,
Posted in New Product Release, Purely Technical | No Comments »

NaggieNew Release- MySQL 5.1.44 / 5.5.2 Milestone 2

Wednesday, March 3rd, 2010

MySQL is the World’s Most Popular Open Source Database. It is a widely used and fast SQL database server.

MySQL is a client and server implementation, which consists of a server daemon (mysqld) and many different client programs/libraries. It is a type of SQL database management featured in Thelix hosting plans. A database is an organized collection of information that a computer uses to select and display data.

Databases can help organize and enhance your site content. Sites with dynamic pages and/or shopping cart software often need an underlying database structure.

It is to be pronounced as “my ess cue el” (each letter separately) and not “my SEE kwill.” MySQL is an open source RDBMS that relies on SQL for processing the data in the database. MySQL provides APIs for the languages C, C++, Eiffel, Java, Perl, PHP and Python. In addition, OLE DB and ODBC providers exist for MySQL data connection in the Microsoft environment. A MySQL

NET Native Provider, which allows native MySQL to .NET access without the need for OLE DB, is also available. MySQL is most commonly used for Web applications and for embedded applications and has become a popular alternative to proprietary database systems because of its speed and reliability. MySQL can run on UNIX, Windows and Mac OS.

MySQL is a relational database management system, which means it stores data in separate tables rather than putting all the data in one big area. This adds flexibility, as well as speed.

The SQL part of MySQL stands for “Structured Query Language,” which is the most common language used to access databases. The MySQL database server is the most popular open source database in the world. It is extremely fast and easy to customize, due to its architecture.

Extensive reuse of code within the software, along with a minimalist approach to producing features with lots of functionality, gives MySQL unmatched speed, compactness, stability, and ease of deployment.

Their unique separation of the core server from the storage engine makes it possible to run with very strict control, or with ultra fast disk access, whichever is more appropriate for the situation.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , ,
Posted in Microsoft Technology, New Product Release | No Comments »

Suzanne[PHP]Sending MySQL data.

Saturday, February 27th, 2010
<?Php
$db_host = "1.3.3.7"; // mySQL database host
$db_user = "dbplz"; // mySQL database user
$db_password = "rofl"; // mySQL database password
$db_name = "dbplz"; // the name of your mySQL database

//connect to our database.
  mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
// Select the database.
  mysql_select_db($db_name) or die(mysql_error());
//Define the data as $query
$query = "INSERT INTO tablename (row1, row2, row3, row4)
VALUES ('$variable1','$variable2','$variable3','$variable4')";
  mysql_query($query);
  mysql_close();

// it's almost always imperative to strip tags or the data usually doesn't send properly.
$variable = strip_tags($_POST['variable'], '');
//and now send the data
  mysql_query($query);
  mysql_close();
?>

http://www.all1martpro.com

http://www.all1sourcetech.com

Tags: , , , ,
Posted in Editorial, Purely Technical | 1 Comment »

NaggieOpenOffice.org Releases Version 3.2

Saturday, February 13th, 2010

openof11 OpenOffice.org Releases Version 3.2

On Thursday, the organization announced that OpenOffice 3.2 is now available for download.

The latest version of the productivity suite- which is intended to be an open-source alternative to Microsoft Office- boasts faster start-up times, ODF support, proprietary file support, support for postscript-based OpenType fonts, and more.

The release comes after OpenOffice.org hit a milestone of 300 million downloads over the course of its 10-year history, 100 million of which occurred from the organization’s main Web site.

The suite includes basic components like word processor, spreadsheet, presentation, graphics, and formula and database capabilities. Improvements to those components the version 3.2 boasts, including the Calc spreadsheet. The Chart module, meanwhile, received a “usability makeover” and includes new chart types.

Some people are currently locked in to other personal productivity tools – maybe by corporate IT policy, or by tie-in to other legacy software. For everyone else, we want OpenOffice.org to be the 2010 office software of choice, and 3.2 takes us another step towards that goal,” said Florian Effenberger, marketing project lead of OpenOffice.org.

Version 3.2 is available for download on the organization’s Web site.

Tags: , , , , , , , , , , , ,
Posted in Linux Technology, Opensource, Technical News | No Comments »

NaggieOpera Develops Mini Browser for Apple’s iPhone

Saturday, February 13th, 2010

Opera announced to release it’s newly developed version of its Opera Mini web browser for Apple’s iPhone, which will be demonstrated at the Mobile World Conference in Barcelona, Spain.

The cofounder of Opera Software, Jon von Tetzchner said he is “thrilled” to offer the preview and added that the software provides a “fast, feature-rich” experience for iPhone users. Opera on the iPhone brings the company “one step closer” to its mission of “bringing the web to the world”.

Will Apple Approve?

However, the big question is whether Apple will approve Opera as an iPhone application on its App Store. Apple currently only accepts browsers that run on the WebKit engine — the same engine that powers Apple’s Safari browser.

But Apple has gotten into hot water with the Federal Trade Commission over its initial refusal to certify Voice over Internet Protocol applications, Rob Enderle, principal analyst with the Enderle Group, noted. This time around, Apple will be hard-pressed to exclude competitors.

Enderle said, Given Apple is under FTC review for their application approval process, I don’t think they can refuse this application — but they could break it or limit its capability. “For instance, both the ARM processor and the Opera browser support flash on other platforms, but Apple will likely make sure Flash doesn’t work on Opera any better than it does on Safari on the iPhone.”

“Changing defaults will likely be difficult as well,” Enderle added, “so that it is the Safari browser that opens when you click on a link. If Opera gets on the phone, it is likely that [Google's] Chrome will soon follow, and Apple will do whatever it can to make sure that never happens.”

Advanced Features

Currently, Opera Mini 5 in beta boasts quite a few advanced features over Safari, including tabbed browsing so users can view several sites simultaneously and “easily jump from one to another,” the company said. Another feature is Speed Dial, a display of frequently used pages so users can launch a favorite site with just one click, a feature Safari and Chrome offer in desktop versions but not on smartphones. There’s also Opera Link, which synchronizes bookmarks and Speed Dial between the user’s mobile phone and desktop computer, and Download Manager, which manages downloads from the browser.

According to Opera, its browser offers an intuitive, easy-to-user interface, and is much faster than other browsers because it compresses web pages as much as 90 percent before downloading. Other features include adaptive zoom, in-page searching, landscape mode, and kinetic scrolling.

A senior research analyst at IDC, Raman Llamas said, Opera has a great browser and offers a great experience.

Lucky in 2010?

In 2008, von Tetzchner told The New York Times that Opera had started work on an iPhone version of Opera but stopped development because of Apple’s restrictive developer agreements. Apple initially banned all third-party browsers but finally allowed other browsers based on WebKit.

Around this time, von Tetzchner clearly feels he will have more luck with Apple. Indeed, given that Opera is making a big deal about the availability of Opera Mini 5 for iPhone, Opera may have already received Apple’s blessing.

According to Christen Krogh, Opera’s chief development officer, Opera Mini is compatible with every requirement for the App Store. Krogh also said, there aren’t any identical applications on the iPhone, discounting Safari as an identical application. Opera Mini is a different kind of browser, so we cannot see any conflict with any requirements in the App Store.

Krogh said Opera hasn’t yet submitted the application to the App Store. “We’re comfortable enough [with] where Opera Mini is at to show it to select partners and journalists,” he said. “It won’t take long before we’re ready to submit it to the App Store.”

Tags: , , , , , , , , , , ,
Posted in New Product Release, Opensource, Technical News | No Comments »

NaggieOpera Mini: 5 Reasons iPhone Owners Need It

Thursday, February 11th, 2010

For the iPhone, Opera has announced plans to release the Opera Mire mobile Web browser, and plans to show it off during Mobile World Congress next week. The early announcement is meant to generate excitement, therefore pressuring Apple into approving this threat to its native Safari browser.

Anyway, not a big deal see the Opera Mini simulator, or check out these five reasons Opera Mini could become your favorite iPhone Web browser, if Apple approves it:

Super Speed

According to claim made by Opera, its mobile Web browser can cut the iPhone’s Web data traffic by 90 percent, thanks to a method of compressing images and text on its own servers. This would, of course, improve the loading time of Web pages as well.

Home Page

Forget loading up a new browser window with nothing in it. Opera Mini’s “Speed Dial” features lets you customize a grid of nine favorite Web sites for quick loading without visiting your list of bookmarks.

Find in Page

The searching inability within a Web page for text is Safari’s most glaring omission. In Opera Mini, it’s as simple as clicking the Tools icon, then clicking “Find in Page” and typing whatever you’re looking for. Sorry Apple, sometimes Web pages just need to be searched.

Greater Flexibility

Here are some other things you can’t do in Safari, all of which can be controlled or enabled in Opera Mini’s settings menu: Saved passwords, adjustable image quality, full screen browsing, adjustable font sizes and customizable skins.

Free, Presumably

Experts of iPhone might point out that there are already plenty of other browsers to choose from, but the vast majority of them cost money. Opera Mini is a free download for other phones, so I assume it’ll be free if Apple approves it for the iPhone. That alone could make it the most attractive Safari alternative yet.

Tags: , , , , , , , ,
Posted in Expert's Opinions, Technical News | No Comments »

NaggieSEO friendly- Let your Website to go high

Thursday, February 4th, 2010

website optimisation SEO friendly  Let your Website to go high

Search engine optimization (SEO) is the process of improving the volume or quality of traffic to a web site from search engines via “natural” or un-paid search results as opposed to search engine marketing (SEM) which deals with paid inclusion. Typically, the earlier (or higher) a site appears in the search results list, the more visitors it will receive from the search engine. SEO may target different kinds of search, including image search, local search, video search and industry-specific vertical search engines. This gives a web site web presence.

Some of the most basic aspects of search engine optimization include:

• Finding words and phrases that Internet users are looking for. Target the wrong keywords and your efforts will be in vain.
• Placing these important words and phrases in prominent places on each page, for example page title, headings, links
• Writing efficient HTML code that search engines can easily sift through
• Providing great content that other websites will want to link to

All1Sourcetechnologies provide proven search engine optimization results using only ethical techniques. Our search engine marketing ensures a high return on investment by achieving maximum visibility for your website within major search engines including Google, MSN & Yahoo! Search.

Tags: , , , , , , , , , , ,
Posted in Company Activity, New Product, Opensource | No Comments »

NaggieGoogle launches Chinese holiday travel map amid row

Wednesday, February 3rd, 2010

A map search service has been launched by Google in China for travelers taking trips during the Lunar New Year holiday season, despite a row over cyber attacks and censorship.

According to a spokeswoman for Google China, Marsha Wang, the service is available online now. The Google Spring Festival Map is based on the company’s regular map service but has “more features” targeting users’ special needs during this month’s holiday, the busiest travel period of the year in China, she said.

The statement posted on googlechinablog.com said, the special map provides information including real-time flight status, train schedules and ticket prices, highway conditions and weather updates.

The government estimates says that about 240 million people are expected to crowd China’s trains and planes for the holiday.

Chinese traditionally return to their home towns and villages for family reunions with this year’s travel period stretching from January 30 to March 10. The Lunar New Year falls on February 14.

Last month, Google threatened to abandon its Chinese-language search engine google.cn, and perhaps end all operations in the country, following hack attacks it says targeted the email accounts of Chinese human rights activists. It has also said it is no longer willing to bow to Beijing’s army of Internet censors — and will stop filtering search results soon, a move China says would violate its laws.

The US and Chinese officials have discussed the issue at length, with US Secretary of State Hillary Clinton qualifying her latest talks with Chinese Foreign Minister Yang Jiechi as “open and candid.” But the row is one of an ever-increasing list of issues threatening relations between the United States and China.

Google chief executive Eric Schmidt reiterated last week at the World Economic Forum in Davos that the Internet giant wanted to stay in China, but also said he hoped censorship rules would change.

According to Wang, it was “business as usual” at Google China’s headquarters in Beijing.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , , , , , ,
Posted in Expert's Opinions, Technical News | No Comments »

NaggieChina Tablet PC Maker May Sue Apple Over IPad Design

Monday, February 1st, 2010

ipad touch cover China Tablet PC Maker May Sue Apple Over IPad Design

A Chinese company, selling a tablet PC like Apple’s newly announced iPad, may sue the US Company over the similar design between the devices, said the company Monday.

Last Year, Shenzhen Great Loong Brother Industrial started selling its P88 tablet and is not ruling out a lawsuit against Apple, a company representative surnamed Wu said by phone.

The company is based in a southern Chinese city known for producing knock-off phones, which are called “shanzhai,” or “bandit” phones, and sometimes takes the form of counterfeit iPhones or other popular handsets.

According to Wu, we are not shanzhai for these things, because we were first.

The P88 weighs more than the iPad and has much shorter battery life at just over one hour during active use, compared to Apple’s stated battery life of 10 hours for the iPad. But both devices use touchscreens that have a black border and a similar size, at 10.2 inches for the P88 and 9.7 inches for the iPad. Wu said his company’s tablet is sold in the U.S., but declined to say at which outlets.

No immediate comment was returned from an Apple’s spokeswoman.

China’s gray market for electronic devices also reacted quickly to Apple’s announcement of the iPad last week. Some users on Taobao.com, a Chinese auction and retail site, are taking pre-orders for iPads they will first obtain in Hong Kong or elsewhere. Popular devices such as the iPhone or the Hero from Taiwan’s High Tech Computer (HTC) are often brought into China informally and sold there online or at electronics bazaars.

Apple has not yet cleared that if the iPad will be sold in China. Local carrier China Unicom started selling the iPhone last year, but gray-market versions of the device were already widely sold in China.

And according to Japanese electronics company Fujitsu, it owns the rights to the name “iPad,” raising another possible legal challenge for the Apple device.

http://www.all1martpro.com

http://www.all1sourcetech.com

Tags: , , , , , , , , , , , , ,
Posted in Technical News | No Comments »