Problem with mySQL backup

[Shantra]

I have read som posts about this topic but I can't make it work.

This is the code I try to use in myPHPadmin:

mysqldump -hlocalhost -uUSERNAME -pPASSWORD -nDATABASENAME >./backup/backup.sql

It don't work!! I want the file to be placed in the public_html/backup folder on my server.
I use Hostrocket as a host.

If I get this problem solved, how do I transfer the file to my hardisc?
Since there is both text and images in the database I was wondering if I should use a ASCII or Binary transfer.
I use a standard ftp program!

What should I do when I want to upload the file again using myPHPadmin? What code?

Thanks!

[lieblick]

If you can connect via shell ... that's what I'd do ...

CD to your login directory /home/...

From outside of mySQL type:
mysqldump -u USERNAME -p DATABASENAME > blah.sql
<passwd prompt>: PASSWORD

The file should be located in whatever directory you're in ... then just ftp to the site and grab it on down!

If you want to upload the file again, just upload it ...

To restore a dump though, you may have to delete all of the information ...

cat blah.sql | mysql -u USER -p DATABSENAME
<passwd prompt>:PASSWORD

Hope that helps some ...

[Shantra]

lieblick,
Actually I would like to use the code in myPHPadmin, not trough telnet/shell!

I know that making the backup inside myPHPadmin is not safe, but it should OK to use the mySQL commands. Or?

Here is what I'd like to do:
BACKUP
- Execute a mysqldump command inside myPHPadmin
- Download the file to my hardisc via FTP
UPLOAD
- Copy the code in the file into myPHPadmin and run it

You don't say anything about ASCII or Binary. Does it not matter which I use?

Thanks

[tubedogg]

You can't execute any command like that in phpMyAdmin. You would need to use Telnet/SSH.

[Shantra]

OK!

Then I have to use telnet, wont I!!!
Why isn't things easy.

But what about that ASCII/Binary question?

Thanks folks!!

[tubedogg]

For a database dump, use ASCII.

[Shantra]

Thanks tubedoggy!!!

[lieblick]

I've had basic experience with phpMyAdmin ... I used it once for a huge database replacement ... after which, I took the command set it gave me (it was kinda complicated) and saved it for future use from shell ...

phpMYAdmin is nice ... but if you have access ... shell is the way to do it!

Hope it works out ... it always does!

[Defender1]

hwo is it not safe to do a dump with phpmyadmin?

unfortunately my new host doesn't allow shell access, so i can't use telnet for mysql commands.

someone wanna tell me how in the heck i'm suppose to make a backup to store on my hdd with phpmyadmin?

[Shantra]

Originally posted by Defender1
hwo is it not safe to do a dump with phpmyadmin?

unfortunately my new host doesn't allow shell access, so i can't use telnet for mysql commands.

someone wanna tell me how in the heck i'm suppose to make a backup to store on my hdd with phpmyadmin?

I tried to use phpmyadmin for backing up one of my databases. It did NOT work. The rest of my databases went well.

For your question: I don't know!!! Try and see if it works.