Tech-Seeker

MySQL is one of the most popular open-source database in the world. The reasons its popularity is its availability, performance, robust transactional support, etc. It offers three types of database engines, MyISAM, InnoDB, and MySQL Archive wherein the MyISAM table is the default table type that is fast, simple to use, and allows full-text searching. Though the MyISAM table is reliable, it can become corrupt and, thus, inaccessible following a system crash. In such cases, you should use the Repair Table command to recover MySQL table. However, if the you are still not able to repair MySQL database then you should opt for a third-party MySQL database recovery software to do the needful.

Consider a scenario wherein you are have MySQL 5.0 installed on your system. You run the myisamchk command to check a table and an error message is displayed, that is:

]]>

“clients are using or haven’t closed the table properly.”

Cause:

The root cause for the aforementioned error message is that the MyISAM index file has not been closed properly. There could be the following reasons for this:

A table was modified by the myisamchk command while it was in use by mysqld.

MySQL crashed while an update was being written on the table.

Multiple mysqld servers are using the table simultaneously that may result in data integrity and, hence, data corruption.

A MyISAM table has been copied without using the Lock Tables and Flush Tables command.

Resolution:

To resolve this issue, you should use the following methods:

Repair the corrupted table by using the Repair Table command, if mysqld is running.

Repair the corrupted table by using the myisamchk command, if mysqld is not running.

The aforementioned methods should be able to perform MySQL recovery. However, if you still are not able to recover MySQL database then you should consider using a third-party MySQL database repair software. Such tools are read-only in nature that do not overwrite the original database using fast yet sophisticated scanning algorithms.

Stellar Phoenix Database Recovery for MySQL is a MySQL recovery software that enables you to repair MySQL database. It is able to recover MySQL database for the MyISAM and InnoDB MySQL database storage engines. This MySQL repair tool supports MySQL recovery of MyISAM (.myd, .myi, .frm) and InnoDB (.ibdata, .ibd, .frm) files. It is compatible with Windows 7, Vista, Server 2003, XP, and Server 2000. It is supported by MySQL 4.x and 5.x versions.

Manya Gupta is a database recovery expert and doing research on database recovery and MySQL database recovery .
Article Source

How to setup wordpress and mysql in your host site??? Well after successfully setting up my first wordpress and mysql blog site hosted for free and free from advertisements yes you’ve heard it right this is the word you love to hear “free” and just spit out the word and people tend to go crazyJ . Anyways moving forward I have decided to share the procedure on how to setup wordpress and mysql on a free hosting site.

