database

I am seeking advice about what might be the best database program to use to create a large pre-MySQL database, from which I will select the content to export/import/enter into a Drupal MySQL database.

I am developing my first Drupal site -- a web portal where information will be organized by relevance to various generations. The site will launch with a Baby Boomer orientation, with information organized for various baby boomer niches, and then expand to serve more generational niches.

Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things, one that may be of interest to Drupal Users is the ability to connect to your Drupal database and write MySQL queries to get reports that can be displayed, downloaded, and shared with other users.

All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:

Select

The classical mysqldump is not enough to backup a drupal website.

With Snapshot, you can freeze your website and make a clean snapshot, mysql data and files. Different backup type can be done, simple copy, rsync and even rdiff-backup wich provide differential backup.

For now, only myIsam tables can be backuped. I follow percona work to handle innodb soon. Postgres must not be hard to handle.

For now, backup is local. Soon, distant copy will be handled with rsync, ftp and even S3.

Beta version is on github : http://github.com/athoune/Drupal-Snapshot/tree/master

Its about drupal installation
I have have uploaded the drupal 6.3
but facing problems in database commands as i am new to mysql and drupal as well
will it be possible for anyone to give few minutes if i forward my account info.
Regards.
gitesh