How do I back up my database SQL?

Just wondering how I would go about backing up my database. I use hostgator. Check my sig for the site to help with these other questions.

Other questions:
1) After you select a subdir for articles is shows them in the order of oldest to newest. How do I change that?
2) Is there a way to insert links into the script which creates the navbar on the left (check the source code)
3) Can I hide navbar links so I create content in a certain category but not have it listed on the main page (as to create artificial subcategories)

Your help is GREATLY appreciated.

 

Sorry I forget to add the url.http://www.buildurbody.com

 

Just login to your phpadmin and find the database name, then export it to your hard drive. You will then have a current copy of your DB

 

i use sqldumper.de (free) it worked great on my site. But if you have a small enough thing you can just do it through phpmyadmin

 

I also use sqldumper...fantastic little script

 

z0mg.. at command prompt:

mysqldump --add-drop-table -h your.db.hostname.net -u root -p password > entire.database.back.sql

Code (markup):

done. why use a script? LOL

 

Like roseau said, just go to phpadmin, click export then select .sql and click 'go'. It will save it as a .sql file. You can then import this .sql file into any database you want to be able to use it (or simply save it for backup purposes). I hope this helps

 

I suggest running mysqldump utility via crontab (linux) or schedule (windows). It gives you comfort of having last 5-10 days database backup. Sometimes it's very helpful.

 

Command line is the best way, go and get a SSH access.
phpmyadmin is unreliable if you have a huge database/table.

 

I have been using phpadmin works fine for me.........
command is better though....

if dont know how to use....phpadmin etc...pm me i will tell u

 

Hi OreoKnight,

I use Amanda open source backup (http://amanda.zmanda.com/) to take daily remote backups. The setup isn't too hard and you can just add it to cron and forget it.

Petey

 

Petey,

If you can add a cron job to "Amanda" why not just use the utility that comes with MySQL? What's the purpose of installing another piece of software if mysqldump is fully capable of achieving the same thing?

-j0ned

 

Hi j0ned,

I use Amanda because I want to manage daily, weekly, monthly backups across a number of servers from a single backup server. All of the crontab entries are made in the backup server rather than spread across the individual database servers. Amanda lets me set this up easily and I can do useful stuff like set data retention policies.

And (because I am slightly paranoid ) I use rsync to transfer the backup directories onto yet another server.

This time last year I was just doing mysqldumps but that was before one of my ISPs had two disks fail in a RAID 5 array

Petey

 

Aaahh! So you've got a pretty large operation going on I can relate on the slight paranoia, I'm the same way. Thanks for answering my questions - makes total sense.

 

I like to use mysqldump via ssh - you can set up a cron job to make a backup every night if you want.

 

i too use shell..........thats the best way