Archive for the ‘mysql’ Category

« Older Entries

Convert MySQL to Microsoft SQL

Monday, January 25th, 2010

Convert MySQL to Microsoft SQL software migrates MySQL data into MSSQL database or overwrites the contents of an existing MSSQL database as converting all data types, default value, attributes, null value, key constraints like primary key, unique key etc. Download professional MySQL migrator software which includes features like Unicode support, primary keys and indexes conversion, interactive (GUI) mode, built-in scheduler, renaming of tables, fields and indexes before conversion. Database conversion services offer its user a comprehensive data migrating solution, the highest reliability or scalability to fulfill the requirements of database. Database customization program has features to change data tables and records by selecting appropriate table. Software either writes all SQL commands into a text file or executes these commands directly at a connected MySQL server (i. e. no need for huge temporary files). Migration program is functional with all windows based operating systems such as windows 98, NT, ME, 2000, 2003 server, XP (home, professional, media center edition) and windows Vista(home, enterprise, ultimate, premium, starter, basic, business). Database file convertor software provides Unicode facility which its user to make language special symbols display correctly. Software supports Microsoft SQL Server Express and Microsoft SQL Server 2000/2005.

Migrate MySQL server database to MSSQL software provides easy and best migrating solution to transfer your whole database of MySQL to MSSQL database. MySQL to MSSQL database conversion utility has powerful converter quality that transfer data from MySQL to MSSQL server within seconds. Database migration software can convert one record, selected group record or entire database in one step only. MySQL to MSSQL database converter tool migrate certain tables, rows, column, fields, indexes, constraints values, null values, primary keys, foreign keys, default value, structure, unique keys, attributes, schema etc from MySQL database to MSSQL database. Database converter utility maintains data integrity and support Unicode architecture. Database migration application provides best user friendly graphical user interface (GUI) for end user so that there is no requirement of technical knowledge to install or operate this MySQL to MSSQL database migration tool. MySQL to MSSQL database converter freeware silently use command line parameters to convert database without user interaction.

Tags: , ,
Posted in mysql | No Comments »

Convert Microsoft SQL to MySQL

Sunday, January 24th, 2010

Convert Microsoft SQL to MySQLSoftware migrate MSSQL server db to MySQL dbSaturday, Aug 08, 2009;MSSQL to MySQL database converter software is nondestructive and read only application which converts Db file in one format into other without affecting originality of the attributes. Our company Laptop data recovery offers database conversion facility by converting Microsoft SQL database single or multiple table records into MySQL server. MSSQL to MySQL database conversion software quickly change MSSQL database to MySQL without creating any change to database records and their structures. Software maintains originality of the table attributes. MSSQL to MySQL database conversion program maintains database integrity during conversion. P-dd. co. uk releases new database conversion software to ensure user to convert MSSQL db into MySQL server. Application supports default values, null values, indexes, primary key with all necessary attributes or entities. Database migration software support all versions of MSSQL and MySQL database server and is fully support all Microsoft Windows operating system including 98, 2000, 2003, ME, NT, XP and Vista. Software easily merge converted MSSQL database in to already exist MySQL server or stores in new database destination. Database conversion program gives you a complete security to convert the entire database or selected tables in a well organized manner. The software development team of P-dd. co. uk combines a variety of advance features in this particular software. Some of the important features are:* Software supports all windows operating systems such as windows 98, NT, ME, 2000, 2003 server, XP and windows Vista. * Application converts MSSQL database content in to MySQL server. * Database conversion tool supports all latest versions of MSSQL database server. * You can convert database into new destination database or an existing database. * Application supports default values, null values, unique and primary key with all necessary attributes. * You can convert individual table or group of tables according to your interest. I am a company representative and fully satisfied with this application to convert Microsoft SQL to MySQL server. For more details about this software:Logon the website http://www. p-dd. co. uk orEmail at weblink@p-dd. co. uk

Tags: , ,
Posted in mysql | No Comments »

InnoDB Database Corruption post MySQL Server Crash

Friday, January 22nd, 2010

