Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Backup


Guest

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...