} $msg .= 'Created / updated database user: '******'login'] . '<br />'; } add_command('# DATABASES'); $databases = $exdb->queryAllRecords("SELECT d.id, d.name, d.type, d.dom_id, d.db_server_id, d.default_user_id FROM `data_bases` as d"); foreach ($databases as $database) { $params = array('server_id' => $server_id, 'parent_domain_id' => $domain_ids[$database['dom_id']], 'type' => 'mysql', 'database_name' => $database['name'], 'database_user_id' => $db_userids[$database['id']], 'database_ro_user_id' => 0, 'database_charset' => 'utf8', 'remote_access' => 'n', 'active' => 'y', 'remote_ips' => ''); $client_id = $plesk_ispc_ids[$domain_owners[$database['dom_id']]]; $check = $app->db->queryOneRecord('SELECT * FROM `web_database` WHERE `database_name` = \'' . $app->db->quote($database['name']) . '\''); if ($check) { $ok = $importer->sites_database_update($session_id, $client_id, $check['database_id'], array_merge($check, $params)); if ($ok === false) { $msg .= " Error: " . $importer->getFault() . "<br />"; } } else { $importer->sites_database_add($session_id, $client_id, $params); } add_command('for T in `mysql -u ${MYSQL_IMPORT_USER} -p${MYSQL_IMPORT_PASS} ' . $database['name'] . ' -e \'show tables\' | awk \'{ print $1}\' | grep -v \'^Tables\'` ; do echo "DROP TABLE \\`$T\\`" ; mysql -u ${MYSQL_IMPORT_USER} -p${MYSQL_IMPORT_PASS} ' . $database['name'] . ' -e "DROP TABLE \\`$T\\`" ; done'); add_command('mysqldump -cCQ --quote-names --hex-blob -h ${MYSERVER} -u ${MYSQL_EXPORT_USER} -p${MYSQL_EXPORT_PASS} ' . $database['name'] . ' | mysql -D ' . $database['name'] . ' -u ${MYSQL_IMPORT_USER} -p${MYSQL_IMPORT_PASS}'); $msg .= 'Created / updated database: ' . $database['name'] . '<br />'; } // do we need table disk_usage for import? i think we don't // name is domain name, displayName is including "Umlaute" //$anon_ftp = $exdb->queryAllRecords("SELECT f.id, f.dom_id, f.max_conn, f.bandwidth, f.incoming, f.incoming_readable, f.incoming_subdirs, f.status, f.quota, f.display_login, f.login_text FROM anon_ftp as f"); //DomainServices //id, dom_id, type, status, parameters_id, ipCollectionId //DomainsTraffic //dom_id, date, http_in, http_out, ftp_in, ftp_out, smtp_in, smtp_out, pop3_imap_in, pop3_imap_out //IP_Adresses //id, ip_address, mask, iface, ssl_certificate_id, default_domain_id, ftps, main, status //ip_pool