Improper or unexpected MySQL Sever shutdown is one of the primary reasons for InnoDB database corruption. Two main reasons for improper server shutdown could be power outage and human errors. A major hazard that a database user encounters after InnoDB database corruption is inaccessibility of database records. The user is not left with any choice, but to restore the database records from an updated and complete backup. However, the database backup fails to restore the desired records in case it is corrupted, damaged, or not updated. In such situations, the user need to opt for an advanced mysql database repair application that can repair its corrupt database and restore all the records on its desired location. Below is the error message that pops up when your InnoDB database gets corrupted after MySQL Server crash:?InnoDB: Database page corruption on disk or a failedInnoDB: file read of page 1294396. InnoDB: You may have to recover from a backup. 031030? 5:33:50? InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex 000000000013c03c0000 . . . . . . . . . . . . . . ?After the above error message appears, the data stored in InnoDB database becomes inaccessible. ResolutionTo resolve the above error message and to access the data stored in tables, you will need to follow the below steps:1. Add ?innodb_force_recovery=4? to etc/my. cnf configuration file. 2. Restart MySQL and dump all the tables. 3. Shutdown your database, erase the data directory, and mysql_install_db to create new MySQL tables. 4. Remove ?innodb_force_recovery=4? from etc/my. cnf configuration file. 5. Restart your database and restore everything from a backup. The above command assures systematic repair of database after almost all logical corruption scenarios. However, the resolution fails to resolve the issue when you have not maintained any backup. To repair your database in case of no backup availability, you will need to opt for powerful mysql database recovery application. Such repair applications scan and repair your database to the maximum possible level. These MySQL Repair tools are read-only in nature and perform repair without making any changes in original data. Built with interactive user-interface, these tools provide clear understanding of the repair process. Stellar Phoenix Database Recovery For MySQL is an effective and user-friendly application to repair corrupted MySQL database after most damage scenarios. Supported by both MyISAM and InnoDB MySQL database storage engines, the MySQL Repair utility is designed for Windows 7, Vista, XP, 2003 and 2000 operating systems.

Tags: , , , , , ,
Posted in mysql | No Comments »

Repairing of Mysql data

Thursday, January 21st, 2010

MySQL database is the world?s most popular open source database because of its high reliability, fast performance, simple to use and dramatic cost savings. MySQL is part of a large and growing family of open source software including Linux, Apache, and programming languages PHP and Perl. MySQL is a relational database, which is a collection of tables or items organized into predefined categories or described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

Mysql database is better known for its stability but like as other software?s there may be bugs which could crash the Mysql databases. All of a sudden if your database starts misbehaving then it is possible that you have a database or table corruption. Some of the reasons for Mysql database corruption are:

It is necessary to make regular backup of your data to defend it from loss. If you are moving your data to a new server or if you have removed your old database then you can repair or restore it again. By the use of down listed code line Mysql repair is possible: Mysqldump ?u user_name ?p your_password database_name > Filename. sql

If you are unable to restore mysql databases or repair mysql database then you can easily opt for mysql repair software. There are many mysql repair software?s available in the market that can do the job of mysql repair. You can easily download the free trial version of this software from online and can buy from it also. The software is easy to use and safe to install. Try this mysql repair software and scan your drive to restore and repair mysql lost data.

Tags: , ,
Posted in mysql | No Comments »

‘table_name . frm is locked against change’ MySQL Error and Recovery

Tuesday, January 19th, 2010

Each MySQL table is represented by an . frm file on disk, no matter which storage engine you use. An . frm file describes the table definition and possesses the same name as of table. The corruption of . frm file leads to table inconsistencies. It could happen due to improper locking of table, DLL file errors, system faults, disk issues, virus attack, unexpected shutdown etc. You need to use your recent data backup to restore data in such situations. However, if data backup exists in invalid state, or is not available at all, you need to use MySQL Database Recovery applications that prove to be safe tools for repairing damaged MySQL databases.

You might receive the following error message with MySQL database table(s):

“. frm is locked against change”

Cause

The primary cause for the occurrence of above error message is corruption of . frm file.

Solution

In order to correct such corruption errors, you require following these steps:

CHECK TABLE tablename [options]

