[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [NOVICE] hjælp til cms



On Mon, 09 May 2005 15:21:28 +0200, Sandi Sørensen wrote:

> Hvis det virker kan du høremis krige af ren glæde!! og tak for hjælpen
> :)))
> 
Så skriger du vist meget højt:o)

Normalt laves backup fra mysql med CLI-kommandoen mysqldump:
Til backup og komplet reetablering: mysqldump --add-drop-table <db> >
db.sql
Til backup og etablering med bestående data: mysqldump test > test.sql

Et eksempel med --add-drop-table:
-- MySQL dump 9.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       4.0.24_Debian-8-log

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `firstname` varchar(32) default NULL,
  `lastname` varchar(32) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `employee`
--


--
-- Table structure for table `qa`
--

DROP TABLE IF EXISTS `qa`;
CREATE TABLE `qa` (
  `id` int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `qa`
--


--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `username` varchar(12) NOT NULL default '',
  `password` varchar(12) NOT NULL default '',
  `name` varchar(100) default NULL,
  `address` varchar(100) default NULL,
  `level` int(11) default '0',
  PRIMARY KEY  (`username`)
) TYPE=MyISAM;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('test','test','Donald Duck','Disney Land',0);
INSERT INTO `user` VALUES ('test1','test1','Road Runner','Santa Monica',2);


-- 
Hilsen/Regards
Michael Rasmussen
http://keyserver.veridis.com:11371/pks/lookup?op=get&search=0xE3E80917



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 21:21 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *