Help, Backup Question

[LondonBoy]

Hi everyone,

I have my DB hosted somewhere, but it's a hosting center that has no phone number. Nehow, if I have a MySQL DB with like 6 databases and many tables in each DB what would be the best way for me to back it up?

If you have a hosted DB, and let's say you loose data, how do you regain it?

Is backing up usually done manually, or is it done through software like backupExec or something? In the context of this being hosted.

Yes i konw i need to change ISPs, but I want to know the process first. Also, if you ask ur ISP to do a rollback, is there a fee for this? A future ISP of ours charge 25$ for it.

Thanks

[Masterslave]

I always backup my site every week. I do this manually.
Via PHPmyadmin I backup the DB manualy (I don't know if your ISP has PHPmyadmin installed).
But this is my way to prevent data lose.

[LondonBoy]

yes we have phpMyadmin
but it would take forever with phpmyAdmin since you have to do it table by table.

And also so often with large tables my computer crashes trying to open the .sql because it's so big.

[Masterslave]

yes we have phpMyadmin
but it would take forever with phpmyAdmin since you have to do it table by table.
Why table by table, you can export the whole database at once in a tar.gz package for example


And also so often with large tables my computer crashes trying to open the .sql because it's so big.I don't get it, why do you open the SQL file. You want to backup your database, right? Then you haven't open anything to export the database.

Only when you open the selected database with PHPmyadmin...:rolleyes:

[aliendisaster]

If you have shell access to the server, you can run the following:

shell> mysqldump [options] --all-databases > mybackup.sql

This will create a backup .sql file on the server. You can simply download that and you have your backup. Here's a link to the manual so you can see all the options:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

When your ready to restore the dump, you can go:

shell> mysql < mybackup.sql