[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]![]() |
![]() |
![]() |
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||||
![]() |
![]() |
![]() |
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
![]() |
![]() |
![]() |
||||||||||||
|
||||||||||||||
![]() | ||||||||||||||
|
||||||||||||||
![]() |
![]() |
![]() |