how to fully back up a mysql database?

[Eclipse]

how do i fully back up a mysql database? so if i lose it i can just upload it again and it will work.

[jitender]

On server if you are using the cpanel.

Login to your Cpanel
Click on MySQL Database
User PhpMyadmin link at bottom - it open a window with all databases.
select the database
now right site frame - click on export database
select the tables and select the save file option - Submit it

It will start downloading the SQL file, save it in your computer

Regards
Jitender

[seolion]

You can dump the whole database at a stretch as well. Need not be one table by one table..

[jitender]

if you are using the cpanel.. you can also use the backup option for full database backup

regards
Jitender

[dynaweb]

For database only backup, I like the export option in phpMyAdmin

[jitender]

yes..

PHPMYADMIN is a good option for database back, chose all tables and export in your fav. format...

[Eclipse]

thanks i have done that i just use the option in cpanel

[dugu]

It is considered ok to backup your database once a week. Servers can crush and you can loose unsaved data. I'm know waht I'm talking about.

[Eclipse]

i try and update my database's every day

[jitender]

you mean backup your database every day...