If you are using MyISAM, you can alternatively run ‘mysqlcheck’ or ‘myisamchk’ command-line utilities.

REPAIR TABLE tablename [options]

For MyISAM tables, use of ‘mysqlcheck’ or ‘myisamchk’ is also applicable.

Stellar Phoenix Database Recovery For MySQL is a premier utility to repair and restore damaged MySQL tables. The software supports MySQL 5. x. It can recover database files for both InnoDB (. ibdata, . ibd and . frm) and MyISAM (. myd, . myi and . frm) database storage engines. It can restore all database objects, like tables, relations, primary key(s), and others. It can recover databases of Windows and Linux platforms and is compatible with Windows Vista, XP, 2003, and 2000.

Tags: , , , , , ,
Posted in mysql | No Comments »

PHP PDO MySQL:Simple Example Connecting to MySQL with PDO Class

Monday, January 18th, 2010

I’ll demonstrate a simple example on how to connect to mysql using PHP’s PDO class. Just some of the benefits of PDO is that it’s fast and if you use the PDO::prepare() method it will prevent SQL injection attacks by calling the PDO::quote() method. The other pros is that there are several databases it will support. So let’s dive right into the code:$hostname = ‘localhost’;$username = ‘your_username’;$password = ‘your_password’;try { $db = new PDO(“mysql:host=$hostname;dbname=mysql”, $username, $password); echo ‘Connected to database’;}catch(PDOException $e) { echo $e->getMessage();}Fatal Error new PDO InstanceJust an important note that if you receive the following type of fatal error in your development environment:Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42000] [1049] Unknown database ”user”’ in C:Program FilesApache Software FoundationApache2. 2htdocstesttrunkcodelogin1classesstd. pdo_singleton. class. inc:30 Stack trace: #0 C:Program FilesApache Software FoundationApache2. 2htdocstesttrunkcodelogin1classesstd. pdo_singleton. class. inc(30): PDO->__construct(‘mysql:host=loca. . . ‘, ‘username’, ‘password’) #1 C:Program FilesApache Software FoundationApache2. 2htdocstesttrunkcodelogin1classesstd. mysql. class_test. inc(43): db::getConnect() #2 C:Program FilesApache Software FoundationApache2. 2htdocstesttrunkcodelogin1connect. php(6): MySqlDb->confirmUserPass(‘usertest’, ‘passtest’) #3 {main} thrown in C:Program FilesApache Software FoundationApache2. 2htdocstesttrunkcodelogin1classesstd. pdo_singleton. class. inc on line 30Looks pretty messy and hard to decipher. When trying to decipher error code I usually look at the first error which led me to see why it was reporting an “Unknown database” when it was existing. The extra quotes also gave me a hint as to the problem. So I concluded the problem resulted in the placement of extra quotes around the values of host and/or dbname. The following will generate the previous error:$db = new PDO(“mysql:host=’localhost’;dbname=’mysql’”, $username, $password);So if you do not use variables then do not add the single quotes for the values of host and dbname. In other words, use the following code instead:$db = new PDO(“mysql:host=localhost;dbname=mysql”, $username, $password);This is a simple test to connect to your mysql database or any other support database. Just for your information if you wish to connect to PostgreSQL which is another popular and robust database use the following code in place of the line of instantiation:$db = new PDO(“pgsql:dbname=pdo;host=localhost”, “username”, “password” );If you’re in a development environment and wish to display your errors directly to the screen you can specify the errors displayed. You need to set your display_errors settings to ‘on’ in your php. ini file. So set your error attributes after instantiating the PDO class like so:$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);There are three types of error report settings for PDO::ATTR_ERRMODE:PDO::ERRMODE_SILENT = error codesPDO::ERRMODE_WARNING = E_WARNINGPDO::ERRMODE_EXCEPTION = Throw exceptionsHere’s an example of implementing PDO::ATR_ERRMODE:$hostname = ‘localhost’;$username = ‘your_username’;$password = ‘your_password’;try { $db = new PDO(“mysql:host=$hostname;dbname=articles”, $username, $password); echo ‘Connected to database’; // check for connection $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $sql = ‘Select * from tutorialref where id=1′; $result = $db->query($sql); foreach ($result as $row) { echo $row['id'] . ‘ – ‘. $row['author'] . ”; } $db = null; // close the database connection}catch(PDOException $e) { echo $e->getMessage();}Don’t confuse this with the errors generated from the php setting of error_reporting. The errors from PDO::ATTR_ERRMODE apply to the sql query and its results. I’ll dive into the error settings and the different outputs of the php. ini error_reporting settings and PDO::ATTR_ERRMODE report settings in a future article.