Of course first on list you would like to search for a free hosting site and I suggest to choose one with positive review. Sites with applauding feedback can definitely support you fairly enough because if not you will just end up wasting your time setting up your wordpress and mysql site and with a wink of an eye and because it is free host can suddenly remove you or band your site from their of free hosted sites. One thing that you also have to consider is how fast is their support if ever you need to inquire or ask for assistance, do they have ticket system for this??? You can also check this out to the feedbacks and reviews available for them in the net. Now you are ready to surf WWW for your free hosting site. By the way I am using 000webhost.com which also the subject of our so to speak tutorial on how to setup wordpress and mysql for those first timer and ei you can also check noadz.com.  For the purpose of this tutorial article I would like to suggest that we use 000webhost.com then maybe you can move to other site of your choice the principle here is that we grasp the basic at leastJ. Some procedures will be required you to do like of course signing up to them then activating your account. After activating your account you will be thru email some access information that you will be using to go around your site and of these is your FTP folder access we will touch this as we go to this article.
Next step  in the setup wordpress and mysql procedures. We have to setup our Mysql database. This is going to be a bit techi but please bear with me. You then now need to sign in to their site as Member for you to be able access the feature available for you.  Look for CPANEL go ahead and click it and this will prompt you a web page where you can see lot of stuff among these stuff we only need Mysql select it and you will ask to supply the database name you desired, username and password that you’re going to use to access your database. Now go ahead and save your work after saving you will be provided of the details you just have supplied I suggest that you save it we will use this to configure our wordpress php later on…[setup wordpress and mysql]
We have now accomplished two of the major step on how to setup wordpress and mysql. Now it’s time to download your wordpress. Guys don’t be confused with wordpress.com and wordpress.org the story behind that? Hmmm… okay it is just easy as this .com is limited and cannot support your theme of choice and for those who want to monetize their site it doesn’t allow adsense unless otherwise you go out and change the world hehehe and no setting up required and thus the purpose of our setup wordpress and mysql title while on the other side .org is pretty much the opposite of .com got it?! goodJ. Now google “download wordpress.org” so we can continue with tutorial on how to setup wordpress and mysql database.
I assume that you’re done with wordpress.org downloading. Let’s us move forward with our setup wordpress and mysql tutorial. Now we will be needing the database information we saved in step 2. Open your wordpress folder and look for “wp-config.php” and try to locate these “define(‘DB_NAME’,’[$mysql_database ]‘), define(‘DB_USER’, ‘[$mysql_user]‘), define(‘DB_PASSWORD’, ‘[$mysql_password]‘), define(‘DB_HOST’, ‘[$mysql_host]‘)”. You just refer to your copy and substitute value removing the [] square braces. Now save your wp-config.php file and we are ready to upload your wordpress.org to our hosting site.
Before we continue there is still one thing that we should be downloading it’s the Filezilla this is an uploading application which is again free and available in the WWW for your utilization so go ahead get it. After downloading, open your Filezilla also your email from 000webhost stating your FTP access information. Try to supply your Host, Username and Password and hit Quickconnect button. If successful you should be seeing public-html folder to the right pane of Filezilla try to open it and delete the index.php file now without closing Filezilla open your wordpress folder select everything inside it and the drag it into the public-html folder. The process of copying files from your local drive to your hosting site may take time base on experience. To setup wordpress and mysql is a bit tedious but you’ll see this will pay off later on.
After uploading what’s next to our setup wordpress and mysql? Yes we install wordpress. For us to able to install it we need to access it from your hosting site. To access it type http://[your domain name]/wp-admin/install.php you will prompted for some details where you need to supply details included are the usename and password for you to be able to access you WordPress Content Management System. Fill up these fields save your work after saving open http://[your domain name].com/wp-admin supply your WordPress username and password and whoala! We are done doing setup wordpress and mysql.

Guys, I hope you find this article interesting should you be having some problems your inquiries are very much welcome! I am planning to also post another article regarding the basic plugin of WordPress the .org one  promise this will be a more detailed one compared to my previous posted blog about plugin. That’s it for now for my setup wordpress and mysql database tutorial.

Thinking outside of my comfort  zone. Sharing my thoughts, experiences and others… – the AuthorNorwil R. Dulayhttp://dulayako.herobo.com/
Article Source

MySQL is the world’s most popular Open Source database solution. MySQL simplifies the organization, storage and retrieval of information from a database. The better part of the most widely used open source solutions like WordPress, Drupal and Joomla each require a MySQL database backend. Why? They each use MySQL to store all of your websites’ blog posts, articles, pages, visitor comments etc. It also ensures that requests for the stored information can be made in a timely manner.

PHP is an open source scripting language that when used with MySQL creates dynamic web pages, or ones that alters based upon the site visitor. PHP scripts are used to select, import, edit and delete information within your MySQL database.

]]>

Do you want to host a dynamic website? Does managing a MySQL database sound complex? It doesn’t need to be thanks to the cPanel control panel. If you’re in the market for Mysql hosting, make sure to choose one that offers cPanel. cPanel is a user-friendly control panel that simplifies the process of hosting a website. Some of the tools found in this control panel include those that help you manage your domains, files and your MySQL databases.

cPanel resources for managing your MySQL databases include:

*MySQL Database Wizard: Walks you through the processes of setting up user privileges for your MySQL databases.

*phpMyAdmin: phpMyAdmin is the ultimate tool for managing your MySQL databases. Create, modify, search and delete your MySQL tables and fields thanks to phpMyAdmin.

