Arch Linux

cu3edweb

Member

From: USA

Registered: 2007-10-07

Posts: 291

Database backup

My cousin has a site that uses zencart. She is having problems with who she is dealing with and the only access she has to her site is through ftp. Is there a way I can backup the database for her zencart through ftp?

Thanks

cactus

Taco Eater

From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰

Registered: 2004-05-25

Posts: 4,622

Website

Re: Database backup

perhaps she could write a php script to export the contents of the db to a file inside her ftp accessible path, and then ftp the file off.

---

"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Endperform

Member

From: Atlanta GA, USA

Registered: 2007-09-04

Posts: 94

Website

Re: Database backup

I don't believe you can backup through FTP itself, but as cactus mentioned, a php script to do an export should do the trick.  If it's mySQL or Postgres, there are probably a few scripts that do this already.  Additionally, you might want to ask her if her webhost has a control panel.  If so, it's possible something could be done from there as well.

cu3edweb

Member

From: USA

Registered: 2007-10-07

Posts: 291

Re: Database backup

I don't believe you can backup through FTP itself, but as cactus mentioned, a php script to do an export should do the trick.  If it's mySQL or Postgres, there are probably a few scripts that do this already.  Additionally, you might want to ask her if her webhost has a control panel.  If so, it's possible something could be done from there as well.

Yes I know if we had a control panel this would be solved easily. The problem is that where her website is stored is someone she went to high school with and they are having problems but he has only provided her with a ftp login. She is afraid that he is going to shut her site down. I ftp'ed all the files so I have them but I was going to see about backing up the database.

perhaps she could write a php script to export the contents of the db to a file inside her ftp accessible path, and then ftp the file off.

I really don't know how to do that.

cactus

Taco Eater

From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰

Registered: 2004-05-25

Posts: 4,622

Website

Re: Database backup

If the hosting person is known, perhaps the easiest route would be to simply have her ask them (nicely) to provide you with a db dump/backup.

---

"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

cu3edweb

Member

From: USA

Registered: 2007-10-07

Posts: 291

Re: Database backup

That is our first route , but I was just wondering just to know.