Tags: , , , ,
Posted in mysql | No Comments »

Migrate Access DB to MySQL

Saturday, January 16th, 2010

Migrate Access DB to MySQLMS Access to MySQL DB converter applicationThursday, July 16, 2009;Do you really need to convert your database from Access-to-MySQL while building a complex system? Advance database converter provides vast solution to easily migrate very large and complex MS Access database. Advanced MS Access to MySQL DB migrator program converts selected database table created in MS Access to MySQL database format. Database converter application supports all major versions of MS Access database and converts large and complex database or selected records to MySQL database conveniently. Windows compatible database management program offers comprehensive solution to migrate your password protected Microsoft database file (MDB) into MySQL database without infringing database integrity. Advanced DB converter program provides a well-organized set of features that allows you to convert data without any loss of accuracy. Database convertor software transforms Access database tables to MySQL without affecting the functionality of any database application. Automatic database synchronization program supports GUI interface which can be easily handled by non technical users. Database converter utility maintains database integrity and functionality during the database conversion process and supports Unicode architecture and all MS Access data types and attributes. Application is easy to use and capable to convert all important attributes, indexes, default values, selected or individual tables, or entire database records of Microsoft Access database to MySQL server effectively. MS Access to MySQL database migration tool support all major versions of MS Access and MySQL and runs on windows operating system including 98, XP, ME, NT, Vista, 2000, 2003 etc. Some of the advance features are:* Comprehensive DB converter utility facilitates conversion of selected or group of table records as per user choice. * DB convertor software supports all major versions of Microsoft Access and MySQL server. * MS Access to MySQL database migrator tool support all MS Access data types and attributes. * MS Access to MySQL DB transformation program provides full install/uninstall support. I am a company representative and fully satisfied with this application to convert MS Access database records to MySQL database server record format. For more details about this software:Logon the website http://www. data-recovery-usb-drive. com orEmail at usb@ddipr. com

Tags: , ,
Posted in mysql | No Comments »

‘Found key at pagethat points…’ MySQL Error

Friday, January 15th, 2010

Normal 0 false false false MicrosoftInternetExplorer4

MySQL Server organizes its data files as a single unit and their locations are allocated as per database instance. All MySQL instance data files are located in a single file system directory, usually called Data. These data files hold records. But sometimes, MySQL Server reports errors that it has found a key at a page which references a record lying outside the data file. Such kinds of errors generally indicate the specific table is corrupted and needs to be repaired. In critical situations (generally when MySQL repair utility fails to repair the database), you require using your recent database backup to restore. But many times, you don’t have clean database backup that could perform complete restoration. Such situations necessitate the use of MySQL Recovery products as the effective database repair solution.

As an example, you might receive the below error message with your MySQL Server database:

warning: clients are using or haven’t closed the table properly

error    : Found key at pagethat points to record outside datafile

error    : Corrupt

This error is specific to MyISAM database engine and is encountered when you run mysqlcheck -u {USERNAME} {DATABASE} [TABLE] command to check the consistency of the database table. Where, DATABASE and TABLE refers to the name of specific database and table, respectively.

Cause

MyISAM database table is corrupted. The most probable reason for this error to occur is unexpected shutdown. Another possibility is that database is opened at various users’ ends.

Solution

Before making any database repair action, make sure that the database is properly closed at all the ends. You also need to ensure that the server is shut down or in other words, all the tables are inactive. To perform MyISAM database table repair, issue the following command:

mysqlcheck -r -u {USERNAME} {DATABASE} [TABLE]

