Database Backup

[Guest]

How can i Backup my complete database, without using the backup tool on admin????

 

Normally who do you guys, do for backup your databases?????

 

 

 

Best Regards

[spr1nt]

To backup any single database, you just have to type:

code:

mysqldump --add-drop-table -u dbusername -p dbname > dbname.bak.dump
// or better yet...
mysqldump --opt -u dbusername -p dbname > dbname.bak.dump

 

e.g. If I had to backup a certain database with the following details:

MySQL username is jds_user1,

MySQL database name is jds_db1

 

This is what I'd type in:

code:

mysqldump --add-drop-table -u jds_user1 -p jds_db1 > jds_db1.bak.dump
// or better yet...
mysqldump --opt -u jds_user1 -p jds_db1 > jds_db1.bak.dump

 

Now, as soon as you type in your password at the prompt and hit Enter, you will find a file named jds_db1.bak.dump in your WWW root which you can download off your website by just pointing your browser to:

 

http://www.example.com/jds_db1.bak.dump

[spr1nt]

forgot, you can also use phpmyadmin:

 

http://www.tamba2.org.uk/wordpress/backup/

[Guest]

go to mysql.com and download the mysql administrator tool, allows you t do many things, including a backup.

[Guest]

Thaks to all... I Ask this because i add the tables of Live-Help contribution, and i'm try to find the way to backup the entire database, i'll try what you suggest...

 

It's everithing working very well but i want backup the entire database....

 

 

www.kartunes.online.pt

[TCwho]

this is kinda related....

 

when the database sql file starts to get large enough to cause timeouts... Is there an easier to restore the database ...

 

Right now I just manually split the files by copy and pasting in portions...