how to make a backup

[iffoiffy]

Hi,

I am hosting a website at a hosting company. I have Mysql database, using phpMyAdmin 2.5.1. How can I make a back up of my database?

Thanks

 

[Bastien]

PMA has the export facility. it makes a sql backup of your db...

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[iffoiffy]

thanks........ but i did not see any option at PMA that talks about making back up of your database

 

[Bastien]

There is (usually) a tab called export, it depends on what your host allows. Your control panel may also have that functionality on it

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[SantaMufasa]

Iffoiffy,

In the absence of finding what you want from PMA, you can achieve your objective from your o/s prompt using the "mysqldump" utility:

mysqldump --help

...gives you an on-screen rundown of all the mysqldump options. As an example of what we use to backup our databases, we:

mysqldump --opt --user=<username> --password=<password> --databases <db_name(s)>
********************************************************************************

Let us know if this helps resolve your need.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

 

[kupe]

It's often easiest to do it back at the folder. Copy the db and rename it, done in a second. Cheers.