Website database question

[[Neo770]]

Hi all,

I have this website with a database that I need to copy to a subdomain of another site.

How do I make a copy of the database? I cant find anything that looks like a database in the FTP folders.

Both domains have the Plesk 7 domain administrator on them if anyone knows how to use this to export the database.

Thanks.

[vass0922]

you haven't mentioned what kind of database it is?

MySQL?
SQL Server?
Access?
PostGreSQL?
Flat Files?
XML?

If you look at the underlying code, whether it be PHP/ASP you should be able to see the call for a DB, it may not simply be a file.

[[Neo770]]

Oh ok I didnt know there was a difference.

Its a MySQL database, the server is running Redhat 9.

The site is coded with PHP.


This is the main connection code I think. I didnt make this site, and im still a PHP newbi.


function db_connect()
{
$db=mysql_connect("localhost","mitch","******");
mysql_select_db("classiccars",$db);
return $db;
}


I edited out what I guess is the password.

Does this help?

[willy_ph]

I think you'll have to dump the mysql database, then use the dumped file to recreate the contents and structure of the database. With respect to you website management suite, I don't think it'll allow you to do it. But then again, I have no experience with that.

[[Neo770]]

Ok so how the heck do I dump the database, im still very new to this whole web design/administration thing.

[vass0922]

This should help
http://dev.mysql.com/doc/mysql/en/mysqldump.html

Ya know when we had more than one forum for ALL development, there were a few threads regarding this topic... no idea what happened to them now

[[Neo770]]

Thanks vass,

One problem, it looks like I need access to the server either physicaly or through an SSH session or something. Is that right? Or can it be done in like a CGI script?

Maybe this is something I need to ask the aussiehosts admin to do? The subdomain I want to copy to is also an aussiehost server.

[crouse]

Using Plesk 7
Services>Databases>(name of databse)>DB WebAdmin>

http://download1.sw-soft.com/Plesk/P...l/ch03s70.html

------------
or install phpmyadmin for manipulating mysql databases....
http://www.phpmyadmin.net/home_page/

[[Neo770]]

Thanks crouse, unfortunatly backup services are not avialable on this server, there not installed.

So does anyone know how I can get a copy of the database?

[willy_ph]

You could try contacting your hosting provider and ask them what they can do to help you out.