Adding Page Content Via Installation Profile

Maybe it's too difficult or too much to ask, but do you know any other way of making a copy of the site and create the "myownprofile.profile" with general characteristics for installing it in other sites? is it the only way by programming?

I hope someone will answer
Vi

i am not geting user table value and module is not enabled into new site
so please help me when i use to import .sql file using profile

My import function for SQL won't run out of memory. It assumes that lines end with ";", so it won't work if they don't. This should be ok with phpmyadmin dumps.

/**
 * this will import a very large sql dump
 * @param string $filename the full path to the SQL file
 * like dirname(__FILE__).'/site.sql'
 * @return integer the number of queries executed
 */

function import_sql($filename){
  $buffer='';
  $count=0;
  $handle = @fopen($filename, "r");
  if ($handle) {
      while (!feof($handle)) {
          $line = fgets($handle, 4096);
          $buffer.=$line;
          if(preg_match('|;$|', $line)){
            $count++;
            _db_query($buffer);
            $buffer='';
          }
      }
      fclose($handle);
  }
  return $count;
}

If you are already going the mysql dump route, then you might as well just import all your settings, modules, and everything (it's a lot easier then sorting through things and it will allow you to just import everything)

I made a simple install profile using this principal:
http://drupal.org/project/sql

If you prefer to be lots more selective (and cross-DB) you can get modules, variables, and content-types for install profiles pretty easily by using a running site:

// put these in a PHP node somewhere
$variables = variable_init();

$t = node_get_types('types', NULL, TRUE);
foreach($t as $type_name=>$type){
  $node_types[$type_name]=(array)$type;
}

$m = system_modules();
foreach($m['validation_modules']['#value'] as $modulename=>$moduledata){
  if($moduledata->status){
    $modules[]=$modulename;
  }
}

print '<pre>';
print '$variables='.var_export($variables,TRUE).";\n";
print '$types='.var_export($node_types,TRUE).";\n";
print '$modules='.var_export($modules,TRUE).";\n";
print '</pre>';

You can use these outputs (cut and paste) in your own profile_modules(), and profile_final() functions to add them back.

You can use one of these to utilize this principal, if you need something more advanced:
http://drupal.org/project/install_profile_api
http://drupal.org/project/profile_generator

Here is site.profile file that loads whole sql dump during installation. The dump stored in dump.sql and should be placed in the same directory as .profile file

<?php

    define('PROFILE_NAME', 'site');
    define('PROFILE_DESCRIPTION', 'Custom site profile');
    function site_profile_modules() {
    return array();
    }

    function site_profile_details() {
    return array(
    'name' => PROFILE_NAME,
    'description' => PROFILE_DESCRIPTION,
    );
}

    function site_form_alter(&$form, $form_state, $form_id) { 
    if ($form_id == 'install_configure') {
    $form['#submit'][] = 'site_form_submit';
    }
}

    function site_form_submit($form, &$form_state) {
    $dump_file = dirname(__FILE__) . '/dump.sql';
    $success = import_dump($dump_file);
    if (!$success) {
    return;
    }
	
    variable_set('site_name', $form_state['values']['site_name']);
    variable_set('site_mail', $form_state['values']['site_mail']);
    variable_set('date_default_timezone', $form_state['values']['date_default_timezone']);
    variable_set('clean_url', $form_state['values']['clean_url']);
    variable_set('update_status_module', $form_state['values']['update_status_module']);
    variable_del('file_directory_temp');  
    $name = $form_state['values']['account']['name'];
    $pass = $form_state['values']['account']['pass'];
    $mail = $form_state['values']['account']['mail'];
    db_query("UPDATE {users} SET name = '%s', pass = MD5('%s'), mail = '%s' WHERE uid = 1", $name, $pass, $mail);
    user_authenticate(array('name' => $name, 'pass' => $pass));
    drupal_goto('<front>');
}

    function import_dump($filename) {
    if (!file_exists($filename) || !($fp = fopen($filename, 'r'))) {
    drupal_set_message(t('Unable to open dump %filename.', array('%filename' => $filename)), 'error');
    return FALSE;
    }

    foreach (list_tables() as $table) {
    db_query("DROP TABLE %s", $table);
    }
	
    $success = TRUE;
    $query = '';
    $new_line = TRUE;

     while (!feof($fp)) {
     $data = fgets($fp);
     if ($data === FALSE) {
     break;
     }
	 
     if ($new_line && ($data == "\n" || !strncmp($data, '--', 2) || !strncmp($data, '#', 1))) {
     continue;
     }

     $query .= $data;
     $len = strlen($data);
     if ($data[$len - 1] == "\n") {
     if ($data[$len - 2] == ';') {
     if (!_db_query($query, FALSE)) {
     $success = FALSE;
     }
     $query = '';
     }
     $new_line = TRUE;
     } else {
     $new_line = FALSE;
     }
}
     fclose($fp);

     if (!$success) {
     drupal_set_message(t('An error occured when importing the file %filename.', array('%filename' => $filename)), 'error');
     }
     return $success;
     }

     function list_tables() {
     global $db_prefix;
     $tables = array();
     if (is_array($db_prefix)) {
     $rx = '/^' . implode('|', array_filter($db_prefix)) . '/';
     }
     else if ($db_prefix != '') {
     $rx = '/^' . $db_prefix . '/';
     }

     switch ($GLOBALS['db_type']) {
     case 'mysql':
     case 'mysqli':
     $result = db_query("SHOW TABLES");
     break;
     case 'pgsql':
     $result = db_query("SELECT table_name FROM information_schema.tables WHERE table_schema = '%s'", 'public');
     break;
     }

     while ($table = db_fetch_array($result)) {
     $table = reset($table);
     if (is_array($db_prefix)) {
     if (preg_match($rx, $table, $matches)) {
     $table_prefix = $matches[0];
     $plain_table = substr($table, strlen($table_prefix));
     if ($db_prefix[$plain_table] == $table_prefix || $db_prefix['default'] == $table_prefix) {
     $tables[] = $table;
     }
   }
}
     else if ($db_prefix != '') {
     if (preg_match($rx, $table)) {
     $tables[] = $table;
     }
}
     else {
     $tables[] = $table;
     }
}
     return $tables;
}