Howto and tips :converting from #mysql to #firebirdsql Part 2

In the first part i have showed you a method using csv files but there is
a smarter way to migrate from mysql or mssql , get the column info :name,type,pks http://www.php.net/manual/en/function.mysql-fetch-field.php
after that for each table we can create the table in firebird
1. get tables,get tables columns , types relations from mysql , or mssql (for that i will do an article later)
2. for each table, column create new tables with columns in firebird
3. for each row in each table select from mysql,mssql and insert in corresponding table in firebird
in a similar way we did in previous example but there i have inserted from csv
http://gist.github.com/589903
for mssql i will write another script for info , there is one sp that gives you just that
and we can use one query to get it

Here is the first sub step get all the columns info for one table

Howto and tips :converting from #mysql to #firebirdsql

here are some basic types to be converted from mysql to firebirdsql when you run the create table scripts

• int(10)->int
• smallint(5)->int
• datetime->timestamp
• replace the ` with double quote " or with nothing

dump the database with full inserts and then run it with flamerobin
mysqldump  -u root --password=mysql_password -t -c dbname tablename > /tmp/foo.sql

another option is to put dump table in csv format and import it using a php script
that fetches each row and inserts it into firebird table
here is one example for a table with 3 columns



or search for a tool that will do that for you

Tailrank Architecture - Learn How to Track Memes Across the Entire Blogosphere | High Scalability

We use MySQL with InnoDB. We're mostly happy with it though it seems I end upspending about 20% of my time fixing MySQL bugs and limitations.Of course nothing is perfect. MySQL for example was really designed to be usedon single core systems.

Tailrank Architecture - Learn How to Track Memes Across the Entire Blogosphere | High Scalability

Blogged with Flock

Useful Cacti Templates to Monitor Your Servers :: Homo-Adminus Blog by Alexey Kovyrin

I saw there are are many other forks for the
apache template …
I will check them too

Useful Cacti Templates to Monitor Your Servers :: Homo-Adminus Blog by Alexey Kovyrin

Blogged with Flock

installing typo3 - 4.0.x with ftp
In order to set up a new site, you will need to combine both, the source AND the dummy package by extracting them to the same folder.)

download the dummy with source zip
unzip typo3_src+dummy-4.1.5.zip

Run these commands as root in the dummy directory:

# chmod -R g+w,o-rwx fileadmin typo3conf typo3temp uploads


upload files with ftp (ftp in my case)

7 In your browser, visit
http://[your.site.name]/cms/

8 Follow the instructions in the 1-2-3 install tool

9 From this point, you can access the backend through
http://[your.site.name]/cms/typo3/
with the username "admin" and password "password".




typo3.org: Packages

technorati tags:typo3, mysql, php, unix, ubuntu

Blogged with Flock