Next, rerun the mysqlcheck -u {USERNAME} {DATABASE} [TABLE] command to check if table corruption goes away. If the issue persists, restore from backup or make use of MySQL database recovery applications. Built with powerful database repair technology, these MySQL Recovery applications provide effective and safe recovery of damaged MySQL database and its objects.

Stellar Phoenix Database Recovery For MySQL is a comprehensive MySQL Database Recovery utility that provides safe and instant database repair. It supports MySQL Server 4. x and 5. x. It provides complete recovery for InnoDB (. ibdata, . ibd and . frm) and MyISAM (. myd, . myi and . frm) files. It can recover databases created on Windows and Linux platforms. The software is compatible with Windows Vista, XP, 2003 and 2000.

Tags: , , , ,
Posted in mysql | No Comments »

MySQL Database Inaccessible Post MySQLD Crash

Wednesday, January 13th, 2010

MySQLD ? MySQL Server ? is an important program that provides you the access to MySQL data directory that consists of all databases and tables. The default location for MySQLD. exe is saved at ?C: Program Files?. Whenever MySQLD starts, it hears to all network connections from client programs and then manages all the databases on clients behalf. Improper or unexpected shutdown of MySQLD might result in complete or partial corruption of your MySQL database. In such situations, the records saved in your MySQL database become inaccessible. For systematic access of records, a standard way is to restore them from an updated backup. But if in case, the backup is not available or backup falls short to restore the required data, then you will need to search for effective third party mysql database repair application. Consider a practical scenario, where MySQL unexpectedly quits and your database gets corrupt. Unexpected shutdown can occur due to various reasons, like human error, power surge, hardware malfunction, or software bugs. On viewing the log, you view the below information:?101106 0:15:19 – mysqld got exception 0xc0000005 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail?Note: In most cases, your MySQL database becomes unmountable after corruption. ResolutionA comprehensive solution to repair corrupted MySQL database, in case of no backup availability is mysql database recovery application. These MySQL Repair applications are non-destructive in nature and perform repair without making any changes in the original file. Such repair tools are built with interactive user-interface, which makes them easy to understand without any former technical understanding. These tools use high-end scanning procedures to orderly scan and repair MySQL database. Database Recovery For MySQL is an answer to all MySQL database corruption issues. The MySQL Repair utility repairs and restores databases built in MyISAM and InnoDB MySQL database storage engines. The MySQL Repair software is compatible with Windows Vista, XP, 2003 and 2000 operating systems. Its demo version provides a complete preview of the recoverable data.

Tags: , , , , ,
Posted in mysql | No Comments »

Migrate SQL Server to MySQL

Tuesday, January 12th, 2010

Migrate SQL Server to MySQL

Saturday, October 10, 2009

MSSQL to MySQL database conversion software converts bulk database records with existing MSSQL database records into MySQL database records. MSSQL to MySQL database records migration application transfer entire database record with all attributes of database and also maintains data consistency and integrity.

MSSQL to MySQL database transformation utility transform database tables, functions, primary, foreign key constraints. MSSQL to MySQL conversion application facilitates user to convert whole database or required table as per the requirement. MSSQL to MySQL database transformation software converts all table record and schema efficiently with full accuracy. MSSQL to MySQL database migration program is read only and non destructive database migration utility. MSSQL to MySQL database converter application is resourceful solution for all kind of large and small industry. MSSQL to MySQL conversion program facilitates user to export MSSQL database record into new MySQL database or replace into already existing database. MSSQL to MySQL database conversion software provides an effective, quick and convenient database conversion from MSSQL into MySQL. MSSQL to MySQL conversion software converts source database (MSSQL) into destination database (MySQL) and save the converted database at user specified location.

To know more about this software visit at following URL:

http://www. p-dd. us/deleted-files-recovery/mssqltomysql. asp

MSSQL to MySQL database migration software merge entire database, attributes, entities, constraints and selected rows, columns.

MSSQL to MySQL database converter application

MSSQL to MySQL database conversion utility has Graphical User Interface (GUI) so that user does not require any training or technical knowledge to operate this software. MSSQL to MySQL database transformation utility provides preview option to show converted database and provides save option so that user can save converted database at desired location.

Tags: , ,
Posted in mysql | No Comments »

« Older Entries