Following the instructions in the tutorials/FAQ, I backed up the database for the site in my sig. I ended up with a gzipped file of 158KB. Does that sound right?
Thread: database backup question
Results 1 to 5 of 5
-
10 Sep 2007, 04:49 PM #1
Totally Zenned
- Join Date
- Aug 2004
- Location
- New York City
- Posts
- 7,174
- Plugin Contributions
- 0
database backup question
Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.
Holzheimer
Fan Odyssey
-
10 Sep 2007, 05:31 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: database backup question
Does seem kinda small-sounding ...
How big is the .sql file, unzipped?
The .sql file is just a text file. What's it say inside? esp at the bottom?.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
10 Sep 2007, 05:51 PM #3
Totally Zenned
- Join Date
- Aug 2004
- Location
- New York City
- Posts
- 7,174
- Plugin Contributions
- 0
Re: database backup question
Can I unzip it without a db to put it in? My problem is the hosting service went belly up and I'm trying to save the site before the server goes off-line and we lose everything.
I did make a backup a while ago when I was upgrading the site from 1.2.7 to 1.3.7. That zip file is only 41K, so the file size might be right (customers and categories/products have been added since that backup).
I tried looking at the zip file with TextPad, but there's nothing in there intended to be read by humans.
Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.
Holzheimer
Fan Odyssey
-
10 Sep 2007, 05:55 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: database backup question
Winzip can usually unzip a gzip file. The .sql file will be inside it.
Instead of relying on the server to do the backup, you might want to do a manual backup:
https://www.zen-cart.com/tutorials/i...hp?article=103.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
10 Sep 2007, 05:59 PM #5
Totally Zenned
- Join Date
- Aug 2004
- Location
- New York City
- Posts
- 7,174
- Plugin Contributions
- 0
Re: database backup question
I got brave and unzipped it.
It looks like it might be okay. I backed it up using article you mentioned.
Now I just have to convince the store owner that she HAS to find new hosting ASAP. I recommended hosting to her. She just has to get things set up with them.Last edited by afo; 10 Sep 2007 at 06:04 PM.
Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.
Holzheimer
Fan Odyssey
Similar Threads
-
database and backup question
By kmcheng in forum General QuestionsReplies: 1Last Post: 7 May 2011, 04:05 PM -
backup database
By Mad Mat in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 11 Aug 2010, 12:39 AM -
Database Backup
By someguy in forum All Other Contributions/AddonsReplies: 9Last Post: 11 Dec 2008, 02:55 PM -
Backup MySQL Database vs using cPanel backup option?
By IronMan101 in forum All Other Contributions/AddonsReplies: 0Last Post: 30 Jul 2007, 08:46 AM -
Backup my database (database is Farsi and Arabic)
By laserayaneh in forum General QuestionsReplies: 1Last Post: 12 Aug 2006, 08:03 AM