*Remote MySQL: Permits external web servers entry to your MySQL databases.

Want to really simplify your administration of your MySQL databases? Search for a cPanel hosting company that offers Softaculous. Softaculous is a program that you use to install programs like Drupal, WordPress and Joomla with one click of your mouse. That way you don’t even have to concern yourself with MySQL at all.
Brad Litwin is the marketing manager for A2 Hosting. A2 Hosting has been industry leading experts for Linux Hosting since they opened in 2003. Each of their affordable web hosting, reseller hosting and dedicated hosting plans include cPanel and developer friendly support for MySQL Hosting.
Article Source

SQL Server is a Microsoft product used to manage and store information. It uses tables to contain large sets of records for the database. Do you have a SQL server and have you ever used SQL server? Do you know how to create a SQL Server password to protect your data stored on SQL server? What to do if you forget your SQL password? Following it will introduce you how to create a SQL password. And it also tells you how to remove SQL Server password if you forget as password can be easily lost.

How to create a SQL Server password?

As we know, it is an important security measure to set a password for user accounts and in particular the SA account. And it is very easy for you to create a SQL Server password. Just follow the simple instructions.

1. Open the Microsoft SQL Server Management Studio program from the Start menu bar in Windows.
2. Click on the SQL Server instance on which the new user will be created.
3. Right-click the Security folder, point to New, and then click Login.
4. On the General page, enter a name for the new login in the Login name box.
5. Select SQL Server Authentication and enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Click the OK to complete the creation of the new user.

Sometimes it happens that you ignore or forget the system administrator password. What will you do if you forget SQL password and cannot access to SQL database? The effective way I know is to remove SQL Server password with the help of SQL Server password remover software. MS SQL Server Password Unlocker is one of the good MS SQL password remover tools which can help you remove SQL password in a few seconds.

How to remove SQL password with Windows Password Unlocker?

MS SQL Server Password Unlocker is handy SQL Server password remover software for you to reset SQL password including reset SA password and other user passwords. It can easily remove SQL Server password for Microsoft SQL Server 2000/2005/2008 in a minute. You don’t need to install MS SQL Server on your PC, and the file in master.mdf format is enough for you to remove SQL Server password and set a new one for it.

Step 1. Download and install MS SQL Server Password Unlocker, and run the application.
Step 2. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.

This SQL account password has been reset. You can login with the newly set SQL password. Although it is easy for you to remove SQL Server password with SQL password remover, it is better to keep your SQL password in heart. Or you can also write it down on a paper and keep in a safe place.

This article introduces a step-by-step guide to create a password for SQL server. It also tells you how to easily remove sql server password with SQL password remover if you forget your SQL Server password.
Article Source

Buy Microsoft SQL Server 2008 low price

SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.

What’s new in  Microsoft SQL Server 2008?

Hot Add CPU support. Hot Add CPU support lets SQL Server 2008 recognize and use any new processors added to the system without needing to reboot the server or stop and start the SQL Server service. Support for Hot Add CPU augments SQL Server’s existing Hot Add RAM support, well-equipping SQL Server 2008 to be installed in virtual environments and take part in dynamic workload management.

Resource Governor. Possibly the most important new feature in SQL Server 2008 is the Resource Governor, that lets you control the amount of system resources that SQL Server will allocate to a given workload. For example, the Resource Governor lets you limit the system resources consumed by poorly designed end-user queries that could otherwise adversely impact the system’s overall performance. The Resource Governor can also provide more predictable execution for queries and jobs running on the system.tail

Data compression. The new data compression capability is completely transparent to client applications and requires no application changes to use compression. SQL Server 2008′s data compression can reduce the size of database data stored on disk and can also significantly decrease backup and restore times by reducing the required I/O.

Transparent data encryption (TDE). TDE extends SQL Server 2005′s encryption capabilities. SQL Server 2005 encrypts data at the cell level using encryption functions. However, managing the encryption keys is a manual process, and applications require code changes to access encrypted data. SQL Server 2008′s TDE lets you encrypt an entire database and have the encryption be completely transparent to end-user applications.

