How to backup database data without direct server access

[Colin Finck]

Hello!
I need to backup a MySQL database (MySQL 4.0). But it is on a
shared-hosting web server and so I don't have direct server access. I
also have no phpMyAdmin installed.
How can I backup the database? I think it is possible with PHP
(version 5.0.2 is installed on the web server) to create a file with
SQL commands which restore the data, but what is the easiest way to do
it?

Thanks in advance!

Colin Finck

[Mike A.]

If you can connect with the client software to the MySQL port on the host
system (port 3306), you can run mysqldump locally and the .sql file it
produces will be on your local system.
--
Mike Argy
Custom Office solutions
and Windows/UNIX/OSX programs

[Colin Finck]

"Mike A." <re***@newsgroup.please> wrote

If you can connect with the client software to the MySQL port on the host
system (port 3306), you can run mysqldump locally and the .sql file it
produces will be on your local system.

I tried the following command:

mysqldump --host=www.MyWebsite.de --user=MyUserName
--password=MyPassword MyDatabaseName

But I received:

mysqldump: Got error: 1045: Access denied for user
'MyUserName'@'ACB2887C.ipt.aol.com' (using password: YES) when trying
to connect

Did I do something wrong?

Best regards!

Colin Finck

[steve]

"Colin Finck" wrote:

Hello!
I need to backup a MySQL database (MySQL 4.0). But it is on a
shared-hosting web server and so I don't have direct server
access. I
also have no phpMyAdmin installed.
How can I backup the database? I think it is possible with PHP
(version 5.0.2 is installed on the web server) to create a
file with
SQL commands which restore the data, but what is the easiest
way to do
it?

Thanks in advance!

Colin Finck

Let me ask you a dumb question. How do you interact with the database
and get anything done if you don’t have phpmyadmin installed. So
seems to me you need that anyways. If so, then your question is
already answered.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-backup...ict219315.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=758556