Doug Fairchild [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 12:48
Doug Fairchild
[OT] SQL Databases Backing Up & Restoring
Hi, folks ...
I'm fumbling my way through learning to set up and manage ZenCart and am in a bit of an ignoramus's quandary here. I'm reading the PHPmyAdimin docs and trying to find out for future emergencies and to enhance my knowledge, how to backup and restore the database.
I got a little way into it and the documentation didn't say what to do at this point, or I missed it. I have clicked on the button that says "Backup" and am at a page of plain text that looks like the source for the database.
It's very long but heres the start of it: ======================== -- phpMyAdmin SQL Dump -- version 2.10.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 01, 2008 at 03:28 PM -- Server version: 5.0.67 -- PHP Version: 5.2.6
CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0',
.... etc.
=========================== That is where I stopped. It didn't say what to do with it. It just sat there on my screen. No "save to disk" button or anything of the sort, unless I just couldn't find it. Before I screw something up irredeemably, can one of you geniuses tell me what I do now? Do I copy this file and save it locally, and then when I want to restore it, click on the restore button and navigate to the file on my hard drive, or what?
I want to try some other things, but want to have the database actually saved so I can restore it so that when I get to the unknown but inevitable place where I mess up, I can restore it and be back in business.
Sorry to be a nuisance, but I am reading the documentation, and I guess I am just to inexperienced to understand it. The control panel I used on another host allowed me to just backup the database and restore it without knowing how to do anything but click on buttons. It didn't expect me to know how it was done, I guess. :-)
Best regards,
Doug
-- This list is a free service of LassoSoft: http://www.LassoSoft.com/ Search the list archives: http://www.ListSearch.com/GoLive/Browse/ Manage your subscription: http://www.ListSearch.com/GoLive/
Sep 01
Roger Henriques Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:25
Roger Henriques
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Doug Fairchild Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:34
Doug Fairchild
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Pieter Roosens Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:36
Pieter Roosens
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Doug Fairchild Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:41
Doug Fairchild
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Doug Fairchild Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:43
Doug Fairchild
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Pieter Roosens Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:46
Pieter Roosens
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Doug Fairchild Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:49
Doug Fairchild
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Roger Henriques Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:50
Roger Henriques
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Doug Fairchild Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 13:56
Doug Fairchild
Re: [OT] SQL Databases Backing Up & Restoring
Sep 01
Roger Henriques Re: [OT] SQL Databases Backing Up & Restoring
Sep 01, 2008; 14:02
Roger Henriques
Re: [OT] SQL Databases Backing Up & Restoring
Sep 02
hart Re: [OT] SQL Databases Backing Up & Restoring
Sep 02, 2008; 09:08
hart
Re: [OT] SQL Databases Backing Up & Restoring
Sep 02
Miles A Cruickshank Re: [OT] SQL Databases Backing Up & Restoring
Sep 02, 2008; 09:18
Miles A Cruickshank
Re: [OT] SQL Databases Backing Up & Restoring
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!