Policy-Based Management. Policy-Based Management lets a database administrator enforce corporate standards such as database-configuration settings and object-naming conventions across multiple servers.

Change data capture (CDC). For organizations needing to populate data warehouses or other external databases from SQL Server, the new CDC feature alone might be worth the upgrade. CDC does away with the need to write custom code to capture changes. Instead, changes to tables are automatically captured from the transaction log and propagated to a set of target capture tables. CDC can also enhance auditing by capturing all the data changes to target tables.

IntelliSense, debugging, and code-outlining support. In sql server 2000 query analyzer and in SQL Server 2005 you dreamed about IntelliSense auto-completion and the ability to comfortably debug T-SQL code. SQL Server 2008′s new IntelliSense support—in SQL Server Management Studio’s (SSMS’s) Query Editor—provides T-SQL syntax checking and automatic prompting for database object names.

Yes. Sql server management studio 2008 looks very similar to 2005. Auto-complete feature does not start hinting right after you open query editor. It requires some time to gather metadata information. Every syntax error is marked red color.
However, these new features are limited to SQL Server 2008 instances. If you connect Query Editor to a SQL Server 2005 database, you won’t get IntelliSense, debugging, or code outlining. In addition, these features are also not present in SSMS Basic, which is used to manage SQL Server 2008 Express and SQL Server 2008 Express with Advanced Services.

New data types. Unlike the DATETIME data type in earlier SQL Server versions, which required you to combine date and time data in one column, SQL Server 2008′s new DATE and TIME data types let you store data and time values discretely and there are other new date and time data types that enable more accurate storage of data and time data. A new FILESTREAM data type allows high-speed access to large objects (LOBs). SQL Server 2008 also provides new spatial data types that you can use to build mapping applications.

T-SQL enhancements. As you’d expect from a new SQL Server release, SQL Server 2008 includes a collection of T-SQL enhancements. The DECLARE statement now lets you assign values to a variable. New compound-assignment operators (+=, -=, /=, %=, &=, |=, and ^=) let you more efficiently perform mathematical, XOR, XAND, and string-concatenation operations. A new row-constructor feature lets you use a single INSERT statement to insert multiple rows. A new MERGE statement lets you perform INSERT, UPDATE, and DELETE functions in one statement.

Another new T-SQL feature, table-valued parameters, lets you pass a table as a parameter to a stored procedure or function (In sql server 2005 cursor could be used as only output parameter). Table-valued parameters are useful in situations where you need to pass large numbers of parameters to a stored procedure or function. In addition, a new GROUPING SETS feature gives you more control over the output and aggregations used in SQL Server queries.

BI enhancements. Although the business intelligence (BI) enhancements in SQL Server 2008 aren’t quite as notable as those in SQL Server 2005, the SQL Server 2008 BI subsystems—SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS)—have experienced some important enhancements. SSIS features a new Data Profiling task that lets you analyze data passed through an SSIS package. The Data Profiling task can also output data for later viewing with the Data Profile Viewer. A new Cache Transform lets you cache lookup operations for improved package performance. In addition, the SSIS Script Task is now a Visual Studio Tools for Applications (VSTA) implementation with full support for Microsoft .NET Framework references.

SSAS has fixed Cube and Dimension Wizards that make the design process faster and more intuitive. Microsoft has enhanced the Dimension Designer by enabling it to define attributes’ relationships and adding a new visual designer. There are also improvements to the backup and restore process for SSAS databases.

One of the most important enhancements to SSRS is that it no longer requires you to install Microsoft IIS as a prerequisite. In addition, the Report Designer has had a major facelift. There’s also a new report format called Tablix that combines the attributes of table and matrix-style reports.

Another feature that can help end users access information in SQL Server 2008 is the ability to author reports in Microsoft Excel and Word. Microsoft has licensed SoftArtisans’ OfficeWriter, which integrates Excel and Word with SQL Server and SSAS databases.

Discount software Microsoft SQL Server 2008

Article Source