Results 1 to 4 of 4

Thread: How to convert .db file to MySQL database

  1. #1
    Join Date
    Aug 2009
    Posts
    51

    How to convert .db file to MySQL database

    I am having a file which is of extension .db. I want to convert it to MySQL database. Can you tell me how to convert .db file to MySQL database? How can I see this database file: using any database tool or viewer?

  2. #2
    Join Date
    May 2008
    Posts
    685

    Re: How to convert .db file to MySQL database

    PHP Code:
    <?php

    function convertDB($delimeter '\t'$filename$db['hostname'], $db['username'], $db['password'], $db['database'], $db['table'] )
    {

        
    $cid mysql_connect$db['hostname'], $db['username'], $db['password'] ) or die('MySQL connection failes' );
        
    mysql_select_db$db['database'], $cid ) or die('Unable to find database' );

        
    ini_set('MAX_EXECUTION_TIME'900); 

        
    $file file($filename);

        foreach (
    $file as $line)
        {
            
    $array explode($delemeter$line);
            
    $count count($array);

            for (
    $x=0$x<$count$x++)
            {

                
    $array[$x] = trim(addslashes(str_replace'|'''$array[$x] ) ) ); 

                if( ( 
    $x+)!= $count )
                {
                    
    $comma ',';
                }

                
    $values "'".$array[$x]."'".$comma;

            }

            
    $result mysql_queryinsert into ' . $db['table'] . ' values ' . $values . ' );, $cid);
        }
    }
    ?>
    The above PHP code should convert your .db file to MySQL database.

  3. #3
    Join Date
    May 2008
    Posts
    2,297

    Re: How to convert .db file to MySQL database

    MSSQL to MySQL Database Converter 2.0.1.5 is the best utility for you. MSSQL to MySQL Database Converter is an automated database migration solution capable of converting bulk database records of MSSQL into MySQL database records. MSSQL migration program checks data comparison before conversion process that migrate data attributes structures of tables. Data base converter also concentrates on other properties like (Primary/Foreign keys, indexes, null values, constraints, range, domains) during conversion from MSSQL to MySQL record format.

  4. #4
    Join Date
    May 2008
    Posts
    2,012

    Re: How to convert .db file to MySQL database

    Use MS Access DB to MySQL Conversion tool 2.0.1.5 to convert MS Access database tables into MySQL database server. MS Access database converter software provides facility to migrate Microsoft Access database file into most popular MySQL database server format. MS Access to MySQL database synchronization software is an advanced tool to convert password protected MS Access MDB files into MySQL file formats. MS Access database conversion program safely merge converted MS Access database records with existing MySQL database without any data loss. MS Access to MySQL database converter accurately transforms password protected Access db file with all necessary property including null value, default value etc.

Similar Threads

  1. How to connect PHP to mySQL Database
    By Nathen in forum Tips & Tweaks
    Replies: 2
    Last Post: 17-07-2011, 03:49 AM
  2. MySQL database log file maintenance
    By little-Jacqueline in forum Software Development
    Replies: 4
    Last Post: 27-02-2010, 04:12 AM
  3. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  4. Restoring MySQL database
    By Sean J in forum Software Development
    Replies: 5
    Last Post: 18-02-2009, 01:46 PM
  5. convert filemaker pro database to access database
    By Czack in forum MS Office Support
    Replies: 3
    Last Post: 15-04-2007, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,709,021,162.06021 seconds with 17 queries